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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	CLUSTER	Cluster table
Cluster table	BSEC	Table Relationship Diagram
Short Description	One-Time Account Data Document Segment

Delivery and Maintenance

Pool/cluster	RFBLG
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
7	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
8	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
9	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
10	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
11	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
12	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
13	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
14	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
15	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
16	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
17	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
18	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
19	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
20	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
21	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
22	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
23	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
24	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
25	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
26	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
27	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
28	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
29	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
30	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
31	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
32	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	J_1ATODC
33	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
34	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
35	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
36	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
37	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
38	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	BUSTYPE
39	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	INDUSTYPE
40	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
41	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
42	XRGUH	☐	XRGUH	XRGUH	CHAR	1	0	Indicator: Bank Details from REGUH
43	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BSEC	BANKS	T005	LAND1	REF	1	CN
2	BSEC	BUKRS	T001	BUKRS	KEY	1	CN
3	BSEC	FITYP	J_1AFITP	J_1AFITP		1	CN
4	BSEC	J_1KFTBUS	BUSTYPE	GESTYP	REF	C	CN
5	BSEC	J_1KFTIND	INDUSTYPE	INDTYPE	REF	C	CN
6	BSEC	LAND1	T005	LAND1	REF	1	CN
7	BSEC	MANDT	T000	MANDT	KEY	1	CN
8	BSEC	REGIO	T005S	BLAND	REF	C	CN
9	BSEC	SPRAS	T002	SPRAS	REF	C	CN
10	BSEC	STCDT	J_1ATODC	J_1ATODC		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in