SAP ABAP Table BAD_SALES (BAD - Sales Set)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
     ⤷ BAD_ORDER (Package) CRM Order: BAD Objects - General Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BAD_SALES	Table Relationship Diagram
Short Description	BAD - Sales Set

Delivery and Maintenance

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

Foreign Keys

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

History

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