SAP ABAP Table GSEG (Offsetting Items for B-Segment in Reporting)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	INTTAB	Structure
Structure	GSEG	Table Relationship Diagram
Short Description	Offsetting Items for B-Segment in Reporting

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	.INCLUDE	☐				0	0	Accounting Document Segment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
7	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
8	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
9	AUGCP	☐	AUGCP	DATUM	DATS	8	0	Clearing Entry Date
10	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
11	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
12	KOART	☐	KOART	KOART	CHAR	1	0	Account type
13	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
14	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
15	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	T074U
16	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
17	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
18	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
19	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
20	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	T059Q
21	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
22	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
23	KZBTR	☐	KZBTR_FI	WERT7	CURR	13	2	Original Reduction Amount in Local Currency
24	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
25	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
26	TXBHW	☐	TXBHW	WERT7	CURR	13	2	Original Tax Base Amount in Local Currency
27	TXBFW	☐	TXBFW	WERT7	CURR	13	2	Original Tax Base Amount in Document Currency
28	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
29	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
30	HWBAS	☐	HWBAS	WERT7	CURR	13	2	Tax Base Amount in Local Currency
31	FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
32	HWZUZ	☐	HWZUZ	WERT7	CURR	13	2	Provision Amount in Local Currency
33	FWZUZ	☐	FWZUZ	WERT7	CURR	13	2	Additional Tax in Document Currency
34	SHZUZ	☐	SHZUZ	CHAR1	CHAR	1	0	Debit/Credit Addition for Cash Discount
35	STEKZ	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
36	MWART	☐	MWART	MWART	CHAR	1	0	Tax Type
37	TXGRP	☐	TXGRP	NUM03	NUMC	3	0	Group Indicator for Tax Line Items
38	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
39	QSSHB	☐	QSSHB	WERT7	CURR	13	2	Withholding Tax Base Amount
40	KURSR	☐	KURSR	KURSP	DEC	9	5	Hedged Exchange Rate
41	GBETR	☐	GBETR	WERT7	CURR	13	2	Hedged Amount in Foreign Currency
42	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
43	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
44	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
45	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
46	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
47	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
48	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
49	BEWAR	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
50	ALTKT	☐	BILKT_SKA1	SAKNR	CHAR	10	0	Group Account Number	*
51	VORGN	☐	VORGN	VORGN	CHAR	4	0	Transaction Type for General Ledger
52	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	T036
53	FDGRP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	T035
54	FDWBT	☐	FDWBT	WERTV7	CURR	13	2	Planned Amount in Document or G/L Account Currency
55	FDTAG	☐	FDTAG	DATUM	DATS	8	0	Planning Date
56	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
57	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
58	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
59	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
60	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
61	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
62	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
63	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
64	ETEN2	☐	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
65	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
66	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
67	ANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	TABW
68	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
69	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
70	XUMSW	☐	XUMSW	XFELD	CHAR	1	0	Indicator: Sales-Related Item ?
71	XHRES	☐	XHRES	XFELD	CHAR	1	0	Indicator: Resident G/L Account?
72	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
73	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
74	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
75	XSKST	☐	XSKST	XFELD	CHAR	1	0	Indicator: Statistical Posting to Cost Center
76	XSAUF	☐	XSAUF	XFELD	CHAR	1	0	Indicator: Posting to Order Is Statistical
77	XSPRO	☐	XSPRO	XFELD	CHAR	1	0	Indicator: Posting to Project Is Statistical
78	XSERG	☐	XSERG	XFELD	CHAR	1	0	Indicator: Posting to Profitability Analysis Is Statistical
79	XFAKT	☐	XFAKT	XFELD	CHAR	1	0	Indicator: Billing Document Update Successful?
80	XUMAN	☐	XUMAN	XFELD	CHAR	1	0	Indicator: Transfer Posting from Down Payment?
81	XANET	☐	XANET	XFELD	CHAR	1	0	Indicator: Down Payment in Net Procedure?
82	XSKRL	☐	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
83	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
84	XPANZ	☐	XPANZ	XFELD	CHAR	1	0	Display item
85	XAUTO	☐	XAUTO	XFELD	CHAR	1	0	Indicator: Line item automatically created
86	XNCOP	☐	XNCOP	XFELD	CHAR	1	0	Indicator: Items Cannot Be Copied?
87	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
88	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKB1
89	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
90	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
91	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
92	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
93	XBILK	☐	XBILK	XFELD	CHAR	1	0	Indicator: Account is a balance sheet account?
94	GVTYP	☐	GVTYP	CHAR2	CHAR	2	0	P&L statement account type
95	HZUON	☐	HZUON	ZUONR	CHAR	18	0	Assignment Number for Special G/L Accounts
96	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
97	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
98	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
99	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
100	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
101	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
102	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
103	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
104	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
105	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
106	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
107	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
108	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
109	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
110	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
111	NEBTR	☐	NEBTR	WERT7	CURR	13	2	Net Payment Amount
112	MWSK1	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	T007A
113	DMBT1	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
114	WRBT1	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
115	MWSK2	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	T007A
116	DMBT2	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
117	WRBT2	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
118	MWSK3	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	T007A
119	DMBT3	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
120	WRBT3	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
121	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
122	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
123	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
124	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
125	ZOLLT	☐	DZOLLT	ZOLLT	CHAR	8	0	Customs Tariff Number
126	ZOLLD	☐	DZOLLD	DATUM	DATS	8	0	Customs Date
127	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
128	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
129	DIEKZ	☐	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
130	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
131	ABPER	☐	ABPER_RF	BUPER	ACCP	6	0	Settlement period
132	VRSKZ	☐	VRSKZ	CHAR1	CHAR	1	0	Insurance Indicator
133	VRSDT	☐	VRSDT	DATUM	DATS	8	0	Insurance Date
134	DISBN	☐	DISBN	BELNR	CHAR	10	0	Number of Bill of Exchange Usage Document (Discount Doc.)
135	DISBJ	☐	DISBJ	GJAHR	NUMC	4	0	Fiscal Year of Bill of Exchange Usage Document
136	DISBZ	☐	DISBZ	BUZEI	NUMC	3	0	Line Item within the Bill of Exchange Usage Document
137	WVERW	☐	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
138	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
139	ANFBJ	☐	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
140	ANFBU	☐	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	T001
141	ANFAE	☐	ANFAE	DATUM	DATS	8	0	Bill of Exchange Payment Request Due Date
142	BLNBT	☐	BLNBT	WERT7	CURR	13	2	Base Amount for Determining the Preference Amount
143	BLNKZ	☐	BLNKZ	BLNKZ	CHAR	2	0	Subsidy Indicator for Determining the Reduction Rates	*
144	BLNPZ	☐	BLNPZ	PRZ52	DEC	7	2	Preference Percentage Rate
145	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
146	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
147	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
148	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
149	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
150	ESRNR	☐	ESRNR	ESRNR	CHAR	11	0	POR subscriber number
151	ESRRE	☐	ESRRE	ESRRE	CHAR	27	0	POR reference number
152	ESRPZ	☐	ESRPZ	CHAR2	CHAR	2	0	POR check digit
153	KLIBT	☐	KLIBT	WERT7	CURR	13	2	Credit Control Amount
154	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
155	QBSHB	☐	QBSHB	WERT7	CURR	13	2	Withholding Tax Amount (in Document Currency)
156	QSFBT	☐	QSFBT	WERT7	CURR	13	2	Withholding Tax-Exempt Amount (in Document Currency)
157	NAVHW	☐	NAVHW	WERT7	CURR	13	2	Non-Deductible Input Tax (in Local Currency)
158	NAVFW	☐	NAVFW	WERT7	CURR	13	2	Non-Deductible Input Tax (in Document Currency)
159	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
160	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
161	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
162	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
163	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
164	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
165	BPMNG	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
166	BPRME	☐	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
167	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
168	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
169	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
170	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
171	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
172	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
173	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
174	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
175	BUSTW	☐	BUSTW	BUSTW	CHAR	4	0	Posting string for values
176	REWRT	☐	REEWR	WRTV7	CURR	13	2	Invoice Value Entered (in Local Currency)
177	REWWR	☐	REFWR	WRTV7	CURR	13	2	Invoice Value in Foreign Currency
178	BONFB	☐	BONFB	WERT7	CURR	13	2	Amount Qualifying for Bonus in Local Currency
179	BUALT	☐	BUALT	WERTV7	CURR	13	2	Amount posted in alternative price control
180	PSALT	☐	PSALT	VPRSV	CHAR	1	0	Alternative Price Control
181	NPREI	☐	NPREI	WERT11	CURR	11	2	New Price
182	TBTKZ	☐	TBTKZ	TBTKZ	CHAR	1	0	Indicator: Subsequent Debit/Credit
183	SPGRP	☐	SPGRP	XFELD	CHAR	1	0	Blocking Reason: Price
184	SPGRM	☐	SPGRM	XFELD	CHAR	1	0	Blocking Reason: Quantity
185	SPGRT	☐	SPGRT	XFELD	CHAR	1	0	Blocking Reason: Date
186	SPGRG	☐	SPGRG	XFELD	CHAR	1	0	Blocking Reason: Order Price Quantity
187	SPGRV	☐	SPGRV	XFELD	CHAR	1	0	Blocking Reason: Project Budget
188	SPGRQ	☐	SPGRQ	XFELD	CHAR	1	0	Manual Blocking Reason
189	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
190	EGBLD	☐	EGBLD	LAND1	CHAR	3	0	Country of Destination for Delivery of Goods	T005
191	EGLLD	☐	EGLLD	LAND1	CHAR	3	0	Supplying Country for Delivery of Goods	T005
192	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	T053R
193	RYACQ	☐	RYACQ	CJAHR	CHAR	4	0	Year of acquisition
194	RPACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
195	RDIFF	☐	RDIFF	WRTV7	CURR	13	2	Exchange Rate Gain/Loss Realized
196	RDIF2	☐	RDIF2	WRTV7	CURR	13	2	Exchange Rate Difference Realized for Second Local Currency
197	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
198	XHKOM	☐	XHKOM	XFELD	CHAR	1	0	Indicator: G/L Account Assigned Manually?
199	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
200	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
201	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
202	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
203	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
204	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
205	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
206	DEPOT	☐	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
207	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
208	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
209	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
210	POPTS	☐	POPTSATZ	POPTSATZ	DEC	9	6	Real Estate Option Rate
211	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
212	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
213	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
214	AUFPL	☐	AUFPL_CH	AUFPL	NUMC	10	0	Task List Number for Operations in Order
215	APLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
216	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
217	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
218	PASUBNR	☐	RKESUBNR	RKESUBNR	NUMC	4	0	Profitability Segment Changes (CO-PA)
219	SPGRS	☐	SPGRS	XFELD	CHAR	1	0	Blocking Reason: Item Amount
220	SPGRC	☐	SPGRC	XFELD	CHAR	1	0	Blocking Reason: Quality
221	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
222	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	T8JE
223	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
224	LNRAN	☐	LNRAN	LNRAN	NUMC	5	0	Sequence Number of Asset Line Items in Fiscal Year	*
225	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
226	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
227	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
228	DMB21	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
229	DMB22	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
230	DMB23	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
231	DMB31	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
232	DMB32	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
233	DMB33	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
234	MWST2	☐	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
235	MWST3	☐	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
236	NAVH2	☐	NAVH2	WERT7	CURR	13	2	Non-Deductible Input Tax in Second Local Currency
237	NAVH3	☐	NAVH3	WERT7	CURR	13	2	Non-Deductible Input Tax in Third Local Currency
238	SKNT2	☐	SKNT2	WERT7	CURR	13	2	Cash Discount Amount in Second Local Currency
239	SKNT3	☐	SKNT3	WERT7	CURR	13	2	Cash Discount Amount in Third Local Currency
240	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
241	RDIF3	☐	RDIF3	WRTV7	CURR	13	2	Exchange Rate Difference Realized for Third Local Currency
242	HWMET	☐	HWMET	HWMET	CHAR	1	0	Method with Which the Local Currency Amount Was Determined
243	GLUPM	☐	GLUPM	GLUPM	CHAR	1	0	Update Method for FM - FI-CA Integration
244	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
245	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
246	LOKKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code	*
247	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
248	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
249	STBUK	☐	STBUK	BUKRS	CHAR	4	0	Tax Company Code	*
250	TXBH2	☐	TXBH2	WERT7	CURR	13	2	Tax Base/Original Tax Base in Second Local Currency
251	TXBH3	☐	TXBH3	WERT7	CURR	13	2	Tax Base/Original Tax Base in Third Local Currency
252	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
253	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
254	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
255	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	KBLK
256	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	KBLP
257	STTAX	☐	STTAX	WERT7	CURR	13	2	Tax Amount as Statistical Information in Document Currency
258	FKBER	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
259	OBZEI	☐	OBZEI	BUZEI	NUMC	3	0	Number of Line Item in Original Document
260	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
261	RFZEI	☐	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
262	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
263	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
264	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
265	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
266	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
267	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
268	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
269	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
270	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
271	GRIRG	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
272	GITYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
273	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
274	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
275	ABSBT	☐	ABSBT	WERT7	CURR	13	2	Credit Management: Hedged Amount
276	IDXSP	☐	J_1AINDXSP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
277	LINFV	☐	J_1ALINFVL	DATUM	DATS	8	0	Last Adjustment Date
278	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
279	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
280	TXDAT	☐	TXDAT	DATUM	DATS	8	0	Date for defining tax rates
281	AGZEI	☐	AGZEI	AGZEI	DEC	5	0	Clearing Item
282	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	TCURC
283	PYAMT	☐	PYAMT	WERT7	CURR	13	2	Amount in Payment Currency
284	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
285	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	SECCODE
286	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
287	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	TCESSION
288	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
289	PPDIFF	☐	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
290	PPDIF2	☐	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
291	PPDIF3	☐	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
292	PENLC1	☐	PENALTY1	WERT13	CURR	13	2	Penalty Charge Amount in First Local Currency
293	PENLC2	☐	PENALTY2	WERT13	CURR	13	2	Penalty Charge Amount in Second Local Currency
294	PENLC3	☐	PENALTY3	WERT13	CURR	13	2	Penalty Charge Amount in Third Local Currency
295	PENFC	☐	PENALTY	WERT13	CURR	13	2	Penalty Charge Amount in Document Currency
296	PENDAYS	☐	PDAYS	INT4	INT4	10	0	Number of Days for Penalty Charge Calculation
297	PENRC	☐	PENRC	CHAR2	CHAR	2	0	Reason for Late Payment
298	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
299	SCTAX	☐	SCTAX	WERT7	CURR	13	2	Tax Portion FI-CA Local Currency
300	FKBER_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
301	GMVKZ	☐	FM_GMVKZ	FM_GMVKZ	CHAR	1	0	Item is in Execution
302	SRTYPE	☐	FM_SRTYPE	FM_SRTYPE	CHAR	2	0	Type of Additional Receivable
303	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
304	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
305	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
306	PPA_EX_IND	☐	EXCLUDE_FLG	XFELD	CHAR	1	0	PPA Exclude Indicator
307	DOCLN	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
308	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
309	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	*
310	PFKBER	☐	SFKBER	FKBER	CHAR	16	0	Partner Functional Area	*
311	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
312	KSTAR	☐	KSTAR	KSTAR	CHAR	10	0	Cost Element	*
313	XLGCLR	☐	XLGCLR	XFELD	CHAR	1	0	Clearing Specific to Ledger Groups
314	TAXPS	☐	TAX_POSNR	NUM6	NUMC	6	0	Tax document item number
315	PAYS_PROV	☐	COM_WEC_PAYMENT_SRV_PROVIDER	COM_WEC_PAYMENT_SRV_PROVIDER	CHAR	4	0	Payment Service Provider	*
316	PAYS_TRAN	☐	FPS_TRANSACTION	COM_WEC_PSP_TRANSACTION_ID	CHAR	35	0	Payment Reference of Payment Service Provider
317	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
318	XFRGE_BSEG	☐	XFRGE_BSEG	XFELD	CHAR	1	0	Payment Is Released
319	.INCLU--AP	☐				0	0	Funds Management EHP4
320	PGEBER	☐	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
321	PGRANT_NBR	☐	GM_GRANT_PARTNER	GM_GRANT_NBR	CHAR	20	0	Partner Grant
322	.INCLU--AP	☐				0	0	FM: Budget Period
323	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
324	PBUDGET_PD	☐	FM_PBUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Partner Budget Period	*
325	.INCLU--AP	☐				0	0	FMFG: US Federal Specific Fields
326	PEROP_BEG	☐	FM_PEROP_FI_LOW	DATUM	DATS	8	0	Billing Period of Performance Start Date
327	PEROP_END	☐	FM_PEROP_FI_HIGH	DATUM	DATS	8	0	Billing Period of Performance End Date
328	FASTPAY	☐	FMFG_FASTPAY_FLG	XFELD	CHAR	1	0	PPA Fast Pay Indicator
329	IGNR_IVREF	☐	FMFG_IGNORE_INV_REF	XFELD	CHAR	1	0	FMFG: Ignore the invoice reference during FI doc splitting
330	FMFGUS_KEY	☐	FMFG_US_KEY	SYSUUID_22	CHAR	22	0	United States Federal Government Fields
331	.INCLU--AP	☐				0	0	Funds Management Actual Data Reference Document
332	.INCLUDE	☐				0	0	Funds Management Actual Data Reference Document
333	FMXDOCNR	☐	FM_XDOCNR	BELNR	CHAR	10	0	FM Reference Document Number
334	FMXYEAR	☐	FM_XYEAR	GJAHR	NUMC	4	0	FM Reference Year
335	FMXDOCLN	☐	FM_XDOCLN	NUMC6	NUMC	6	0	FM Reference Line Item
336	FMXZEKKN	☐	FM_XZEKKN	NUMC5	NUMC	5	0	FM Reference Sequence Account Assignment
337	.INCLU--AP	☐				0	0	Joint Venture addtional doucment fields
338	PRODPER	☐	JV_PRODPER	JV_PRODPER	DATS	8	0	Production Month (Date to find period and year)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GSEG	ANBWA	TABW	BWASL
2	GSEG	ANFBU	T001	BUKRS
3	GSEG	ANLN1	ANLH	ANLN1
4	GSEG	ANLN2	ANLA	ANLN2
5	GSEG	AUFNR	AUFK	AUFNR
6	GSEG	BEWAR	T856	TRTYP
7	GSEG	BPRME	T006	MSEHI
8	GSEG	BSCHL	TBSL	BSCHL
9	GSEG	BTYPE	T8JA	BILIND
10	GSEG	BUKRS	T001	BUKRS
11	GSEG	BUPLA	J_1BBRANCH	BRANCH	KEY	1	CN
12	GSEG	BWKEY	T001K	BWKEY
13	GSEG	BWTAR	T149D	BWTAR
14	GSEG	CESSION_KZ	TCESSION	CESSION_KZ
15	GSEG	EBELN	EKKO	EBELN
16	GSEG	EBELP	EKPO	EBELP
17	GSEG	EGBLD	T005	LAND1
18	GSEG	EGLLD	T005	LAND1
19	GSEG	EGRUP	T8JF	EGRUP
20	GSEG	ERFME	T006	MSEHI
21	GSEG	ETEN2	VBEP	ETENR
22	GSEG	ETYPE	T8JE	ETYPE
23	GSEG	FDGRP	T035	GRUPP
24	GSEG	FDLEV	T036	EBENE		C	CN
25	GSEG	FIPOS	FMFPO	FIPOS
26	GSEG	GITYP	J_1ADTYP	J_1ADTYP	REF	C	CN
27	GSEG	GRICD	J_1AGICD	J_1AGICD	REF	C	CN
28	GSEG	GRIRG	T005S	BLAND	REF	C	CN
29	GSEG	GSBER	TGSB	GSBER
30	GSEG	HBKID	T012	HBKID
31	GSEG	HKONT	SKB1	SAKNR
32	GSEG	HKTID	T012K	HKTID
33	GSEG	IDXSP	J_1AINFT20	J_1AINDX	KEY	1	CN
34	GSEG	KBLNR	KBLK	BELNR	REF	C	CN
35	GSEG	KBLPOS	KBLP	BLPOS	REF	C	CN
36	GSEG	KKBER	T014	KKBER	REF	1	CN
37	GSEG	KOKRS	TKA01	KOKRS
38	GSEG	KUNNR	KNA1	KUNNR
39	GSEG	LANDL	T005	LAND1
40	GSEG	LIFNR	LFA1	LIFNR
41	GSEG	LZBKZ	T015L	LZBKZ
42	GSEG	MABER	T047M	MABER
43	GSEG	MANDT	T000	MANDT
44	GSEG	MANSP	T040S	MANSP
45	GSEG	MATNR	MARA	MATNR
46	GSEG	MEINS	T006	MSEHI
47	GSEG	MSCHL	T040	MSCHL
48	GSEG	MWSK1	T007A	MWSKZ
49	GSEG	MWSK2	T007A	MWSKZ
50	GSEG	MWSK3	T007A	MWSKZ
51	GSEG	MWSKZ	T007A	MWSKZ
52	GSEG	PARGB	TGSB	GSBER
53	GSEG	POSN2	VBUP	POSNR
54	GSEG	PPRCT	CEPC	PRCTR
55	GSEG	PSWSL	TCURC	WAERS
56	GSEG	PYCUR	TCURC	WAERS		1	CN
57	GSEG	QSSKZ	T059Q	QSSKZ
58	GSEG	RECID	T8JJ	RECID
59	GSEG	RSTGR	T053R	RSTGR	REF	C	CN
60	GSEG	SAKNR	SKB1	SAKNR
61	GSEG	SECCO	SECCODE	SECCODE	KEY	1	CN
62	GSEG	TXJCD	TTXJ	TXJCD
63	GSEG	UMSKZ	T074U	UMSKZ
64	GSEG	UZAWE	T042F	UZAWE
65	GSEG	VBEL2	VBUK	VBELN
66	GSEG	VBELN	VBUK	VBELN
67	GSEG	VBUND	T880	RCOMP
68	GSEG	VNAME	T8JV	VNAME
69	GSEG	VPTNR	KNA1	KUNNR
70	GSEG	WERKS	T001W	WERKS
71	GSEG	ZLSCH	T042Z	ZLSCH
72	GSEG	ZLSPR	T008	ZAHLS
73	GSEG	ZUMSK	T074U	UMSKZ

History

Last changed by/on	SAP	20140121
SAP Release Created in