SAP ABAP Table CRMT_REPORT_LOC_SALES_ITEM (Compressed Item Information for Sales)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_REPORT_LOC_SALES_ITEM	Table Relationship Diagram
Short Description	Compressed Item Information for Sales

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	DATE_CONTSTART	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
2	TZONE_CONTSTART	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
3	DATE_CONTEND	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
4	TZONE_CONTEND	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
5	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
6	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
7	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
8	VENDOR	☐	CRMT_VENDOR	BU_PARTNER	CHAR	10	0	Vendor	*
9	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
10	SALES_EMPLOYEE_LIST	☐	CRMT_SALES_EMPLOYEE_LIST	TEXT80	CHAR	80	0	Sales Representative
11	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
12	PERSON_RESP_LIST	☐	CRMT_PERSON_RESP_LIST	TEXT80	CHAR	80	0	Employee Responsible
13	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
14	SHIP_TO_PARTY_LIST	☐	CRMT_SHIP_TO_PART_LIST	TEXT80	CHAR	80	0	Ship-To Party: Name
15	BILL_TO_PARTY_LIST	☐	CRMT_BILL_TO_PART_LIST	TEXT80	CHAR	80	0	Bill-To Party: Name
16	PAYER_LIST	☐	CRMT_RP_PAYER_LIST	TEXT80	CHAR	80	0	Payer: Name
17	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
18	CONTACT_PERSON_LIST	☐	CRMT_CONTACT_PERSON_LIST	TEXT80	CHAR	80	0	Contact Person
19	PPR_TEXT	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
20	RELEASED_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
21	RELEASED_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
22	RELEASED_VALUE	☐	CRMT_CUM_VALUE	CRM_COND_VALUE	CURR	19	2	Cumulative Value
23	RELEASED_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
24	TARGET_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
25	TARGET_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
26	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
27	TARGET_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
28	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
29	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
30	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
31	GRADE	☐	BP_GRADE	BP_GRADE	CHAR	10	0	Rating	*
32	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	*
33	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
34	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
35	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
36	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
37	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
38	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
39	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
40	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
41	INT_OBJ_NO	☐	CRMT_INT_OBJ_NO	IB_INSTANCE	NUMC	18	0	Configuration (Internal Object Number)
42	EXIST_VCKEY	☐	CRMT_EXIST_VCKEY	BOOLEAN	CHAR	1	0	Indicator Variant Key Available for Item
43	ROOT_CONFIG	☐	CRMT_ROOT_CONFIG	BOOLEAN	CHAR	1	0	Root Configuration Indicator
44	COMP_QTY	☐	CRMT_COMP_QTY	MENG13	QUAN	13	3	Component quantity
45	COMP_QTY_UNIT	☐	CRMT_COMP_QTY_UNIT	MEINS	UNIT	3	0	Component unit of measure	*
46	BASE_QTY	☐	CRMT_BASE_QTY	MENG13	QUAN	13	3	Base quantity
47	OBJ_IDENT	☐	CRMT_OBJ_IDENT	CHAR50	CHAR	50	0	Object Identifier
48	OBJ_TYPE	☐	CRMT_OBJ_TYPE	CRM_OBJ_TYPE	CHAR	2	0	Type of Object Identifier
49	DATE_KB_DETERM	☐	CRMT_DATE_KB_DETERMINATION	DATUM	DATS	8	0	Date for KB Determination in IPC(Master Data Version Config)
50	CONFIG_FILTER	☐	CRMT_CONFIG_FILTER	IB_INSTANCE	NUMC	18	0	Configuration Filter
51	FILTER_REF	☐	CRMT_FILTER_REF	BOOLEAN	CHAR	1	0	Filter Flag is Referenced
52	PURCHASE_OPTION	☐	CRMT_PURCHASE_OPTION	CRMT_PURCHASE_OPTION	CHAR	1	0	End of Lease Purchase Option
53	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
54	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
55	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
56	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
57	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
58	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
59	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
60	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
61	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
62	CATALOG_ID	☐	CATALOG_PL	KATALOGID	CHAR	20	0	Catalog ID, from Which the Line PPR Was Selected	*
63	CATALOG_ITEM	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
64	DESCRIPT_PARTNER_PUR	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
65	ITM_TYPE_TEXT	☐	CRMT_ITM_TYPE_DESC	TEXT40	CHAR	40	0	Item Category Text
66	DELIVERY_BLOCK	☐	CRMT_BUS_DEL_BLOCK_REASON	CRMT_BUS_DEL_BLOCK_REASON	CHAR	2	0	Business Partner (CRM): Delivery Block Reason	*
67	BILL_VALUE	☐	CRMT_INVOICED_VAL_OLTP	CRM_COND_VALUE	CURR	19	2	Billed Value of an Item
68	DELV_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
69	DELV_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
70	BILL_QUANTITY	☐	CRMT_CUM_QUAN	CRM_MENGV15	QUAN	15	3	CRM Quantity for Cumulated I
71	DELV_VALUE	☐	CRMT_DELV_VAL_OLTP	CRM_COND_VALUE	CURR	19	2	Delivered Value of an Item
72	DELV_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
73	BILL_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
74	BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
75	EARLCONF_DATE	☐	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
76	CREATEDATDATE_I	☐	CRMT_CREATED_AT_DATE	SYDATS	DATS	8	0	Transaction Was Created on This Date
77	CHANGEDATDATE_I	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
78	ORDER_DATE_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
79	.INCLUDE	☐				0	0	Reporting reference and configurated product data
80	REF_IOBJECTID_I	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
81	REF_IOBJECTGU_I	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
82	REF_CNF_PRODID_I	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
83	REF_CNF_PRODGU_I	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
84	REF_PROD_ID_I	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
85	REF_PROD_GUID_I	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
86	REF_OBJ_FAM_I	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*

History

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