SAP table ACCRBD (Accruals/Deferrals Master Data - Basic Data)
SAP table ACCRBD has 3 primary key fields being MANDT,BUKRS,BELNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Company Code
CHAR
4
0
BUKRS
Accrual/Deferral Document
CHAR
10
0
ACCRBELNR
ERDAT
Date on which the record was created
DATS
8
0
ERDAT
ERNAM
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
AEDAT
Last Changed On
DATS
8
0
AEDAT
AENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
DOCTYP
Accrual/Deferral Profile
CHAR
2
0
ACCRCUST
ACCRDOCTYP
LVORM
Deletion Indicator
CHAR
1
0
LVORM
BLDAT
Document Date in Document
DATS
8
0
BLDAT
WRBTR
Amount in document currency
CURR
23
2
WRBTR
WAERS
Currency Key
CUKY
5
0
TCURC
WAERS
DATAB
Valid-From Date
DATS
8
0
DATAB
DATBI
Valid To Date
DATS
8
0
DATBI
ATEXT
Text (30 Characters)
CHAR
30
0
TEXT30
ATYPE
Accrual Type
CHAR
1
0
ACCRTYPE
Possible values
1
Deferred
2
Accrued
3
Deferred Fixed Values
4
Accrued Fixed Values
XBELNR
Accrual/Deferral Reference Document
CHAR
16
0
ACCRXBELNR
STGMETH
Daily Method
NUMC
1
0
VVSTGMETH
Possible values
1
360E
2
Act
3
365
4
360
5
ActW
6
360 ISDA
7
m+act
8
m+30
9
360 German
HKONT
Accrual/Deferral Profit and Loss Account
CHAR
10
0
ACCEKONT
ACCHKONT
Accrual/Deferral Balance Sheet Account
CHAR
10
0
ACCHKONT
ACCRBD foreign key relationships
Table
Field
Check Table
Check Field
0 ACCRBD
DOCTYP
ACCRCUST Accrual/Deferral Profile
BUKRS
0 ACCRBD
DOCTYP
ACCRCUST Accrual/Deferral Profile
DOCTYP
1 ACCRBD
MANDT
T000 Clients
MANDT
0 ACCRBD
WAERS
TCURC Currency Codes
MANDT
0 ACCRBD
WAERS
TCURC Currency Codes
WAERS