SAP table BSEC (One-Time Account Data Document Segment)

SAP table BSEC has 5 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI.

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
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 35 0 ORT01_GP
LAND1 Country/Region Key CHAR 3 0 T005 LAND1_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSKTO PO Bank Current Acct No. or Building Society Ref. No. CHAR 16 0 PSKTO
BANKN Bank account number CHAR 18 0 BANKN
BANKL Bank Keys CHAR 15 0 BANKK
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZU Liable for VAT CHAR 1 0 STKZU
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
BKONT Bank Control Key CHAR 2 0 BKONT
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 DTAWS
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
EMPFG Payment Recipient Code CHAR 16 0 EMPFG
SPRAS Language Key LANG 1 0 T002 SPRAS
FITYP Tax type CHAR 2 0 J_1AFITP J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 J_1ATODC J_1ATOID
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 BUSTYPE GESTYP
J_1KFTIND Type of Industry CHAR 30 0 INDUSTYPE INDTYP
ANRED Title CHAR 15 0 ANRED
ADRNR Address CHAR 10 0 ADRNR
XRGUH Indicator: Bank Details from REGUH CHAR 1 0 XRGUH
One Time Account or Alternative Payee
D Delete Payment Data
X Payment Data from REGUH
PO_BOX_NUM Flag: PO Box Without Number CHAR 1 0 AD_POBXNUM
BEGRU Authorization Group CHAR 4 0 BEGRU
STCD5 Tax Number 5 CHAR 60 0 STCD5
INTAD Internet address of partner company clerk CHAR 130 0 INTAD
GLO_RE1_OT Ctry/Reg. Specific Reference in the One Time Account Data CHAR 140 0 FAC_GLO_REF1_OT
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

BSEC foreign key relationships

Table Field Check Table Check Field
0 BSEC BANKS T005 Countries MANDT
0 BSEC BANKS T005 Countries LAND1
1 BSEC BUKRS T001 Company Codes BUKRS
0 BSEC FITYP J_1AFITP Tax Types MANDT
1 BSEC J_1KFTBUS BUSTYPE Type of Business GESTYP
0 BSEC J_1KFTIND INDUSTYPE Type of Industry MANDT
0 BSEC J_1KFTIND INDUSTYPE Type of Industry INDTYPE
1 BSEC LAND1 T005 Countries MANDT
1 BSEC LAND1 T005 Countries LAND1
0 BSEC MANDT T000 Clients MANDT
1 BSEC REGIO T005S Taxes: Region (Province) Key LAND1
0 BSEC SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 BSEC STCDT J_1ATODC Type of identification J_1ATODC