SAP ABAP Table CDBD_PRICING (Business transaction - pricing parameter - set)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBD_PRICING	Table Relationship Diagram
Short Description	Business transaction - pricing parameter - 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	PRICING_GUID	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	ORDERADM_H_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
4	REFGUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
5	REFKIND	☐	CRMT_PARTNER_KIND_OF_ENTRY	CRM_PARTNER_KIND_OF_ENTRY	CHAR	1	0	Source of a partner in a transaction
6	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
7	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
8	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
9	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	*
10	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
11	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
12	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
13	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
14	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
15	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
16	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
17	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
18	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
19	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
20	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
21	VAL_FROM_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
22	VAL_FROM_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
23	VAL_TO_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
24	VAL_TO_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
25	TRANS_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
26	TRANS_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
27	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
28	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
29	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
30	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
31	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
32	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
33	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
34	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	*
35	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
36	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	*
37	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CDBD_PRICING	CURRENCY	TCURC	WAERS
2	CDBD_PRICING	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP	REF	C	CN
3	CDBD_PRICING	EXCHG_TYPE	TCURV	KURST
4	CDBD_PRICING	PRICE_GRP	CRMC_PRICEGRP	PRICE_GROUP
5	CDBD_PRICING	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST	REF	C	CN
6	CDBD_PRICING	TAX_DEST_CTY	T005	LAND1

History

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