27

7-Oct-2017: SAP cluster table unpacker

 4 years ago
source link: https://yurichev.com/blog/SAP/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
SAP cluster table unpacker

7-Oct-2017: SAP cluster table unpacker

SAP has a special cluster tables located in SAPSR3.RFBLG table (as of Oracle RDBMS), which contains compressed blob data for tables like BSEG, BSET, BSEC, BSED, etc.

There is a speculation that at some distant point of history, Oracle RDBMS didn't have support for >256 columns, but SAP needed more (>300), so they packed all columns into compressed blob.

I've just written an utility to unpack these tables, here are first ~60 columns (empty columns are suppressed) for demo IDES database:

unpack_chunk() name=BSEG       MANDT=800 BUKRS=0001 BELNR=0100000000 GJAHR=1995 BUZEI=001
BUZEI: [001]
BSCHL: [40]
DMBTR: [6,14]
WRBTR: [12,00]
PSWBT: [6,14]
PSWSL: [EUR  ]
VALUT: [19950606]
ZUONR: [19950606          ]
SGTXT: [(text)                                            ]
VORGN: [RFBU]
HKONT: [0000100000]
unpack_chunk() name=BSEG       MANDT=800 BUKRS=0001 BELNR=0100000000 GJAHR=1995 BUZEI=002
BUZEI: [002]
BSCHL: [50]
DMBTR: [6,14]
WRBTR: [12,00]
PSWBT: [6,14]
PSWSL: [EUR  ]
ZUONR: [19950606          ]
VORGN: [RFBU]
KOKRS: [0001]
HKONT: [0000399999]
unpack_chunk() name=BSEG       MANDT=800 BUKRS=0005 BELNR=0100000000 GJAHR=2005 BUZEI=001
BUZEI: [001]
BSCHL: [40]
DMBTR: [60000,00]
WRBTR: [60000,00]
PSWBT: [60000,00]
PSWSL: [EUR  ]
VALUT: [20051231]
ZUONR: [20051231          ]
SGTXT: [Test for Allocation FI                            ]
ALTKT: [0000110100]
VORGN: [RFBU]
FDLEV: [F0]
FDWBT: [60000,00]
FDTAG: [20051231]
KOKRS: [1000]
HKONT: [0000113100]

It's somewhat unfinished, but the source code is available: https://yurichev.com/tmp/SAP_cluster_unpacker.tar.bz2.

→ [list of blog posts]


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK