BSEC SAP (One-Time Account Data Document Segment) Cluster Table details

Dictionary Type: Cluster Table
Description: One-Time Account Data Document Segment




ABAP Code to SELECT data from BSEC
Related tables to BSEC
Access table BSEC




Cluster Table field list including key, data, relationships and ABAP select examples

BSEC is a standard SAP Cluster Table which is used to store One-Time Account Data Document Segment data and is available within R/3 SAP systems depending on the version and release level.

The BSEC table consists of various fields, each holding specific information or linking keys about One-Time Account Data Document Segment data available in SAP. These include BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BSEC cluster table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
PSKTOAccount Number of Bank Account At Post Office PSKTOCHAR16PSKTO
BANKNBank account number BANKNCHAR18BANKN
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKSBank country key BANKSCHAR3T005LAND1BKL
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STKZULiable for VAT STKZUCHAR1XFELD
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
BKONTBank Control Key BKONTCHAR2BKONT
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
EMPFGPayee code EMPFGCHAR16EMPFG
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
FITYPTax type J_1AFITP_DCHAR2J_1AFITPJ_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2J_1ATODCJ_1ATOID
STKZNNatural Person STKZNCHAR1STKZN
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
BKREFReference specifications for bank details BKREFCHAR20CHAR20
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30BUSTYPEGESTYP
J_1KFTINDType of Industry INDTYPCHAR30INDUSTYPEINDTYP
ANREDTitle ANREDCHAR15TEXT15
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
XRGUHIndicator: Bank Details from REGUH XRGUHCHAR1XRGUH
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table BSEC using ABAP code

The following ABAP code Example will allow you to do a basic selection on BSEC to SELECT all data from the table
DATA: WA_BSEC TYPE BSEC.

SELECT SINGLE *
FROM BSEC
INTO CORRESPONDING FIELDS OF WA_BSEC
WHERE...

How to access SAP table BSEC

Within an ECC or HANA version of SAP you can also view further information about BSEC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!