SAP ABAP Table CRMT_REPORT_SALES_LDB1 (Special Structure for log DB crmldb_sales_mon)

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_SALES_LDB1	Table Relationship Diagram
Short Description	Special Structure for log DB crmldb_sales_mon

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	.INCLUDE	☐				0	0	Reporting Structure for CRMD_SALES
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	Sales Set: Structure With External Fields
6	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
7	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
8	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
9	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
10	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
11	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
12	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
13	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
14	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
15	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
16	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
17	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
18	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
19	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	CRMC_REJECTION
20	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
21	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
22	REQ_DLV_DATE	☐	CRMT_REQ_DLV_DATE	BCOS_TSTMP	DEC	15	0	Requested Delivery Date Header
23	REQ_TIMEZONE	☐	CRMT_REQ_DATE_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone Requested Delivery Date Header	*
24	RULE_REQ_DATE	☐	CRMT_RULE_REQ_DATE	TIMERULEID	RAW	16	0	Rule Reqested Delivery Date Header	*
25	ROUNDING	☐	CRMT_ROUNDING	CRM_ROUNDING	CHAR	1	0	Round Requirement Quantity
26	PAR_ATP_SSTOCK	☐	CRMT_PAR_ATP_SSTOCK	CRM_PAR_ATP_SSTOCK	CHAR	1	0	Parameter-Dependent ATP Safety Stock
27	CONF_RULE	☐	CRMT_CONF_RULE	CRM_CONF_RULE	CHAR	1	0	Confirmation Rule
28	SUBST_EXCL	☐	CRMT_ATP_SUBST_EXCL	CRM_ATP_SUBST_EXCL	CHAR	2	0	Rule Criterion 1	CRMC_SUBST_EXCL
29	SEARCH_PATTERN	☐	CRMT_SEARCH_PATTERN	CRM_SEARCH_PATTERN	CHAR	10	0	Rule Criterion 2	CRMC_ATP_SEARCH
30	REASSIGN_ABILITY	☐	CRMT_REASSIGN_ABILITY	CRM_REASSIGN_ABILITY	CHAR	1	0	Reassignment of Order Confirmations
31	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
32	MAX_LOC	☐	CRMT_MAX_LOC		INT1	3	0	Maximum Number of Locations
33	CUST_PROFILE	☐	CRMT_CUST_PROFILE	CRM_CUST_PROFILE	CHAR	10	0	ID of Profile of Sold-To Party
34	.INCLUDE	☐				0	0	EEW Extension
35	SALES_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
36	.INCLUDE	☐				0	0
37	.INCLUDE	☐				0	0	Sales Set: Structure With System Fields
38	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
39	REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
40	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
41	PCAT_HDR_GUID	☐	COMT_PCAT_HDR_GUID	SYSUUID	RAW	16	0	Product Catalog GUID (Header)
42	PCAT_VRT_GUID	☐	COMT_PCAT_VRT_GUID	SYSUUID	RAW	16	0	Product Catalog Variant GUID
43	PCAT_CTY_GUID	☐	COMT_PCAT_CTY_GUID	SYSUUID	RAW	16	0	GUID of a Product Catalog Area
44	MAINPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
45	MAINPARTNERFCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
46	PARTNER_FCT_TXT	☐	CRMT_REPORT_FNKT_LONG	TEXT30	CHAR	30	0	Partner Function: Long Text
47	PARTNER_FCT_SHO	☐	CRMT_REPORT_FNKT_SHORT	TEXT4	CHAR	4	0	Partner Function: Short Text

Foreign Keys

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

History

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