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

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BUZID Identification of the Line Item CHAR 1 0 BUZID
AUGDT Clearing Date DATS 8 0 AUGDT
AUGCP Clearing Entry Date DATS 8 0 AUGCP
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
UMSKZ Special G/L Indicator CHAR 1 0 T074U UMSKZ
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
ZUMSK Target Special G/L Indicator CHAR 1 0 T074U DZUMSK
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
GSBER Business Area CHAR 4 0 TGSB GSBER
PARGB Trading partner's business area CHAR 4 0 TGSB PARGB
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
QSSKZ Withholding Tax Code CHAR 2 0 T059Q QSSKZ
DMBTR Amount in local currency CURR 23 2 DMBTR
WRBTR Amount in document currency CURR 23 2 WRBTR
FCSL Amount in Functional Currency CURR 23 2 FINS_VFCCUR12
RFCCUR Functional Currency CUKY 5 0 * FINS_CURRFC
KZBTR Original Reduction Amount in Local Currency CURR 23 2 KZBTR_FI
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 TCURC PSWSL
TXBHW Original Tax Base Amount in Local Currency CURR 23 2 TXBHW
TXBFW Original Tax Base Amount in Document Currency CURR 23 2 TXBFW
MWSTS Tax Amount in Local Currency CURR 23 2 MWSTS
WMWST Tax Amount in Document Currency CURR 23 2 WMWST
LWSTS Tax amount in Reporting Currency CURR 23 2 LWSTS
LWBTR Amount in Reporting Currency for Tax Breakdown CURR 23 2 LWBTX
HWBAS Tax Base Amount in Local Currency CURR 23 2 HWBAS
FWBAS Tax Base Amount in Document Currency CURR 23 2 FWBAS
HWZUZ Provision Amount in Local Currency CURR 23 2 HWZUZ
FWZUZ Additional Tax in Document Currency CURR 23 2 FWZUZ
SHZUZ Debit/Credit Addition for Cash Discount CHAR 1 0 SHZUZ
STEKZ Component of the Version Number CHAR 2 0 CHAR2
MWART Tax Type CHAR 1 0 MWART
A Output tax
V Input tax
TXGRP Group Indicator for Tax Line Items NUMC 3 0 TXGRP
KTOSL Transaction Key CHAR 3 0 KTOSL
QSSHB Withholding Tax Base Amount CURR 23 2 QSSHB
KURSR Hedged Exchange Rate DEC 9 5 KURSR
GBETR Hedged Amount in Foreign Currency CURR 23 2 GBETR
BDIFF Valuation Difference CURR 23 2 BDIFF
BDIF2 Valuation Difference for the Second Local Currency CURR 23 2 BDIF2
VALUT Value date DATS 8 0 VALUT
ZUONR Assignment number CHAR 18 0 DZUONR
SGTXT Item Text CHAR 50 0 SGTXT
ZINKZ Exempted from Interest Calculation CHAR 2 0 DZINKZ
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
BEWAR Transaction type CHAR 3 0 T856 RMVCT
ALTKT Group Account Number CHAR 10 0 * BILKT_SKA1
VORGN Transaction Type for General Ledger CHAR 4 0 VORGN
FDLEV Planning Level CHAR 2 0 T036 FDLEV
FDGRP Planning Group CHAR 10 0 T035 FDGRP
FDWBT Planned Amount in Document or G/L Account Currency CURR 23 2 FDWBT
FDTAG Planning Date DATS 8 0 FDTAG
FKONT Financial Budget Item NUMC 3 0 FIPLS
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 * KOSTL
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
AUFNR Order Number CHAR 12 0 AUFK AUFNR
VBELN Billing Document CHAR 10 0 VBUK VBELN_VF
VBEL2 Sales Document CHAR 10 0 VBUK VBELN_VA
POSN2 Sales Document Item NUMC 6 0 VBUP POSNR_VA
ETEN2 Schedule Line Number NUMC 4 0 VBEP ETENR
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
ANBWA Asset Transaction Type CHAR 3 0 TABW ANBWA
BZDAT Asset Value Date DATS 8 0 BZDAT
PERNR Personnel Number NUMC 8 0 PERNR_D
XUMSW Indicator: Sales-Related Item ? CHAR 1 0 XUMSW
XHRES Indicator: Resident G/L Account? CHAR 1 0 XHRES
XKRES Indicator: Can Line Items Be Displayed by Account? CHAR 1 0 XKRES
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
XCPDD Indicator: Address and Bank Data Set Individually CHAR 1 0 XCPDD
XSKST Indicator: Statistical Posting to Cost Center CHAR 1 0 XSKST
XSAUF Indicator: Posting to Order Is Statistical CHAR 1 0 XSAUF
XSPRO Indicator: Posting to Project Is Statistical CHAR 1 0 XSPRO
XSERG Indicator: Posting to Profitability Analysis Is Statistical CHAR 1 0 XSERG
XFAKT Indicator: Billing Document Update Successful? CHAR 1 0 XFAKT
XUMAN Indicator: Transfer Posting from Down Payment? CHAR 1 0 XUMAN
XANET Indicator: Down Payment in Net Procedure? CHAR 1 0 XANET
XSKRL Indicator: Line Item Not Liable to Cash Discount? CHAR 1 0 XSKRL
XINVE Indicator: Capital Goods Affected? CHAR 1 0 XINVE
XPANZ Display Item CHAR 1 0 XPANZ
XAUTO Indicator: Line item automatically created CHAR 1 0 XAUTO
XNCOP Indicator: Items Cannot Be Copied? CHAR 1 0 XNCOP
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
SAKNR G/L Account Number CHAR 10 0 SKB1 SAKNR
HKONT General Ledger Account CHAR 10 0 SKB1 HKONT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
FILKD Account Number of the Branch CHAR 10 0 FILKD
XBILK Indicator: Account is a balance sheet account? CHAR 1 0 XBILK
GVTYP P&L statement account type CHAR 2 0 GVTYP
HZUON Assignment Number for Special G/L Accounts CHAR 18 0 HZUON
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 23 2 SKFBT
SKNTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
WSKTO Cash Discount Amount in Document Currency CURR 23 2 WSKTO
ZLSCH Payment Method CHAR 1 0 T042Z SCHZW_BSEG
ZLSPR Payment Block Key CHAR 1 0 T008 DZLSPR
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
BVTYP Partner bank type CHAR 4 0 BVTYP
NEBTR Net Payment Amount CURR 23 2 NEBTR
MWSK1 Tax Code for Distribution CHAR 2 0 T007A MWSKX
TXDAT_FROM1 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY1 Tax Country or Region for Tax Breakdown CHAR 3 0 * FOT_TAX_COUNTRYX
DMBT1 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT1 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR1 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK2 Tax Code for Distribution CHAR 2 0 T007A MWSKX
TXDAT_FROM2 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY2 Tax Country or Region for Tax Breakdown CHAR 3 0 * FOT_TAX_COUNTRYX
DMBT2 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT2 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR2 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK3 Tax Code for Distribution CHAR 2 0 T007A MWSKX
TXDAT_FROM3 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY3 Tax Country or Region for Tax Breakdown CHAR 3 0 * FOT_TAX_COUNTRYX
DMBT3 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT3 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR3 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
HIST_TAX_FACTOR Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
REBZT Follow-On Document Type CHAR 1 0 REBZT
ZOLLT Customs Tariff Number CHAR 8 0 DZOLLT
ZOLLD Customs Date DATS 8 0 DZOLLD
LZBKZ State Central Bank Indicator CHAR 3 0 T015L LZBKZ
LANDL Supplying Country/Region CHAR 3 0 T005 LANDL
DIEKZ Service Indicator (Foreign Payment) CHAR 1 0 DIEKZ
SAMNR Invoice List Number NUMC 8 0 SAMNR
ABPER Settlement Period ACCP 6 0 ABPER_RF
VRSKZ Insurance Indicator CHAR 1 0 VRSKZ
VRSDT Insurance Date DATS 8 0 VRSDT
DISBN Number of Bill of Exchange Usage Document (Discount Doc.) CHAR 10 0 DISBN
DISBJ Fiscal Year of Bill of Exchange Usage Document NUMC 4 0 DISBJ
DISBZ Line Item Within the Bill of Exchange Usage Document NUMC 3 0 DISBZ
WVERW Bill of Exchange Usage Type CHAR 1 0 WVERW
D Discounting
F Forfeiting
I Collection
ANFBN Document Number of the Bill of Exchange Payment Request CHAR 10 0 ANFBN
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document NUMC 4 0 ANFBJ
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted CHAR 4 0 T001 ANFBU
ANFAE Bill of Exchange Payment Request Due Date DATS 8 0 ANFAE
BLNBT Base Amount for Determining the Preference Amount CURR 23 2 BLNBT
BLNKZ (Obsolete) Subsidy Ind. for Determining the Reduction Rate CHAR 2 0 * BLNKZ
BLNPZ Preference Percentage Rate DEC 7 2 BLNPZ
MSCHL Dunning Key CHAR 1 0 T040 MSCHL
MANSP Dunning Block CHAR 1 0 T040S MANSP
MADAT Date of Last Dunning Notice DATS 8 0 MADAT
MANST Dunning Level NUMC 1 0 MAHNS_D
MABER Dunning Area CHAR 2 0 T047M MABER
ESRNR ISR subscriber number CHAR 11 0 ESRNR
ESRRE ISR/QR Reference Number CHAR 27 0 ESRRE
ESRPZ POR check digit CHAR 2 0 ESRPZ
KLIBT Credit Control Amount CURR 23 2 KLIBT
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
QBSHB Withholding Tax Amount (in Document Currency) CURR 23 2 QBSHB
QSFBT Withholding Tax-Exempt Amount (in Document Currency) CURR 23 2 QSFBT
NAVHW Non-Deductible Input Tax (in Local Currency) CURR 23 2 NAVHW
NAVFW Non-Deductible Input Tax (in Document Currency) CURR 23 2 NAVFW
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
ERFME Unit of entry UNIT 3 0 T006 ERFME
BPMNG Quantity in Purchase Order Price Unit QUAN 13 3 BPMNG
BPRME Order Price Unit (Purchasing) UNIT 3 0 T006 BPRME
EBELN_LOGSYS Logical System of Purchasing Document CHAR 10 0 * EBELN_LOGSYS
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
PEINH Price unit DEC 5 0 PEINH
BWKEY Valuation area CHAR 4 0 T001K BWKEY
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
BUSTW Posting String for Values CHAR 4 0 BUSTW
REWRT Invoice Value Entered (in Local Currency) CURR 13 2 REEWR
REWWR Invoice Amount in Foreign Currency CURR 23 2 REWWR
BONFB Amount Qualifying for Bonus in Local Currency CURR 23 2 BONFB
BUALT Amount Posted in Alternative Price Control CURR 13 2 BUALT
PSALT Alternative Price Control CHAR 1 0 PSALT
NPREI New Price CURR 11 2 NPREI
TBTKZ Indicator: Subsequent Debit/Credit CHAR 1 0 TBTKZ
SPGRP Blocking Reason: Price CHAR 1 0 SPGRP
SPGRM Blocking Reason: Quantity CHAR 1 0 SPGRM
SPGRT Blocking Reason: Date CHAR 1 0 SPGRT
SPGRG Blocking Reason: Order Price Quantity CHAR 1 0 SPGRG
SPGRV Blocking Reason: Project Budget CHAR 1 0 SPGRV
SPGRQ Manual Blocking Reason CHAR 1 0 SPGRQ
STCEG VAT Registration Number CHAR 20 0 STCEG
EGBLD Country/Region of Destination for Delivery of Goods CHAR 3 0 T005 EGBLD
EGLLD Supplying Country/Region for Delivery of Goods CHAR 3 0 T005 EGLLD
RSTGR Reason Code for Payments CHAR 3 0 T053R RSTGR
RYACQ Year of acquisition CHAR 4 0 RYACQ
RPACQ Period of Acquisition NUMC 3 0 RPACQ
RDIFF Exchange Rate Gain/Loss Realized CURR 23 2 RDIFF
RDIF2 Exchange Rate Difference Realized for Second Local Currency CURR 23 2 RDIF2
PRCTR Profit Center CHAR 10 0 PRCTR
XHKOM Indicator: G/L Account Assigned Manually? CHAR 1 0 XHKOM
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
RECID Recovery Indicator CHAR 2 0 T8JJ JV_RECIND
EGRUP Equity group CHAR 3 0 T8JF JV_EGROUP
VPTNR Partner account number CHAR 10 0 KNA1 JV_PART
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 * SBEWART
DEPOT Securities Account CHAR 10 0 RLDEPO
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
POPTS Real Estate Option Rate DEC 9 6 POPTSATZ
FIPOS Commitment Item CHAR 14 0 FMFPO FIPOS
KSTRG Cost Object CHAR 12 0 * KSTRG
NPLNR Network Number for Account Assignment CHAR 12 0 * NPLNR
AUFPL Task List Number for Operations in Order NUMC 10 0 AUFPL_CH
APLZL General Counter for Order NUMC 8 0 * APLZL_CH
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 * PS_PSP_PNR
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) NUMC 4 0 RKESUBNR
SPGRS Blocking Reason: Item Amount CHAR 1 0 SPGRS
SPGRC Blocking Reason: Quality CHAR 1 0 SPGRC
BTYPE Billing Indicator CHAR 2 0 T8JA JV_BILIND
ETYPE Equity type CHAR 3 0 T8JE JV_ETYPE
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
LNRAN Sequence Number of Asset Line Items in Fiscal Year NUMC 5 0 * LNRAN
HRKFT Origin Group as Subdivision of Cost Element CHAR 4 0 * HRKFT
DMBE2 Amount in Second Local Currency or Global Currency CURR 23 2 DMBE2
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency CURR 23 2 DMBE3
DMB21 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB22 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB23 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB31 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB32 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB33 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
MWST2 Tax Amount in Second Local Currency CURR 23 2 MWST2
MWST3 Tax Amount in Third Local Currency CURR 23 2 MWST3
NAVH2 Non-Deductible Input Tax in Second Local Currency CURR 23 2 NAVH2
NAVH3 Non-Deductible Input Tax in Third Local Currency CURR 23 2 NAVH3
SKNT2 Cash Discount Amount in Second Local Currency CURR 23 2 SKNT2
SKNT3 Cash Discount Amount in Third Local Currency CURR 23 2 SKNT3
BDIF3 Valuation Difference for the Third Local Currency CURR 23 2 BDIF3
RDIF3 Exchange Rate Difference Realized for Third Local Currency CURR 23 2 RDIF3
HWMET Method with Which the Local Currency Amount Was Determined CHAR 1 0 HWMET
Translated automatically
A Derived from other items
E Entered explicitly
GLUPM Update Method for FM - FI-CA Integration CHAR 1 0 GLUPM
A Invoice
B Paid Invoice
C Clearing
D Clearing of Invoice from Previous Year
E Clearing of Invoice in Next Year
F BP Transfer Posting
G Payment without invoice reference
H Down payment
I G/L Account Transfer Posting
J Clarification Worklist
K Tax Item Created Automatically
L Invoice from Legacy System
M Reversal of Invoice in Prior Year
O Paid Invoice from Prior Year
Q Credit Memo: Special Display
R Clearing of Invoice and Credit Memo (Document in Prior Year)
S Clearing of Invoice and Credit Memo (Document in Next Year)
T Paid Invoice (Clearing with Credit Memo)
U Paid Invoice Prior Year (Clearing with Credit Memo)
V Posting Before FM Activation
W Paid Invoice with Tax Portion
X Paid Invoice from Prior Year with Tax Portion
Y Paid Invoice with Tax Portion (Cleared with Credit Memo)
Z Paid Invoice from Prior Year with Tax Portion (Credit Memo)
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
UZAWE Payment method supplement CHAR 2 0 T042F UZAWE
LOKKT Alternative Account Number in Company Code CHAR 10 0 * ALTKT_SKB1
FISTL Funds Center CHAR 16 0 * FISTL
GEBER Fund CHAR 10 0 * BP_GEBER
STBUK Tax Company Code CHAR 4 0 * STBUK
TXBH2 Tax Base/Original Tax Base in Second Local Currency CURR 23 2 TXBH2
TXBH3 Tax Base/Original Tax Base in Third Local Currency CURR 23 2 TXBH3
PPRCT Partner Profit Center CHAR 10 0 CEPC PPRCTR
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
KBLNR Document Number for Earmarked Funds CHAR 10 0 KBLK KBLNR_FI
KBLPOS Earmarked Funds: Document Item NUMC 3 0 KBLP KBLPOS
STTAX Tax Amount as Statistical Information in Document Currency CURR 13 2 STTAX
FKBER Functional Area CHAR 4 0 FKBER_SHORT
OBZEI Number of Line Item in Original Document NUMC 3 0 OBZEI
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
KKBER Credit control area CHAR 4 0 T014 KKBER
EMPFB Payee/Payer CHAR 10 0 EMPFB
XREF3 Reference key for line item CHAR 20 0 XREF3
DTWS1 Instruction Key 1 NUMC 2 0 * DTAT16
DTWS2 Instruction Key 2 NUMC 2 0 * DTAT17
DTWS3 Instruction key 3 NUMC 2 0 * DTAT18
DTWS4 Instruction key 4 NUMC 2 0 * DTAT19
GRICD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
GRIRG Region (State, Province, County) CHAR 3 0 T005S REGIO
GITYP Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
XPYPR Indicator: Items from Payment Program Blocked CHAR 1 0 XPYPR
KIDNO Payment Reference CHAR 30 0 KIDNO
ABSBT Credit Management: Hedged Amount CURR 23 2 ABSBT
IDXSP Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXSP
LINFV Last Adjustment Date DATS 8 0 J_1ALINFVL
KONTT Account Assignment Category for Industry Solution CHAR 2 0 KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmnts CHAR 50 0 KONTL_FI
UEBGDAT Transfer Date of an Item to Legal Dunning Proceeding DATS 8 0 UEBGDATUM
TXDAT Date for Determining Tax Rates DATS 8 0 TXDAT
AGZEI Clearing Item DEC 5 0 AGZEI
PYCUR Currency for Automatic Payment CUKY 5 0 TCURC PYCUR
PYAMT Amount in Payment Currency CURR 23 2 PYAMT
BUPLA Business Place CHAR 4 0 PBUSINESSPLACE BUPLA
SECCO Section Code CHAR 4 0 SECCODE SECCO
LSTAR Activity Type CHAR 6 0 LSTAR
CESSION_KZ Accounts Receivable Pledging Indicator CHAR 2 0 TCESSION CESSION_KZ
PRZNR Business Process CHAR 12 0 * CO_PRZNR
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23 2 PPDIFF
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts) CURR 23 2 PPDIF2
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts) CURR 23 2 PPDIF3
PENLC1 Penalty Charge Amount in First Local Currency CURR 23 2 PENALTY1
PENLC2 Penalty Charge Amount in Second Local Currency CURR 23 2 PENALTY2
PENLC3 Penalty Charge Amount in Third Local Currency CURR 23 2 PENALTY3
PENFC Penalty Charge Amount in Document Currency CURR 23 2 PENALTY
PENDAYS Number of Days for Penalty Charge Calculation INT4 10 0 PDAYS
PENRC Reason for Late Payment CHAR 2 0 PENRC
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
SCTAX Tax Portion FI-CA Local Currency CURR 13 2 SCTAX
FKBER_LONG Functional Area CHAR 16 0 * FKBER
GMVKZ Item is in Execution CHAR 1 0 FM_GMVKZ
Item not transferred to execution
I Item for information transferred to execution
X Item must be executed
SRTYPE Type of Additional Receivable CHAR 2 0 FM_SRTYPE
1 Dunning Charge
2 Dunning Interest
3 Deferral Interest
4 General Execution Costs
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
MEASURE Funded Program CHAR 24 0 * FM_MEASURE
AUGGJ Fiscal Year of Clearing Document NUMC 4 0 AUGGJ
PPA_EX_IND PPA Exclude Indicator CHAR 1 0 EXCLUDE_FLG
DOCLN Six-Character Posting Item for Ledger CHAR 6 0 DOCLN6
SEGMENT Segment for Segmental Reporting CHAR 10 0 * FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 * FB_PSEGMENT
PFKBER Partner Functional Area CHAR 16 0 * SFKBER
HKTID ID for Account Details CHAR 5 0 T012K HKTID
KSTAR Cost Element CHAR 10 0 * KSTAR
XLGCLR Open Item Management by Ledger Group CHAR 1 0 XLGCLR
TAXPS Tax document item number NUMC 6 0 TAX_POSNR
PAYS_PROV Payment Service Provider CHAR 4 0 * COM_WEC_PAYMENT_SRV_PROVIDER
PAYS_TRAN Payment Reference of Payment Service Provider CHAR 35 0 FPS_TRANSACTION
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
XFRGE_BSEG Payment Is Released CHAR 1 0 XFRGE_BSEG
AWTYP Reference procedure CHAR 5 0 * AWTYP
AWKEY Reference Key CHAR 20 0 AWKEY
AWSYS Logical system of source document CHAR 10 0 * AWSYS
POSNR Accounting Document Line Item Number NUMC 10 0 POSNR_ACC
BUZEI_SENDER Item Number Within Accounting Document in Sender System NUMC 3 0 BUZEI_SENDER
H_MONAT Fiscal period NUMC 2 0 MONAT
H_BSTAT Document Status CHAR 1 0 BSTAT_D
H_BUDAT Posting Date in the Document DATS 8 0 BUDAT
H_BLDAT Document Date in Document DATS 8 0 BLDAT
H_WAERS Currency Key CUKY 5 0 TCURC WAERS
H_BLART Document Type CHAR 2 0 T003 BLART
H_HWAER Local Currency CUKY 5 0 * HWAER
H_HWAE2 Currency Key of Second Local Currency CUKY 5 0 * HWAE2
H_HWAE3 Currency Key of Third Local Currency CUKY 5 0 * HWAE3
SK1DT Due Date for Cash Discount 1 DATS 8 0 SK1DT
SK2DT Due Date for Cash Discount 2 DATS 8 0 SK2DT
PRCTR_DRVTN_SOURCE_TYPE Profit Center Derivation Source Type CHAR 2 0 FINOC_PRCTR_DRVTN_SOURCE_TYPE
BP Business Process
HP Cost Object
KS Cost Center
MA Material
NP Network
OR Order
PD Project
PO Purchase Document Item
PR WBS Element
SV Service Order Item
VB Sales Document Item
PAYT_RSN Payment Reason CHAR 4 0 FARP_PAYT_RSN_T FARP_PAYT_RSN
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
FQFTYPE Flow Type CHAR 6 0 FQM_FLOW_TYPE
LQITEM Liquidity Item CHAR 16 0 FLQPOS
GKONT Offsetting Account Number CHAR 10 0 GKONT
GKART Offsetting Account Type CHAR 1 0 GKOAR
GHKON G/L Acct of Offsetting Acct in General Ledger Accounting CHAR 10 0 GHKONT
SQUAN Quantity +/- Sign CHAR 1 0 SIGN_QUANTITY
Not Defined/Not Yet Set
+ Plus Sign
- Minus Sign
0 Not Relevant for Quantity Updates
ANLN2_PN Asset Subnumber CHAR 4 0 * ANLN2
BWASL_PN Asset Transaction Type CHAR 3 0 * BWASL
BZDAT_PN Asset Value Date DATS 8 0 BZDAT
XVABG_PN Indicator: Post Complete Retirement CHAR 1 0 XVABG
ANBTR_PN Amount Posted CURR 23 2 ANBTR
PROZS_PN Asset Retirement: Percentage Rate DEC 5 2 PROZS
ACDOC_EEW_DUMMY Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
ACROBJTYPE Type of the Accrual Object CHAR 4 0 TACR_OBJ_TYPE ACR_OBJ_TYPE
ACRLOGSYS Logical System of the Accrual Object CHAR 10 0 ACR_LOGSYS
ACROBJ_ID Identifier of the Accrual Object CHAR 32 0 ACR_OBJ_ID
ACRSOBJ_ID Identifier of the Accrual Subobject CHAR 32 0 ACR_SUBOBJ_ID
ACRITMTYPE Type of the Item of the Accrual Subobject CHAR 11 0 ACR_ITEM_TYPE
ACRREFOBJ_ID Identifier of the Accrual Reference Object CHAR 32 0 ACR_REFOBJ_ID
ACRVALDAT Accrual Value Date DATS 8 0 ACR_VALUE_DATE
VALOBJTYPE Type of the Financial Valuation Object CHAR 4 0 FINSC_VAL_TYPE VAL_OBJ_TYPE
VALOBJ_ID Identifier of the Financial Valuation Object CHAR 32 0 VAL_OBJ_ID
VALSOBJ_ID Identifier of the Financial Valuation Subobject CHAR 32 0 VAL_SUBOBJ_ID
NETDT Net Due Date DATS 8 0 NETDT
RISK_CLASS Risk Class CHAR 3 0 UKM_RISK_CL UKM_RISK_CLASS
SDM_VERSION SDM: Version field for BSEG CHAR 2 0 FINS_SDM_VERSION_BSEG
01 ACRVALDAT
02 GLO_REF1 with BR_BARCODE
03 RFCCUR, FCSL
GLO_REF1 Country/Region Specific Reference 1 on line item CHAR 50 0 FAC_GLO_REF1
RE_BUKRS Cash Ledger: Company Code for Expense/Revenue CHAR 4 0 * FAGL_RE_BUKRS
RE_ACCOUNT Cash Ledger: Expense or Revenue Account CHAR 10 0 * FAGL_RE_ACCOUNT
DP_PAYMENT_TYPE Digital Payments Payment Type CHAR 2 0 DP_PAYMENT_TYPE
A1 ApplePay
AC ACH/Electronic Check
AP AliPay
BC Bitcoin
G1 GiroPay
GP GooglePay
ID iDEAL
KL Klarna
MP MicrosoftPay
PC Payment Card
PP PayPal
SO Sofort
WP WeChat Pay
DP_TRANS_ID Transaction/Payment ID of SAP Digital Payments CHAR 44 0 DP_TRANSID
PGEBER Partner Fund CHAR 10 0 * FM_PFUND
PGRANT_NBR Partner Grant CHAR 20 0 GM_GRANT_PARTNER
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period CHAR 10 0 * FM_PBUDGET_PERIOD
J_1TPBUPL Branch Code CHAR 5 0 BCODE
PEROP_BEG Billing Period of Performance Start Date DATS 8 0 FM_PEROP_FI_LOW
PEROP_END Billing Period of Performance End Date DATS 8 0 FM_PEROP_FI_HIGH
FASTPAY PPA Fast Pay Indicator CHAR 1 0 FMFG_FASTPAY_FLG
IGNR_IVREF FMFG: Ignore the invoice reference during FI doc splitting CHAR 1 0 FMFG_IGNORE_INV_REF
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFG_US_KEY
FMXDOCNR FM Reference Document Number CHAR 10 0 FM_XDOCNR
FMXYEAR FM Reference Year NUMC 4 0 FM_XYEAR
FMXDOCLN FM Reference Line Item NUMC 6 0 FM_XDOCLN
FMXZEKKN FM Reference Sequence Account Assignment NUMC 5 0 FM_XZEKKN
PRODPER Production Month (Date to find period and year) DATS 8 0 JV_PRODPER
GST_PART GST Partner CHAR 10 0 J_1IG_PARTNER
PLC_SUP Place of Supply CHAR 3 0 T005S J_1IG_REGION
HSN_SAC HSN or SAC Code CHAR 16 0 J_1IG_HSN_SAC
IRN Invoice Reference Number CHAR 64 0 J_1IG_IRN
RECRF Service tax recredit flag CHAR 1 0 J_1IRECRF
BDGT_ACCOUNT Budget Account CHAR 10 0 * PSM_BDGT_ACCOUNT
BDGT_ACCOUNT_COCODE Budget Account Company Code CHAR 4 0 * PSM_BDGT_ACCOUNT_COCODE
INWARD_NO Incoming Document Number CHAR 30 0 SAFM_AP_INWARD_NO
INWARD_DT Incoming Document Date DATS 8 0 SAFM_AP_INWARD_DT
GROUND_NO Payment Basis Document Number CHAR 16 0 SAFM_AP_PYBSNO
GROUND_DT Payment Basis Document Date DATS 8 0 SAFM_AP_PYBSDAT
GROUND_TYP Type of Payment Basis Document CHAR 2 0 SAFM_AP_PYBSTYP
PYMTKEY Payment or Proposal Key CHAR 20 0 SAFM_AP_PYMNTKEY

