queryviz
tables/relationship path
open in builder
TSPA
SPART
KNVP
VKORG
TVKO
BUKRS
T001
BUKRS
BSAK

BSAK

accounting: secondary index for vendors (cleared items)
fi20f · 11k · 4r
Replaced by ACDOCA
Cleared vendor 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 BSAK

fields (20)

fieldtypelengthkeydescription
AUGBLchar10pkclearing document number
AUGDTdats8pkclearing date
BELNRchar10pkaccounting document number
BUKRSchar4pkcompany code
BUZEInumc3pknumber of line item within accounting document
GJAHRnumc4pkfiscal year
LIFNRchar10pkaccount number of vendor or creditor
MANDTclnt3pkclient
UMSKSchar1pkspecial g/l transaction type
UMSKZchar1pkspecial g/l indicator
ZUONRchar18pkassignment number
BLARTchar2document type
BUDATdats8posting date in the document
DMBTRcurr13amount in local currency
HKONTchar10general ledger account
PRCTRchar10profit center
SGTXTchar50item text
SHKZGchar1debit/credit indicator
WAERScuky5currency key
WRBTRcurr13amount in document currency

relationships (4)

configuration

reference to config tables

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

reference to master data

references
LFA1
LIFNRLIFNR
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms