SAP BAPIACGL09 G/L account item Table data and field list

BAPIACGL09 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "G/L account item" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BAPIACGL09 TYPE BAPIACGL09.

The BAPIACGL09 table consists of various fields, each holding specific information or linking keys about G/L account item data available in SAP. These include GL_ACCOUNT (General Ledger Account), ITEM_TEXT (Item Text), STAT_CON (Indicator for statistical line items), LOG_PROC (Logical Transaction)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BAPIACGL09 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP BAPIACGL09 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BAPIACGL09 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
ITEMNO_ACC	Accounting Document Line Item Number	POSNR_ACC	NUMC	10			POSNR_ACC
GL_ACCOUNT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
ITEM_TEXT	Item Text	SGTXT	CHAR	50			TEXT50
STAT_CON	Indicator for statistical line items	ACPI_KSTAZ	CHAR	1			CHAR1
LOG_PROC	Logical Transaction	LOGVO	CHAR	6			LOGVO
AC_DOC_NO	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
REF_KEY_1	Business partner reference key	XREF1	CHAR	12			CHAR12
REF_KEY_2	Business partner reference key	XREF2	CHAR	12			CHAR12
REF_KEY_3	Reference key for line item	XREF3	CHAR	20			CHAR20
ACCT_KEY	Transaction Key	KTOSL	CHAR	3			CHAR3
ACCT_TYPE	Account Type	KOART	CHAR	1			KOART
DOC_TYPE	Document Type	BLART	CHAR	2	Assigned to domain		BLART	BAR
COMP_CODE	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
BUS_AREA	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
FUNC_AREA	Functional Area	FKBER_SHORT	CHAR	4			FKBER_SHORT	FBE
PLANT	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
FIS_PERIOD	Fiscal Period	MONAT	NUMC	2			MONAT
FISC_YEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
PSTNG_DATE	Posting Date in the Document	BUDAT	DATS	8			DATUM
VALUE_DATE	Value date	VALUT	DATS	8			DATUM
FM_AREA	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
CUSTOMER	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
CSHDIS_IND	Indicator: Line item not liable to cash discount?	XSKRL	CHAR	1			XFELD
VENDOR_NO	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
ALLOC_NMBR	Assignment Number	ACPI_ZUONR	CHAR	18			ZUONR
TAX_CODE	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
TAXJURCODE	Tax Jurisdiction	TXJCD	CHAR	15	Assigned to domain		TXJCD	TXJ
EXT_OBJECT_ID	Technical Key of External Object	ACPI_IAOM_EO_ID	CHAR	34			CHAR34
BUS_SCENARIO	Business Scenario in Controlling for Logistical Objects	ACPI_IAOM_BS_ID	CHAR	16			CHAR16
COSTOBJECT	Cost Object	KSTRG	CHAR	12	Assigned to domain		KSTRG	KTR
COSTCENTER	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
ACTTYPE	Activity Type	LSTAR	CHAR	6	Assigned to domain		LSTAR	LAR	LART_EMPTY
PROFIT_CTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PART_PRCTR	Partner Profit Center	PPRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PPC
NETWORK	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
WBS_ELEMENT	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
ORDERID	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
ORDER_ITNO	Order Item Number	CO_POSNR	NUMC	4			CO_POSNR
ROUTING_NO	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
ACTIVITY	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
COND_TYPE	Condition type	KSCHA	CHAR	4	Assigned to domain		KSCHL	VKS
COND_COUNT	Condition Counter	ACPI_DZAEHK	NUMC	2			NUM02
COND_ST_NO	Level Number	ACPI_STUNR	NUMC	3			NUM03
FUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
FUNDS_CTR	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
CMMT_ITEM	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
CO_BUSPROC	Business Process	CO_PRZNR	CHAR	12	Assigned to domain	ALPHA	CO_PRZNR	KWP
ASSET_NO	Main Asset Number	ANLN1	CHAR	12	Assigned to domain	ALPHA	ANLN1	AN1
SUB_NUMBER	Asset Subnumber	ANLN2	CHAR	4	Assigned to domain	ALPHA	ANLN2	AN2
BILL_TYPE	Billing Type	FKART	CHAR	4	Assigned to domain		FKART
SALES_ORD	Sales Order Number	KDAUF	CHAR	10	Assigned to domain	ALPHA	VBELN	AUN
S_ORD_ITEM	Item Number in Sales Order	KDPOS	NUMC	6			NUM06	KPO
DISTR_CHAN	Distribution Channel	VTWEG	CHAR	2	Assigned to domain		VTWEG	VTW	C_VTWEG
DIVISION	Division	SPART	CHAR	2	Assigned to domain		SPART	SPA	C_SPART
SALESORG	Sales Organization	VKORG	CHAR	4	Assigned to domain		VKORG	VKO	C_VKORG
SALES_GRP	Sales Group	VKGRP	CHAR	3	Assigned to domain		VKGRP	VKG
SALES_OFF	Sales Office	VKBUR	CHAR	4	Assigned to domain		VKBUR	VKB
SOLD_TO	Sold-to party	KUNAG	CHAR	10	Assigned to domain	ALPHA	KUNNR	VAG
DE_CRE_IND	Indicator: subsequent debit/credit	ACPI_TBTKZ	CHAR	1			CHAR01
P_EL_PRCTR	Partner profit center for elimination of internal business	ACPI_EPRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR
XMFRW	Indicator: Update quantity in RW	ACPI_XMFRW	CHAR	1			XFELD
QUANTITY	Quantity	MENGE_D	QUAN	13(3)			MENG13
BASE_UOM	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
BASE_UOM_ISO	Base unit of measure in ISO code	MEINS_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
INV_QTY	Actual Invoiced Quantity	ACPI_FKIMG	QUAN	13(3)			MENG13
INV_QTY_SU	Billing quantity in stockkeeping unit	ACPI_FKLMG	QUAN	13(3)			MENG13
SALES_UNIT	Sales unit	VRKME	UNIT	3	Assigned to domain	CUNIT	MEINS
SALES_UNIT_ISO	Sales unit in ISO code	ACPI_VRKME_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
PO_PR_QNT	Quantity in order price quantity unit	ACPI_BPMNG	QUAN	13(3)			MENG13
PO_PR_UOM	Order price unit (purchasing)	ACPI_BPRME	UNIT	3	Assigned to domain	CUNIT	MEINS
PO_PR_UOM_ISO	Purchase order price unit in ISO code	BPRME_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
ENTRY_QNT	Quantity in Unit of Entry	ERFMG	QUAN	13(3)			MENG13
ENTRY_UOM	Unit of Entry	ERFME	UNIT	3	Assigned to domain	CUNIT	MEINS
ENTRY_UOM_ISO	Unit of entry in ISO code	ERFME_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
VOLUME	Volume	ACPI_VOLUM_15	QUAN	15(3)			MENG15
VOLUMEUNIT	Volume unit	ACPI_VOLEH	UNIT	3	Assigned to domain	CUNIT	MEINS
VOLUMEUNIT_ISO	Volume unit in ISO code	ACPI_VOLEH_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
GROSS_WT	Gross Weight	ACPI_BRGEW_15	QUAN	15(3)			MENG15
NET_WEIGHT	Net weight	ACPI_NTGEW_15	QUAN	15(3)			MENG15
UNIT_OF_WT	Weight unit	ACPI_GEWEI	UNIT	3	Assigned to domain	CUNIT	MEINS
UNIT_OF_WT_ISO	Unit of weight in ISO code	ACPI_GEWEI_ISO	CHAR	3	Assigned to domain		ISOCD_UNIT
ITEM_CAT	Item category in purchasing document	ACPI_PSTYP	CHAR	1			CHAR1
MATERIAL	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
MATL_TYPE	Material Type	ACPI_MTART	CHAR	4			CHAR4
MVT_IND	Movement Indicator	KZBEW	CHAR	1			KZBEW
REVAL_IND	Revaluation	ACPI_XUMBW	CHAR	1			XFELD
ORIG_GROUP	Origin Group as Subdivision of Cost Element	HRKFT	CHAR	4	Assigned to domain		HRKFT
ORIG_MAT	Material-related origin	HKMAT	CHAR	1			HKMAT
SERIAL_NO	Sequential number of account assignment	ACPI_DZEKKN	NUMC	2			NUM02
PART_ACCT	Partner account number	JV_PART	CHAR	10	Assigned to domain	ALPHA	KUNNR
TR_PART_BA	Trading partner's business area	PARGB	CHAR	4	Assigned to domain		GSBER	GSB
TRADE_ID	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
VAL_AREA	Valuation Area	BWKEY	CHAR	4	Assigned to domain		BWKEY	BWK
VAL_TYPE	Valuation Type	BWTAR_D	CHAR	10	Assigned to domain		BWTAR	BWT
ASVAL_DATE	Reference Date	BF_BZDAT	DATS	8			DATUM
PO_NUMBER	Purchasing Document Number	EBELN	CHAR	10	Assigned to domain	ALPHA	EBELN	BES	MEKK_C
PO_ITEM	Item Number of Purchasing Document	EBELP	NUMC	5	Assigned to domain		EBELP	BSP
ITM_NUMBER	Item number of the SD document	POSNR	NUMC	6	Assigned to domain		POSNR
COND_CATEGORY	Condition Category (Examples: Tax, Freight, Price, Cost)	ACPI_KNTYP	CHAR	1			ACPI_KNTYP
FUNC_AREA_LONG	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
CMMT_ITEM_LONG	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
CS_TRANS_T	Transaction Type	RMVCT	CHAR	3	Assigned to domain		RMVCT
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT	CHAR	10	Assigned to domain	ALPHA	FB_SEGMENT
PARTNER_SEGMENT	Partner Segment for Segmental Reporting	FB_PSEGMENT	CHAR	10	Assigned to domain	ALPHA	FB_SEGMENT
RES_DOC	Document Number for Earmarked Funds	KBLNR	CHAR	10	Assigned to domain	ALPHA	KBLNR	KBL
RES_ITEM	Earmarked Funds: Document Item	KBLPOS	NUMC	3	Assigned to domain		KBLPOS	KBP
BILLING_PERIOD_START_DATE	Billing Period of Performance Start Date	FM_PEROP_FI_LOW	DATS	8			DATUM
BILLING_PERIOD_END_DATE	Billing Period of Performance End Date	FM_PEROP_FI_HIGH	DATS	8			DATUM
PPA_EX_IND	PPA Exclude Indicator	EXCLUDE_FLG	CHAR	1			XFELD
FASTPAY	PPA Fast Pay Indicator	FMFG_FASTPAY_FLG	CHAR	1			XFELD
PARTNER_GRANT_NBR	Partner Grant	GM_PGRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR		GRANTS_GENERIC
BUDGET_PERIOD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
PARTNER_BUDGET_PERIOD	FM: Partner Budget Period	FM_PBUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
PARTNER_FUND	Partner Fund	FM_PFUND	CHAR	10	Assigned to domain		BP_GEBER	PARTNER_FUND
ITEMNO_TAX	Document item number refering to tax document.	TAXPS	NUMC	6			NUM6
PAYMENT_TYPE	Payment Type for Grantor	GTR_CRM_PAYMENT_TYPE	CHAR	4			GTR_CRM_PAYMENT_TYPE
EXPENSE_TYPE	Expense Type for Grantor	GTR_CRM_EXPENSE_CAT	CHAR	4			GTR_CRM_EXPENSE_CAT
PROGRAM_PROFILE	Grantor Program Profile	GTR_CRM_PROG_PROFILE	CHAR	10

Key field

Non-key field

< BAPIACGL08 - Posting in Accounting: General Posting BAPIACGL30 - Posting w/ BAPI: Posting Information for Other Applications >

How do I retrieve data from SAP structure BAPIACGL09 using ABAP code?

As BAPIACGL09 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BAPIACGL09 as there is no data to select.

How to access SAP table BAPIACGL09

Within an ECC or HANA version of SAP you can also view further information about BAPIACGL09 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).