SAP ABAP Table BILL_ACC_ACGL09_DATA (Data Part: G/L Account Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BE-FI (Application Component) Transfer to Accounting
     ⤷ BILL_ACC_IF (Package) Interface for Transferring Billing Document to R/3 AR/FI-CA

Basic Data

Table Category	INTTAB	Structure
Structure	BILL_ACC_ACGL09_DATA	Table Relationship Diagram
Short Description	Data Part: G/L Account Items

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	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
2	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
3	STAT_CON	☐	KSTAZ	KSTAZ	CHAR	1	0	Indicator for Statistical Line Items
4	LOG_PROC	☐	LOGVO	LOGVO	CHAR	6	0	Logical Transaction
5	AC_DOC_NO	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
6	REF_KEY_1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
7	REF_KEY_2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
8	REF_KEY_3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
9	ACCT_KEY	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
10	ACCT_TYPE	☐	KOART	KOART	CHAR	1	0	Account type
11	DOC_TYPE	☐	BLART	BLART	CHAR	2	0	Document type	*
12	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
13	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
14	FUNC_AREA	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
15	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
16	FIS_PERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
17	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
18	PSTNG_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
19	VALUE_DATE	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
20	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
21	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
22	CSHDIS_IND	☐	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
23	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
24	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
25	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
26	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
27	EXT_OBJECT_ID	☐	ACC_EXT_OBJECT_ID_CO	CHAR34	CHAR	34	0	Technical Key for an External Object (for OLTP)
28	BUS_SCENARIO	☐	ACC_BUS_SCENARIO_CO	CHAR16	CHAR	16	0	Business Scenario in Controlling for Logistics Objects
29	COSTOBJECT	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
30	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
31	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
32	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
33	PART_PRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
34	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
35	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
36	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
37	ORDER_ITNO	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
38	ROUTING_NO	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
39	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
40	COND_TYPE	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
41	COND_COUNT	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
42	COND_ST_NO	☐	STUNR	STUNR	NUMC	3	0	Level Number
43	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
44	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
45	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
46	CO_BUSPROC	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
47	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
48	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
49	BILL_TYPE	☐	FKART	FKART	CHAR	4	0	Billing Type	*
50	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number
51	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
52	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
53	DIVISION	☐	SPART	SPART	CHAR	2	0	Division
54	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
55	SALES_GRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
56	SALES_OFF	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
57	SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
58	DE_CRE_IND	☐	TBTKZ	TBTKZ	CHAR	1	0	Indicator: Subsequent Debit/Credit
59	P_EL_PRCTR	☐	EPRCTR	PRCTR	CHAR	10	0	Partner profit center for elimination of internal business
60	XMFRW	☐	XMFRW	XFELD	CHAR	1	0	Indicator: Update quantity in RW
61	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
62	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
63	BASE_UOM_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	*
64	INV_QTY	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
65	INV_QTY_SU	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
66	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
67	SALES_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	*
68	PO_PR_QNT	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
69	PO_PR_UOM	☐	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
70	PO_PR_UOM_ISO	☐	BPRME_ISO	ISOCD_UNIT	CHAR	3	0	Purchase order price unit in ISO code	*
71	ENTRY_QNT	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
72	ENTRY_UOM	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
73	ENTRY_UOM_ISO	☐	ERFME_ISO	ISOCD_UNIT	CHAR	3	0	Unit of entry in ISO code	*
74	VOLUME	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
75	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
76	VOLUMEUNIT_ISO	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	*
77	GROSS_WT	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
78	NET_WEIGHT	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
79	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
80	UNIT_OF_WT_ISO	☐	GEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight in ISO code	*
81	ITEM_CAT	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
82	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
83	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
84	MVT_IND	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
85	REVAL_IND	☐	XUMBW	XFELD	CHAR	1	0	Revaluation
86	ORIG_GROUP	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
87	ORIG_MAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
88	SERIAL_NO	☐	SMO3DZEKK	NUM02	NUMC	2	0	Sequential number of account assignment
89	PART_ACCT	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
90	TR_PART_BA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
91	TRADE_ID	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
92	VAL_AREA	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
93	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
94	ASVAL_DATE	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
95	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
96	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
97	ITM_NUMBER	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
98	COND_CATEGORY	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A