SAP ABAP Table U_12181 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	BSEG
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	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	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
7	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
8	KOART	☐	KOART	KOART	CHAR	1	0	Account type
9	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
10	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
11	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	T074U
12	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
13	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
14	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
15	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
16	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
17	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
18	KZBTR	☐	KZBTR_FI	WERT7	CURR	13	2	Original Reduction Amount in Local Currency
19	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
20	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
21	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
22	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
23	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
24	ALTKT	☐	BILKT_SKA1	SAKNR	CHAR	10	0	Group Account Number
25	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
26	FDGRP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	T035
27	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
28	XUMSW	☐	XUMSW	XFELD	CHAR	1	0	Indicator: Sales-Related Item ?
29	XHRES	☐	XHRES	XFELD	CHAR	1	0	Indicator: Resident G/L Account?
30	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
31	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
32	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
33	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKB1
34	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
35	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
36	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
37	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
38	HZUON	☐	HZUON	ZUONR	CHAR	18	0	Assignment Number for Special G/L Accounts

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_12181	BSCHL	TBSL	BSCHL	REF	1	CN
2	U_12181	BUKRS	T001	BUKRS	KEY	1	CN
3	U_12181	FDGRP	T035	GRUPP	REF	C	CN
4	U_12181	FDLEV	T036	EBENE		C	CN
5	U_12181	GSBER	TGSB	GSBER	REF	C	CN
6	U_12181	HKONT	SKB1	SAKNR	KEY	1	CN
7	U_12181	KUNNR	KNA1	KUNNR	REF	C	CN
8	U_12181	LIFNR	LFA1	LIFNR	REF	C	CN
9	U_12181	MANDT	T000	MANDT	KEY	1	CN
10	U_12181	MWSKZ	T007A	MWSKZ	REF	C	CN
11	U_12181	PARGB	TGSB	GSBER	REF	C	CN
12	U_12181	SAKNR	SKB1	SAKNR	KEY	1	CN
13	U_12181	UMSKZ	T074U	UMSKZ	REF	C	CN
14	U_12181	VBUND	T880	RCOMP	REF	C	CN
15	U_12181	ZUMSK	T074U	UMSKZ	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in