1. Home
  2. Resources
  3. SAP Tables
  4. BAPIACGL09 - G/L account item

SAP Table BAPIACGL09

G/L account item

BAPIACGL09 (G/L account item) 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 BAPIACGL09 to other SAP tables.

BAPIACGL09 table fields

Field Data element Checktable Datatype Length Decimals
ITEMNO_ACC Accounting Document Line Item Number POSNR_ACC NUMC 10 0
GL_ACCOUNT General Ledger Account HKONT CHAR 10 0
ITEM_TEXT Item Text SGTXT CHAR 50 0
STAT_CON Indicator for statistical line items ACPI_KSTAZ CHAR 1 0
LOG_PROC Logical Transaction LOGVO CHAR 6 0
AC_DOC_NO Accounting Document Number BELNR_D CHAR 10 0
REF_KEY_1 Business partner reference key XREF1 CHAR 12 0
REF_KEY_2 Business partner reference key XREF2 CHAR 12 0
REF_KEY_3 Reference key for line item XREF3 CHAR 20 0
ACCT_KEY Transaction Key KTOSL CHAR 3 0
ACCT_TYPE Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
DOC_TYPE Document Type BLART CHAR 2 0
COMP_CODE Company Code BUKRS CHAR 4 0
BUS_AREA Business Area GSBER CHAR 4 0
FUNC_AREA Functional Area FKBER_SHORT CHAR 4 0
PLANT Plant WERKS_D CHAR 4 0
FIS_PERIOD Fiscal Period MONAT NUMC 2 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
PSTNG_DATE Posting Date in the Document BUDAT DATS 8 0
VALUE_DATE Value date VALUT DATS 8 0
FM_AREA Financial Management Area FIKRS CHAR 4 0
CUSTOMER Customer Number KUNNR CHAR 10 0
CSHDIS_IND Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
VENDOR_NO Account Number of Vendor or Creditor LIFNR CHAR 10 0
ALLOC_NMBR Assignment Number ACPI_ZUONR CHAR 18 0
TAX_CODE Tax on sales/purchases code MWSKZ CHAR 2 0
TAXJURCODE Tax Jurisdiction TXJCD CHAR 15 0
EXT_OBJECT_ID Technical Key of External Object ACPI_IAOM_EO_ID CHAR 34 0
BUS_SCENARIO Business Scenario in Controlling for Logistical Objects ACPI_IAOM_BS_ID CHAR 16 0
COSTOBJECT Cost Object KSTRG CHAR 12 0
COSTCENTER Cost Center KOSTL CHAR 10 0
ACTTYPE Activity Type LSTAR CHAR 6 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
PART_PRCTR Partner Profit Center PPRCTR CHAR 10 0
NETWORK Network Number for Account Assignment NPLNR CHAR 12 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
ORDERID Order Number AUFNR CHAR 12 0
ORDER_ITNO Order Item Number CO_POSNR NUMC 4 0
ROUTING_NO Routing number of operations in the order CO_AUFPL NUMC 10 0
ACTIVITY Operation/Activity Number VORNR CHAR 4 0
COND_TYPE Condition type KSCHA CHAR 4 0
COND_COUNT Condition Counter ACPI_DZAEHK NUMC 2 0
COND_ST_NO Level Number ACPI_STUNR NUMC 3 0
FUND Fund BP_GEBER CHAR 10 0
FUNDS_CTR Funds Center FISTL CHAR 16 0
CMMT_ITEM Commitment Item FIPOS CHAR 14 0
CO_BUSPROC Business Process CO_PRZNR CHAR 12 0
ASSET_NO Main Asset Number ANLN1 CHAR 12 0
SUB_NUMBER Asset Subnumber ANLN2 CHAR 4 0
BILL_TYPE Billing Type FKART CHAR 4 0
SALES_ORD Sales Order Number KDAUF CHAR 10 0
S_ORD_ITEM Item Number in Sales Order KDPOS NUMC 6 0
DISTR_CHAN Distribution Channel VTWEG CHAR 2 0
DIVISION Division SPART CHAR 2 0
SALESORG Sales Organization VKORG CHAR 4 0
SALES_GRP Sales Group VKGRP CHAR 3 0
SALES_OFF Sales Office VKBUR CHAR 4 0
SOLD_TO Sold-to party KUNAG CHAR 10 0
DE_CRE_IND Indicator: subsequent debit/credit ACPI_TBTKZ CHAR 1 0
P_EL_PRCTR Partner profit center for elimination of internal business ACPI_EPRCTR CHAR 10 0
XMFRW Indicator: Update quantity in RW ACPI_XMFRW CHAR 1 0
X Yes
NULL No
QUANTITY Quantity MENGE_D QUAN 13 3
BASE_UOM Base Unit of Measure MEINS UNIT 3 0
BASE_UOM_ISO Base unit of measure in ISO code MEINS_ISO CHAR 3 0
INV_QTY Actual Invoiced Quantity ACPI_FKIMG QUAN 13 3
INV_QTY_SU Billing quantity in stockkeeping unit ACPI_FKLMG QUAN 13 3
SALES_UNIT Sales unit VRKME UNIT 3 0
SALES_UNIT_ISO Sales unit in ISO code ACPI_VRKME_ISO CHAR 3 0
PO_PR_QNT Quantity in order price quantity unit ACPI_BPMNG QUAN 13 3
PO_PR_UOM Order price unit (purchasing) ACPI_BPRME UNIT 3 0
PO_PR_UOM_ISO Purchase order price unit in ISO code BPRME_ISO CHAR 3 0
ENTRY_QNT Quantity in Unit of Entry ERFMG QUAN 13 3
ENTRY_UOM Unit of Entry ERFME UNIT 3 0
ENTRY_UOM_ISO Unit of entry in ISO code ERFME_ISO CHAR 3 0
VOLUME Volume ACPI_VOLUM_15 QUAN 15 3
VOLUMEUNIT Volume unit ACPI_VOLEH UNIT 3 0
VOLUMEUNIT_ISO Volume unit in ISO code ACPI_VOLEH_ISO CHAR 3 0
GROSS_WT Gross Weight ACPI_BRGEW_15 QUAN 15 3
NET_WEIGHT Net weight ACPI_NTGEW_15 QUAN 15 3
UNIT_OF_WT Weight unit ACPI_GEWEI UNIT 3 0
UNIT_OF_WT_ISO Unit of weight in ISO code ACPI_GEWEI_ISO CHAR 3 0
ITEM_CAT Item category in purchasing document ACPI_PSTYP CHAR 1 0
MATERIAL Material Number MATNR CHAR 18 0
MATL_TYPE Material Type ACPI_MTART CHAR 4 0
MVT_IND Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
REVAL_IND Revaluation ACPI_XUMBW CHAR 1 0
X Yes
NULL No
ORIG_GROUP Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
ORIG_MAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
SERIAL_NO Sequential number of account assignment ACPI_DZEKKN NUMC 2 0
PART_ACCT Partner account number JV_PART CHAR 10 0
TR_PART_BA Trading partner's business area PARGB CHAR 4 0
TRADE_ID Company ID of trading partner RASSC CHAR 6 0
VAL_AREA Valuation Area BWKEY CHAR 4 0
VAL_TYPE Valuation Type BWTAR_D CHAR 10 0
ASVAL_DATE Reference Date BF_BZDAT DATS 8 0
PO_NUMBER Purchasing Document Number EBELN CHAR 10 0
PO_ITEM Item Number of Purchasing Document EBELP NUMC 5 0
ITM_NUMBER Item number of the SD document POSNR NUMC 6 0
COND_CATEGORY Condition Category (Examples: Tax, Freight, Price, Cost) ACPI_KNTYP CHAR 1 0
$ TaxJurCode Trigger (Without License Check KNVL)
+ Tax Exemption License Using Conditions
- Reserved (IS-OIL)
0 Reserved (IS-OIL)
1 Tax JurDic Level 1 (with License Check KNVL)
2 Tax JurDic Level 2
3 Tax JurDic Level 3
4 Tax JurDic Level 4
5 Reserved for Customer 5
6 Reserved for Customer 6
7 Reserved for Customer 7
8 Reserved for Customer 8
9 Reserved for Customer 9
A Packaging
B Delivery Costs
C Insurance
D Tax
E Cash Discount
F Shipping Costs
G Cost
H Basic Price
I Price for Intercompany Billing
J Customer Expected Price / Customer Value (Excluding Tax)
K Base Amount Excluding Tax
L Generally New When Copying
M Output Tax with License Check in Customer Master (KNVL)
N Input Tax not Deductible
O Variants
P Base Amount Including Tax
Q Costing
R Invoice List Condition
S Internal Price - Standard
T Internal Price - Moving
U Discount/surcharge for Precious Metals
V Price Component
W Expected Sales Price (Including Tax)
X Reserved for Customer X
Y Reserved for Customer Y
Z Reserved for Customer Z
a Reserved (Fixed Extra Pay)
b Transfer Price for Group Valuation
c Transfer Price for Profit Centers
d Confirmed Purchase Net Price/Value
e Down Payment Request/Down Payment Clearing
f Free Goods - Inclusive
g Payment (POS)
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m Reserved (IS-Oil)
n Profit Center Internal Price (Route)
FUNC_AREA_LONG Functional Area FKBER CHAR 16 0
CMMT_ITEM_LONG Commitment Item FM_FIPEX CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
CS_TRANS_T Transaction Type RMVCT CHAR 3 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PARTNER_SEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
RES_DOC Document Number for Earmarked Funds KBLNR CHAR 10 0
RES_ITEM Earmarked Funds: Document Item KBLPOS NUMC 3 0
BILLING_PERIOD_START_DATE Billing Period of Performance Start Date FM_PEROP_FI_LOW DATS 8 0
BILLING_PERIOD_END_DATE Billing Period of Performance End Date FM_PEROP_FI_HIGH DATS 8 0
PPA_EX_IND PPA Exclude Indicator EXCLUDE_FLG CHAR 1 0
X Yes
NULL No
FASTPAY PPA Fast Pay Indicator FMFG_FASTPAY_FLG CHAR 1 0
X Yes
NULL No
PARTNER_GRANT_NBR Partner Grant GM_PGRANT_NBR CHAR 20 0
BUDGET_PERIOD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PARTNER_BUDGET_PERIOD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR 10 0
PARTNER_FUND Partner Fund FM_PFUND CHAR 10 0
ITEMNO_TAX Document item number refering to tax document. TAXPS NUMC 6 0
PAYMENT_TYPE Payment Type for Grantor GTR_CRM_PAYMENT_TYPE CHAR 4 0
GPOU Grantor Payment
GADV Grantor Advance
GHBK Grantor Holdback
GPIN Grantor RePayment
GPRC Grantor Pmt Recovery
GEFR Grantor EF Revenue
GEFE Grantor EF Expenditure
EXPENSE_TYPE Expense Type for Grantor GTR_CRM_EXPENSE_CAT CHAR 4 0
PROGRAM_PROFILE Grantor Program Profile GTR_CRM_PROG_PROFILE CHAR 10 0