queryviz
tables/relationship path
open in builder
T002
SPRAS
CSKT
KOKRS, KOSTL
CSKS
WAERS
TCURC
WAERS
BSIS

BSIS

accounting: secondary index for g/l accounts (open items)
fi23f · 9k · 7r
Replaced by ACDOCA
G/L open items secondary index replaced by CDS views on ACDOCA. Use account type filter (KOART = S) for G/L items.
key differences:
  • •No separate open/cleared split — use clearing date (AUGDT) to determine status
  • •CDS view I_OperationalAcctgDocItem replaces direct table access
  • •G/L line items filtered by account type (KOART = S) in ACDOCA

fields (23)

fieldtypelengthkeydescription
AUGBLchar10pkclearing document number
AUGDTdats8pkclearing date
BELNRchar10pkaccounting document number
BUKRSchar4pkcompany code
BUZEInumc3pknumber of line item within accounting document
GJAHRnumc4pkfiscal year
HKONTchar10pkgeneral ledger account
MANDTclnt3pkclient
ZUONRchar18pkassignment number
AUFNRchar12order number
BLARTchar2document type
BSCHLchar2posting key
BUDATdats8posting date in the document
DMBTRcurr13amount in local currency
GSBERchar4business area
KOSTLchar10cost center
MONATnumc2fiscal period
PRCTRchar10profit center
SGTXTchar50item text
SHKZGchar1debit/credit indicator
WAERScuky5currency key
WRBTRcurr13amount in document currency
XBLNRchar16reference document number

relationships (7)

configuration

reference to config tables

references
TBSL
BSCHLBSCHL
N:1
TGSB
GSBERGSBER
N:1
T003
BLARTBLART
N:1
T001
BUKRSBUKRS
N:1
TCURC
WAERSWAERS
N:1
master lookup

reference to master data

references
SKA1
HKONTSAKNR
N:1
CSKS
KOSTLKOSTL
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms