SAP ABAP Table U_12431 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_12431	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	LEDNR	☑	BP_LEDNR	LEDNR_BP	CHAR	4	0	Budget/Planning Ledger
3	FIKRS	☑	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
4	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
5	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
7	ZHLDT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
8	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
9	PERIO	☐	CO_PERIO	PERBL	NUMC	3	0	Period
10	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
11	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction
12	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
13	POSIT	☐	BP_POSIT	BP_POSIT	CHAR	8	0	Internal commitment item (8 chars)
14	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
15	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	OBJNRZ	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
18	ZAPOS	☐	BP_POSIT	BP_POSIT	CHAR	8	0	Internal commitment item (8 chars)
19	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
20	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
21	LDBTR	☐	FM_LDBTR	WERT7	CURR	13	2	Amount in ledger currency
22	LDBTRO	☐	FM_LDBTR	WERT7	CURR	13	2	Amount in ledger currency
23	TRBTR	☐	FM_TRBTR	WERTV7	CURR	13	2	Amount in transaction currency
24	TRBTRO	☐	FM_TRBTR	WERTV7	CURR	13	2	Amount in transaction currency
25	OBBTR	☐	FM_LDBTR	WERT7	CURR	13	2	Amount in ledger currency
26	OBBTRO	☐	FM_LDBTR	WERT7	CURR	13	2	Amount in ledger currency
27	BUKRS1	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
28	GJAHR1	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
29	BELNR1	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
30	BUZEI1	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
31	BUKRS2	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
32	GJAHR2	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
33	BELNR2	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
34	BUZEI2	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
35	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
36	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
37	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
38	ETENRM	☐	ETENR	ETENR	NUMC	4	0	Schedule line
39	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number
40	ZAEHK	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
41	UMBKZ	☐	FM_UMBKZ	CHAR1	CHAR	1	0	Transfer flag
42	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds
43	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item
44	HI_FIVOR	☐	FIVOR	FIVOR	NUMC	2	0	Financial transaction
45	LO_FIVOR	☐	FIVOR	FIVOR	NUMC	2	0	Financial transaction
46	HI_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account
47	LO_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account
48	HI_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
49	LO_LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor
50	HI_KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
51	LO_KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number
52	XDELETE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
53	HI_XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
54	LO_XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
55	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
56	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
57	CHAINBELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
58	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
59	CFSTAT	☐	FM_CFST	FM_CFST	NUMC	2	0	FM Commitment Carryforward: Status
60	CFSTATSV	☐	FM_CFSTSV	FM_CFST	NUMC	2	0	Year-End Closing: Status (Back Up)
61	CFCNT	☐	FM_CFCNT	FM_CFCNT	NUMC	2	0	Year-End Closing: Number of Transfers
62	BELNRO	☐	FM_BELNRO	BELNR	CHAR	10	0	Reference document number (fiscal year change)
63	BUZEIO	☐	FM_BUZEIO	BUZEI	NUMC	3	0	Reference document item (fiscal year change)
64	LDBTRCCN	☐	FM_LDBTR	WERT7	CURR	13	2	Amount in ledger currency
65	TRBTRCCN	☐	FM_TRBTR	WERTV7	CURR	13	2	Amount in transaction currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_12431	BUKRS	T001	BUKRS	KEY	1	CN
2	U_12431	BUKRS1	T001	BUKRS	KEY	1	CN
3	U_12431	BUKRS2	T001	BUKRS	KEY	1	CN
4	U_12431	EBELN	EKKO	EBELN	KEY	1	CN
5	U_12431	EBELP	EKPO	EBELP	KEY	1	CN
6	U_12431	FIKRS	FM01	FIKRS	KEY	1	CN
7	U_12431	GSBER	TGSB	GSBER	KEY	1	CN
8	U_12431	KUNNR	KNA1	KUNNR	KEY	1	CN
9	U_12431	LIFNR	LFA1	LIFNR	KEY	1	CN
10	U_12431	MANDT	T000	MANDT	KEY	1	CN
11	U_12431	OBJNR	ONR00	OBJNR	KEY	1	CN
12	U_12431	OBJNRZ	ONR00	OBJNR	KEY	1	CN
13	U_12431	TWAER	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in