SAP ABAP Table CRMS_FM_ACL_ACGL09 (CRM FM: G/L account item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-FM-ACL (Application Component) Accruals
     ⤷ CRM_FM_ACL_ERP (Package) Accrual ERP integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_FM_ACL_ACGL09	Table Relationship Diagram
Short Description	CRM FM: G/L account item

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