SAP ABAP Table CRMT_REPORT_LOC_SALES (Output Fields: Sales for CRM_Transaction)

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	Table Relationship Diagram
Short Description	Output Fields: Sales for CRM_Transaction

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	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
2	NET_VALUE	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
3	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
4	.INCLUDE	☐				0	0	PARTNER (Sales) Data for BW DataSources
5	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
6	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
7	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
8	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
9	SOLD_FROM	☐	CRMT_SOLD_FROM_PARTY_ID	BU_PARTNER	CHAR	10	0	Salesperson ID	*
10	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
11	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
12	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
13	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
14	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
15	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
16	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
17	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
18	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
19	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
20	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
21	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
22	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
23	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	CRMC_REJECTION
24	REQ_DLV_DATE	☐	CRMT_REQ_DLV_DATE	BCOS_TSTMP	DEC	15	0	Requested Delivery Date Header
25	REQ_TIMEZONE	☐	CRMT_REQ_DATE_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone Requested Delivery Date Header	*
26	RULE_REQ_DATE	☐	CRMT_RULE_REQ_DATE	TIMERULEID	RAW	16	0	Rule Reqested Delivery Date Header	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_REPORT_LOC_SALES	CUST_GROUP1	CRMC_CUSTGRP1	CUST_GROUP1	REF	C	CN
2	CRMT_REPORT_LOC_SALES	CUST_GROUP2	CRMC_CUSTGRP2	CUST_GROUP2	REF	C	CN
3	CRMT_REPORT_LOC_SALES	CUST_GROUP3	CRMC_CUSTGRP3	CUST_GROUP3	REF	C	CN
4	CRMT_REPORT_LOC_SALES	CUST_GROUP4	CRMC_CUSTGRP4	CUST_GROUP4	REF	C	CN
5	CRMT_REPORT_LOC_SALES	CUST_GROUP5	CRMC_CUSTGRP5	CUST_GROUP5	REF	C	CN
6	CRMT_REPORT_LOC_SALES	REJECTION	CRMC_REJECTION	REJECTION_CODE
7	CRMT_REPORT_LOC_SALES	USAGE_TYPE	CRMC_USAGE	CALL_USAGE	REF	C	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	20C