1. Home
  2. Resources
  3. SAP Tables
  4. ACGL_ITEM - Structure for Table Control: G/L Account Entry

SAP Table ACGL_ITEM

Structure for Table Control: G/L Account Entry

ACGL_ITEM (Structure for Table Control: G/L Account Entry) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ACGL_ITEM to other SAP tables.

ACGL_ITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BUZID Identification of the Line Item BUZID CHAR 1 0
AUGDT Clearing Date AUGDT DATS 8 0
AUGCP Clearing Entry Date AUGCP DATS 8 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
UMSKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
ZUMSK Target Special G/L Indicator DZUMSK T074U CHAR 1 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
GSBER Business Area GSBER TGSB CHAR 4 0
PARGB Trading partner's business area PARGB TGSB CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
QSSKZ Withholding Tax Code QSSKZ T059Q CHAR 2 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
KZBTR Original Reduction Amount in Local Currency KZBTR_FI CURR 13 2
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
PSWSL Update Currency for General Ledger Transaction Figures PSWSL TCURC CUKY 5 0
TXBHW Original Tax Base Amount in Local Currency TXBHW CURR 13 2
TXBFW Original Tax Base Amount in Document Currency TXBFW CURR 13 2
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
HWBAS Tax Base Amount in Local Currency HWBAS CURR 13 2
FWBAS Tax Base Amount in Document Currency FWBAS CURR 13 2
HWZUZ Provision Amount in Local Currency HWZUZ CURR 13 2
FWZUZ Additional Tax in Document Currency FWZUZ CURR 13 2
SHZUZ Debit/Credit Addition for Cash Discount SHZUZ CHAR 1 0
STEKZ Version Number Component CHAR2 CHAR 2 0
MWART Tax Type MWART CHAR 1 0
A Output tax
V Input tax
TXGRP Group Indicator for Tax Line Items TXGRP NUMC 3 0
KTOSL Transaction Key KTOSL CHAR 3 0
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
KURSR Hedged Exchange Rate KURSR DEC 9 5
GBETR Hedged Amount in Foreign Currency GBETR CURR 13 2
BDIFF Valuation Difference BDIFF CURR 13 2
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR 13 2
VALUT Value date VALUT DATS 8 0
ZUONR Assignment Number DZUONR CHAR 18 0
SGTXT Item Text SGTXT CHAR 50 0
ZINKZ Exempted from interest calculation DZINKZ CHAR 2 0
A Reasons for block
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
BEWAR Transaction Type RMVCT T856 CHAR 3 0
ALTKT Group account number BILKT_SKA1 CHAR 10 0
VORGN Transaction Type for General Ledger VORGN CHAR 4 0
FDLEV Planning level FDLEV T036 CHAR 2 0
FDGRP Planning Group FDGRP T035 CHAR 10 0
FDWBT Planning amount in document currency FDWBT CURR 13 2
FDTAG Planning date FDTAG DATS 8 0
FKONT Financial Budget Item FIPLS NUMC 3 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
VBELN Billing Document VBELN_VF VBUK CHAR 10 0
VBEL2 Sales Document VBELN_VA VBUK CHAR 10 0
POSN2 Sales Document Item POSNR_VA VBUP NUMC 6 0
ETEN2 Delivery Schedule Line Number ETENR VBEP NUMC 4 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 ANLA CHAR 4 0
ANBWA Asset Transaction Type ANBWA TABW CHAR 3 0
BZDAT Asset value date BZDAT DATS 8 0
PERNR Personnel Number PERNR_D NUMC 8 0
XUMSW Indicator: Sales-related item ? XUMSW CHAR 1 0
X Yes
NULL No
XHRES Indicator: Resident G/L account? XHRES CHAR 1 0
X Yes
NULL No
XKRES Indicator: Can Line Items Be Displayed by Account? XKRES CHAR 1 0
X Yes
NULL No
XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
XCPDD Indicator: Address and bank data set individually XCPDD CHAR 1 0
X Yes
NULL No
XSKST Indicator: Statistical posting to cost center XSKST CHAR 1 0
X Yes
NULL No
XSAUF Indicator: Posting to order is statistical XSAUF CHAR 1 0
X Yes
NULL No
XSPRO Indicator: Posting to project is statistical XSPRO CHAR 1 0
X Yes
NULL No
XSERG Indicator: Posting to prof.analysis is statistical XSERG CHAR 1 0
X Yes
NULL No
XFAKT Indicator: Billing document update successful ? XFAKT CHAR 1 0
X Yes
NULL No
XUMAN Indicator: Transfer posting from down payment ? XUMAN CHAR 1 0
X Yes
NULL No
XANET Indicator: Down payment in net procedure ? XANET CHAR 1 0
X Yes
NULL No
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
XPANZ Display item XPANZ CHAR 1 0
X Yes
NULL No
XAUTO Indicator: Line item automatically created XAUTO CHAR 1 0
X Yes
NULL No
XNCOP Indicator: Items cannot be copied? XNCOP CHAR 1 0
X Yes
NULL No
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
SAKNR G/L Account Number SAKNR SKB1 CHAR 10 0
HKONT General Ledger Account HKONT SKB1 CHAR 10 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
FILKD Account Number of the Branch FILKD CHAR 10 0
XBILK Indicator: Account is a balance sheet account? XBILK CHAR 1 0
X Yes
NULL No
GVTYP P&L statement account type GVTYP CHAR 2 0
HZUON Assignment Number for Special G/L Accounts HZUON CHAR 18 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
ZLSCH Payment Method SCHZW_BSEG T042Z CHAR 1 0
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
HKTID ID for account details HKTID T012K CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
NEBTR Net Payment Amount NEBTR CURR 13 2
MWSK1 Tax Code for Distribution MWSKX T007A CHAR 2 0
DMBT1 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT1 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
MWSK2 Tax Code for Distribution MWSKX T007A CHAR 2 0
DMBT2 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT2 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
MWSK3 Tax Code for Distribution MWSKX T007A CHAR 2 0
DMBT3 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT3 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
REBZT Follow-On Document Type REBZT CHAR 1 0
ZOLLT Customs Tariff Number DZOLLT CHAR 8 0
ZOLLD Customs Date DZOLLD DATS 8 0
LZBKZ State Central Bank Indicator LZBKZ T015L CHAR 3 0
LANDL Supplying Country LANDL T005 CHAR 3 0
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
SAMNR Invoice List Number SAMNR NUMC 8 0
ABPER Settlement period ABPER_RF ACCP 6 0
VRSKZ Insurance indicator VRSKZ CHAR 1 0
VRSDT Insurance date VRSDT DATS 8 0
DISBN Number of Bill of Exchange Usage Document (Discount Doc.) DISBN CHAR 10 0
DISBJ Fiscal Year of Bill of Exchange Usage Document DISBJ NUMC 4 0
DISBZ Line Item within the Bill of Exchange Usage Document DISBZ NUMC 3 0
WVERW Bill of exchange usage type WVERW CHAR 1 0
D Discounting
F Forfeiting
I Collection
ANFBN Document Number of the Bill of Exchange Payment Request ANFBN CHAR 10 0
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document ANFBJ NUMC 4 0
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted ANFBU T001 CHAR 4 0
ANFAE Bill of Exchange Payment Request Due Date ANFAE DATS 8 0
BLNBT Base Amount for Determining the Preference Amount BLNBT CURR 13 2
BLNKZ Subsidy indicator for determining the reduction rates BLNKZ CHAR 2 0
BLNPZ Preference Percentage Rate BLNPZ DEC 7 2
MSCHL Dunning key MSCHL T040 CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
MADAT Last dunned on MADAT DATS 8 0
MANST Dunning level MAHNS_D NUMC 1 0
MABER Dunning Area MABER T047M CHAR 2 0
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
KLIBT Credit Control Amount KLIBT CURR 13 2
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
QBSHB Withholding Tax Amount (in Document Currency) QBSHB CURR 13 2
QSFBT Withholding Tax-Exempt Amount (in Document Currency) QSFBT CURR 13 2
NAVHW Non-Deductible Input Tax (in Local Currency) NAVHW CURR 13 2
NAVFW Non-Deductible Input Tax (in Document Currency) NAVFW CURR 13 2
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ERFMG Quantity in Unit of Entry ERFMG QUAN 13 3
ERFME Unit of Entry ERFME T006 UNIT 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BPRME T006 UNIT 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
PEINH Price Unit PEINH DEC 5 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BUSTW Posting string for values BUSTW CHAR 4 0
REWRT Invoice Value Entered (in Local Currency) REEWR CURR 13 2
REWWR Invoice value in foreign currency REFWR CURR 13 2
BONFB Amount Qualifying for Bonus in Local Currency BONFB CURR 13 2
BUALT Amount posted in alternative price control BUALT CURR 13 2
PSALT Alternative Price Control PSALT CHAR 1 0
S Standard price
V Moving average price/periodic unit price
NPREI New price NPREI CURR 11 2
TBTKZ Indicator: subsequent debit/credit TBTKZ CHAR 1 0
SPGRP Blocking reason: price SPGRP CHAR 1 0
X Yes
NULL No
SPGRM Blocking reason: quantity SPGRM CHAR 1 0
X Yes
NULL No
SPGRT Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRG Blocking reason: order price quantity SPGRG CHAR 1 0
X Yes
NULL No
SPGRV Blocking reason: project budget SPGRV CHAR 1 0
X Yes
NULL No
SPGRQ Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No
STCEG VAT Registration Number STCEG CHAR 20 0
EGBLD Country of Destination for Delivery of Goods EGBLD T005 CHAR 3 0
EGLLD Supplying Country for Delivery of Goods EGLLD T005 CHAR 3 0
RSTGR Reason Code for Payments RSTGR T053R CHAR 3 0
RYACQ Year of acquisition RYACQ CHAR 4 0
RPACQ Period of Acquisition RPACQ NUMC 3 0
RDIFF Exchange Rate Gain/Loss Realized RDIFF CURR 13 2
RDIF2 Exchange Rate Difference Realized for Second Local Currency RDIF2 CURR 13 2
PRCTR Profit Center PRCTR CHAR 10 0
XHKOM Indicator: G/L account assigned manually ? XHKOM CHAR 1 0
X Yes
NULL No
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
EGRUP Equity group JV_EGROUP T8JF CHAR 3 0
VPTNR Partner account number JV_PART KNA1 CHAR 10 0
VERTT Contract Type RANTYP CHAR 1 0
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
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART CHAR 4 0
DEPOT Securities Account RLDEPO CHAR 10 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
POPTS Real estate option rate POPTSATZ DEC 9 6
FIPOS Commitment Item FIPOS FMFPO CHAR 14 0
KSTRG Cost Object KSTRG CHAR 12 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
AUFPL Task list number for operations in order AUFPL_CH NUMC 10 0
APLZL General counter for order APLZL_CH NUMC 8 0
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PASUBNR Profitability segment changes (CO-PA) RKESUBNR NUMC 4 0
SPGRS Blocking Reason: Item Amount SPGRS CHAR 1 0
X Yes
NULL No
SPGRC Block.reason: quality SPGRC CHAR 1 0
X Yes
NULL No
BTYPE Payroll Type JV_BILIND T8JA CHAR 2 0
ETYPE Equity type JV_ETYPE T8JE CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
LNRAN Sequence number of asset line items in fiscal year LNRAN NUMC 5 0
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
DMB21 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB22 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB23 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB31 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
DMB32 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
DMB33 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
MWST2 Tax Amount in Second Local Currency MWST2 CURR 13 2
MWST3 Tax Amount in Third Local Currency MWST3 CURR 13 2
NAVH2 Non-Deductible Input Tax in Second Local Currency NAVH2 CURR 13 2
NAVH3 Non-Deductible Input Tax in Third Local Currency NAVH3 CURR 13 2
SKNT2 Cash Discount Amount in Second Local Currency SKNT2 CURR 13 2
SKNT3 Cash Discount Amount in Third Local Currency SKNT3 CURR 13 2
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR 13 2
RDIF3 Exchange Rate Difference Realized for Third Local Currency RDIF3 CURR 13 2
HWMET Method with Which the Local Currency Amount Was Determined HWMET CHAR 1 0
NULL Translated automatically
E Entered explicitly
A Derived from other items
GLUPM Update Method for FM - FI-CA Integration GLUPM CHAR 1 0
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
XRAGL Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
UZAWE Payment Method Supplement UZAWE T042F CHAR 2 0
LOKKT Alternative account number in company code ALTKT_SKB1 CHAR 10 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
STBUK Tax Company Code STBUK CHAR 4 0
TXBH2 Tax Base/Original Tax Base in Second Local Currency TXBH2 CURR 13 2
TXBH3 Tax Base/Original Tax Base in Third Local Currency TXBH3 CURR 13 2
PPRCT Partner Profit Center PPRCTR CEPC CHAR 10 0
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
KBLNR Document Number for Earmarked Funds KBLNR_FI KBLK CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS KBLP NUMC 3 0
STTAX Tax amount as statistical information in document currency STTAX CURR 13 2
FKBER Functional Area FKBER CHAR 16 0
OBZEI Number of Line Item in Original Document OBZEI NUMC 3 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
RFZEI Payment Card Item RFZEI_CC NUMC 3 0
CCBTC Payment cards: Settlement run CCBTC CHAR 10 0
KKBER Credit control area KKBER T014 CHAR 4 0
EMPFB Payee/Payer EMPFB CHAR 10 0
XREF3 Reference key for line item XREF3 CHAR 20 0
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
GRICD Activity Code for Gross Income Tax J_1AGICD_D J_1AGICD CHAR 2 0
GRIRG Region (State, Province, County) REGIO T005S CHAR 3 0
GITYP Distribution Type for Employment Tax J_1ADTYP_D J_1ADTYP CHAR 2 0
XPYPR Indicator: Items from Payment Program Blocked XPYPR CHAR 1 0
X Yes
NULL No
KIDNO Payment Reference KIDNO CHAR 30 0
ABSBT Credit management: Hedged amount ABSBT CURR 13 2
IDXSP Inflation Index J_1AINDXSP J_1AINFT20 CHAR 5 0
LINFV Last Adjustment Date J_1ALINFVL DATS 8 0
KONTT Account Assignment Category for Industry Solution KONTT_FI CHAR 2 0
KONTL Acct assignment string for industry-specific acct assignmnts KONTL_FI CHAR 50 0
TXDAT Date for defining tax rates TXDAT DATS 8 0
ERLKZ Used earmarked funds set to "Complete" REFSETERLK CHAR 1 0
NULL Not Selected
X Selected
AGZEI Clearing Item AGZEI DEC 5 0
PYCUR Currency for Automatic Payment PYCUR TCURC CUKY 5 0
PYAMT Amount in Payment Currency PYAMT CURR 13 2
BUPLA Business Place BUPLA J_1BBRANCH CHAR 4 0
SECCO Section Code SECCO SECCODE CHAR 4 0
LSTAR Activity Type LSTAR CHAR 6 0
CESSION_KZ Accounts Receivable Pledging Indicator CESSION_KZ TCESSION CHAR 2 0
PRZNR Business Process CO_PRZNR CHAR 12 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT FAGL_SEGM CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT FAGL_SEGM CHAR 10 0
PRODPER Production Month (Date to find period and year) JV_PRODPER DATS 8 0
FASTPAY PPA Fast Pay Indicator FMFG_FASTPAY_FLG CHAR 1 0
X Yes
NULL No
PPA_EX_IND PPA Exclude Indicator EXCLUDE_FLG CHAR 1 0
X Yes
NULL No
PEROP_BEG Billing Period of Performance Start Date FM_PEROP_FI_LOW DATS 8 0
PEROP_END Billing Period of Performance End Date FM_PEROP_FI_HIGH DATS 8 0
PGEBER Partner Fund FM_PFUND CHAR 10 0
PGRANT_NBR Partner Grant GM_GRANT_PARTNER CHAR 20 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PBUDGET_PD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR 10 0
KONTO Account Number or Matchcode for the Account To Be Posted KONTO_F05A CHAR 16 0
KONTO_TXT G/L account short text TXT20_SKAT CHAR 20 0
EOBJ Carrier field for icons ICON_TEXT CHAR 132 0
IOBJ Carrier field for icons ICON_TEXT CHAR 132 0
STATE Carrier field for icons ICON_TEXT CHAR 132 0
LTEXT Carrier field for icons ICON_TEXT CHAR 132 0
MARKSP CHAR 1 0
FKEY Number of Line Item Within Accounting Document BUZEI NUMC 3 0
SWENR Site Number SWENR CHAR 8 0
SGENR Building Number SGENR CHAR 8 0
SGRNR Property Number for BE SGRNR CHAR 8 0
SMENR Number of Rental Unit SMENR CHAR 8 0
SMIVE Lease-Out Number SMIVE CHAR 13 0
SNKSL Service Charge Key SNKSL CHAR 4 0
SEMPSL Settlement Unit SEMPSL CHAR 5 0
SVWNR Management Contract Number VVSVWNR CHAR 13 0
RECNNR Real Estate Contract Number RECNNR CHAR 13 0
SBERI Correction item number SBERI CHAR 10 0
FIKRS Financial Management Area FIKRS CHAR 4 0
LONGNUM Smart Number /SAPPSPRO/LONGNUM CHAR 40 0
XLGCLR Clearing Specific to Ledger Groups XLGCLR CHAR 1 0
X Yes
NULL No

ACGL_ITEM foreign key relationships

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