queryviz
tables/relationship path
open in builder
T002
SPRAS
CSKT
KOSTL
CSKS
KOSTL
BSAS

BSAS

accounting: secondary index for g/l accounts (cleared items)
fi21f · 9k · 6r
Replaced by ACDOCA
Cleared G/L items secondary index replaced by CDS views on ACDOCA.
key differences:
  • •Cleared status determined by non-null clearing date (AUGDT) in ACDOCA
  • •CDS view I_OperationalAcctgDocItem with AUGDT filter replaces BSAS

fields (21)

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
BLARTchar2document type
BSCHLchar2posting key
BUDATdats8posting date in the document
DMBTRcurr13amount in local currency
KOSTLchar10cost center
MONATnumc2fiscal period
PRCTRchar10profit center
SGTXTchar50item text
SHKZGchar1debit/credit indicator
WAERScuky5currency key
WRBTRcurr13amount in document currency
XBLNRchar16reference document number

relationships (6)

configuration

reference to config tables

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

reference to master data

references
CSKS
KOSTLKOSTL
N:1
SKA1
HKONTSAKNR
N:1
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms