Name: SAP Table BSAD |Field Definitions and Relationships
Creator: QueryViz.io

fields (20)

field	type	length	key	description
`AUGBL`	char	10	pk	clearing document number
`AUGDT`	dats	8	pk	clearing date
`BELNR`	char	10	pk	accounting document number
`BUKRS`	char	4	pk	company code
`BUZEI`	numc	3	pk	number of line item within accounting document
`GJAHR`	numc	4	pk	fiscal year
`KUNNR`	char	10	pk	customer number
`MANDT`	clnt	3	pk	client
`UMSKS`	char	1	pk	special g/l transaction type
`UMSKZ`	char	1	pk	special g/l indicator
`ZUONR`	char	18	pk	assignment number
`BLART`	char	2		document type
`BUDAT`	dats	8		posting date in the document
`DMBTR`	curr	13		amount in local currency
`HKONT`	char	10		general ledger account
`PRCTR`	char	10		profit center
`SGTXT`	char	50		item text
`SHKZG`	char	1		debit/credit indicator
`WAERS`	cuky	5		currency key
`WRBTR`	curr	13		amount in document currency

relationships (4)

configuration

reference to config tables

references

master lookup

reference to master data

references

field	type	length	key	description
`AUGBL`	char	10	pk	clearing document number
`AUGDT`	dats	8	pk	clearing date
`BELNR`	char	10	pk	accounting document number
`BUKRS`	char	4	pk	company code
`BUZEI`	numc	3	pk	number of line item within accounting document
`GJAHR`	numc	4	pk	fiscal year
`KUNNR`	char	10	pk	customer number
`MANDT`	clnt	3	pk	client
`UMSKS`	char	1	pk	special g/l transaction type
`UMSKZ`	char	1	pk	special g/l indicator
`ZUONR`	char	18	pk	assignment number
`BLART`	char	2		document type
`BUDAT`	dats	8		posting date in the document
`DMBTR`	curr	13		amount in local currency
`HKONT`	char	10		general ledger account
`PRCTR`	char	10		profit center
`SGTXT`	char	50		item text
`SHKZG`	char	1		debit/credit indicator
`WAERS`	cuky	5		currency key
`WRBTR`	curr	13		amount in document currency

configuration

reference to config tables

references

master lookup

reference to master data

references