GSEG foreign key relationships

Table Field Check Table Check Field
0 GSEG ACROBJTYPE TACR_OBJ_TYPE Accrual object type MANDT
1 GSEG ANBWA TABW Asset transaction types MANDT
0 GSEG ANFBU T001 Company Codes BUKRS
1 GSEG ANLN1 ANLH Main asset number BUKRS
1 GSEG ANLN1 ANLH Main asset number ANLN1
0 GSEG ANLN2 ANLA Asset Master Record Segment BUKRS
0 GSEG ANLN2 ANLA Asset Master Record Segment ANLN1
0 GSEG ANLN2 ANLA Asset Master Record Segment ANLN2
1 GSEG AUFNR AUFK Order master data AUFNR
0 GSEG BEWAR T856 Transaction Types MANDT
0 GSEG BEWAR T856 Transaction Types TRTYP
1 GSEG BPRME T006 Units of Measurement MANDT
0 GSEG BSCHL TBSL Posting Key MANDT
0 GSEG BSCHL TBSL Posting Key BSCHL
1 GSEG BTYPE T8JA Payroll Type MANDT
1 GSEG BTYPE T8JA Payroll Type BILIND
0 GSEG BUKRS T001 Company Codes BUKRS
1 GSEG BUPLA PBUSINESSPLACE Generated Table for View BUKRS
1 GSEG BUPLA PBUSINESSPLACE Generated Table for View BRANCH
0 GSEG BWTAR T149D Global Valuation Types MANDT
0 GSEG BWTAR T149D Global Valuation Types BWTAR
1 GSEG CESSION_KZ TCESSION Accounts Receivable Pledging CLIENT
1 GSEG CESSION_KZ TCESSION Accounts Receivable Pledging COMPANY
0 GSEG EBELN EKKO Purchasing Document Header EBELN
1 GSEG EBELP EKPO Purchasing Document Item MANDT
1 GSEG EBELP EKPO Purchasing Document Item EBELN
0 GSEG EGBLD T005 Countries MANDT
0 GSEG EGBLD T005 Countries LAND1
1 GSEG EGLLD T005 Countries MANDT
1 GSEG EGLLD T005 Countries LAND1
0 GSEG EGRUP T8JF Investment Group MANDT
0 GSEG EGRUP T8JF Investment Group BUKRS
0 GSEG EGRUP T8JF Investment Group VNAME
0 GSEG EGRUP T8JF Investment Group EGRUP
1 GSEG ERFME T006 Units of Measurement MANDT
0 GSEG ETEN2 VBEP Sales Document: Schedule Line Data MANDT
0 GSEG ETEN2 VBEP Sales Document: Schedule Line Data VBELN
0 GSEG ETEN2 VBEP Sales Document: Schedule Line Data POSNR
0 GSEG ETEN2 VBEP Sales Document: Schedule Line Data ETENR
1 GSEG ETYPE T8JE Investment Type MANDT
1 GSEG ETYPE T8JE Investment Type BUKRS
1 GSEG ETYPE T8JE Investment Type ETYPE
0 GSEG FDGRP T035 Planning groups GRUPP
1 GSEG FDLEV T036 Planning levels EBENE
0 GSEG FIPOS FMFPO FIFM: Commitment Item MANDT
0 GSEG FIPOS FMFPO FIFM: Commitment Item FIKRS
0 GSEG FIPOS FMFPO FIFM: Commitment Item DATBIS
1 GSEG GITYP J_1ADTYP Distribution Types for Gross Income Tax MANDT
1 GSEG GITYP J_1ADTYP Distribution Types for Gross Income Tax BUKRS
0 GSEG GRICD J_1AGICD Activity codes for gross income tax declaration MANDT
0 GSEG GRICD J_1AGICD Activity codes for gross income tax declaration LAND1
1 GSEG GRIRG T005S Taxes: Region (Province) Key LAND1
0 GSEG GSBER TGSB Business Areas MANDT
0 GSEG GSBER TGSB Business Areas GSBER
1 GSEG HBKID T012 House Banks BUKRS
0 GSEG HKONT SKB1 G/L account master (company code) MANDT
0 GSEG HKONT SKB1 G/L account master (company code) BUKRS
1 GSEG HKTID T012K House Bank Accounts MANDT
1 GSEG HKTID T012K House Bank Accounts BUKRS
1 GSEG HKTID T012K House Bank Accounts HBKID
1 GSEG HKTID T012K House Bank Accounts HKTID
0 GSEG H_BLART T003 Document Types MANDT
1 GSEG H_WAERS TCURC Currency Codes MANDT
1 GSEG H_WAERS TCURC Currency Codes WAERS
0 GSEG IDXSP J_1AINFT20 Inflation: Index Definition MANDT
1 GSEG KBLNR KBLK Document Header: Manual Document Entry MANDT
1 GSEG KBLNR KBLK Document Header: Manual Document Entry BELNR
0 GSEG KBLPOS KBLP Document Item: Manual Document Entry MANDT
0 GSEG KBLPOS KBLP Document Item: Manual Document Entry BELNR
1 GSEG KKBER T014 Credit control areas KKBER
0 GSEG KOKRS TKA01 Controlling Areas MANDT
1 GSEG KUNNR KNA1 General Data in Customer Master MANDT
1 GSEG KUNNR KNA1 General Data in Customer Master KUNNR
0 GSEG LANDL T005 Countries MANDT
0 GSEG LANDL T005 Countries LAND1
1 GSEG LIFNR LFA1 Supplier Master (General Section) MANDT
1 GSEG LIFNR LFA1 Supplier Master (General Section) LIFNR
0 GSEG LZBKZ T015L SCB Ratios LZBKZ
1 GSEG MABER T047M Dunning areas MANDT
1 GSEG MABER T047M Dunning areas BUKRS
0 GSEG MANDT T000 Clients MANDT
1 GSEG MATNR MARA General Material Data MANDT
1 GSEG MATNR MARA General Material Data MATNR
0 GSEG MEINS T006 Units of Measurement MANDT
0 GSEG MEINS T006 Units of Measurement MSEHI
1 GSEG MSCHL T040 Dunning keys MSCHL
0 GSEG MWSK1 T007A Tax Keys KALSM
0 GSEG MWSK1 T007A Tax Keys MWSKZ
1 GSEG MWSK2 T007A Tax Keys KALSM
1 GSEG MWSK2 T007A Tax Keys MWSKZ
0 GSEG MWSK3 T007A Tax Keys KALSM
0 GSEG MWSK3 T007A Tax Keys MWSKZ
1 GSEG MWSKZ T007A Tax Keys KALSM
1 GSEG MWSKZ T007A Tax Keys MWSKZ
0 GSEG PARGB TGSB Business Areas MANDT
0 GSEG PARGB TGSB Business Areas GSBER
1 GSEG PLC_SUP T005S Taxes: Region (Province) Key LAND1
0 GSEG POSN2 VBUP Sales Document: Item Status MANDT
0 GSEG POSN2 VBUP Sales Document: Item Status VBELN
0 GSEG POSN2 VBUP Sales Document: Item Status POSNR
1 GSEG PPRCT CEPC Profit Center Master Data Table PRCTR
1 GSEG PPRCT CEPC Profit Center Master Data Table DATBI
1 GSEG PPRCT CEPC Profit Center Master Data Table KOKRS
0 GSEG PSWSL TCURC Currency Codes MANDT
0 GSEG PSWSL TCURC Currency Codes WAERS
1 GSEG PYCUR TCURC Currency Codes MANDT
1 GSEG PYCUR TCURC Currency Codes WAERS
0 GSEG QSSKZ T059Q Withholding Tax MANDT
0 GSEG QSSKZ T059Q Withholding Tax LAND1
0 GSEG QSSKZ T059Q Withholding Tax QSSKZ
1 GSEG RECID T8JJ Recovery Indicator MANDT
1 GSEG RECID T8JJ Recovery Indicator BUKRS
0 GSEG RSTGR T053R Classification of Payment Differences MANDT
0 GSEG RSTGR T053R Classification of Payment Differences BUKRS
0 GSEG RSTGR T053R Classification of Payment Differences RSTGR
1 GSEG SAKNR SKB1 G/L account master (company code) MANDT
1 GSEG SAKNR SKB1 G/L account master (company code) BUKRS
0 GSEG SECCO SECCODE Section Code MANDT
0 GSEG SECCO SECCODE Section Code BUKRS
0 GSEG SECCO SECCODE Section Code SECCODE
1 GSEG TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
1 GSEG TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
0 GSEG UMSKZ T074U Special G/L Indicator Properties MANDT
1 GSEG UZAWE T042F Payment method supplements MANDT
1 GSEG UZAWE T042F Payment method supplements UZAWE
0 GSEG VBEL2 VBUK Sales Document: Header Status and Administrative Data MANDT
0 GSEG VBEL2 VBUK Sales Document: Header Status and Administrative Data VBELN
1 GSEG VBELN VBUK Sales Document: Header Status and Administrative Data MANDT
1 GSEG VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
0 GSEG VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 GSEG VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 GSEG VNAME T8JV Joint Venture MANDT
1 GSEG VNAME T8JV Joint Venture BUKRS
1 GSEG VNAME T8JV Joint Venture VNAME
0 GSEG VPTNR KNA1 General Data in Customer Master MANDT
0 GSEG VPTNR KNA1 General Data in Customer Master KUNNR
1 GSEG WERKS T001W Plants/Branches MANDT
1 GSEG WERKS T001W Plants/Branches WERKS
0 GSEG ZLSCH T042Z Payment Methods for Automatic Payment MANDT
0 GSEG ZLSCH T042Z Payment Methods for Automatic Payment LAND1
0 GSEG ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
1 GSEG ZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
1 GSEG ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
0 GSEG ZUMSK T074U Special G/L Indicator Properties MANDT