SAP ABAP Table CRMT_BUS_SET0020_BW (BW Extraction: CRM Shipping Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BUPA_EXT_MD (Package) CRM BP Extraction BW for Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUS_SET0020_BW	Table Relationship Diagram
Short Description	BW Extraction: CRM Shipping Data

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	.INCLUDE	☐				0	0	CRM BP Set Structure for Shipping Data
4	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
5	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
6	SHIPPING_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
7	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
8	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
9	UNLIM_DLV_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
10	DLV_PRIORITY	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	CRMC_DLV_PRIO
11	ORDER_COMBINED	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
12	PARTIAL_DLV	☐	CRMT_PART_DLV	CRM_PART_DLV	CHAR	1	0	Delivery Control
13	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	CRMC_TRANS_MOT
14	PART_DLV_ITM	☐	CRMT_PART_DLV_ITM	CRM_PART_DLV_ITM	CHAR	1	0	Delivery Control (Item)
15	INV_BEFORE_GI	☐	CRMT_BEFORE_LOADING	CRM_BEFORE_LOADING	CHAR	1	0	Invoice Before Goods Issue (IBGI)
16	MAX_NO_DLV	☐	CRMT_MAX_PL_DLV		DEC	1	0	Maximum number of partial deliveries allowed per item
17	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
18	SET_GUID	☐	CRMT_BU_SET_GUID	SYSUUID	RAW	16	0	GUID for sets of business partner
19	KEY_GUID	☐	CRMT_KEY_GUID_BW	SYSUUID	RAW	16	0	Technical Key (GUID)
20	KEYTYPE_ID	☐	CRMT_KEY_TYPE_ID_BW	OBJECTNAME	CHAR	30	0	Key Type
21	.INCLUDE	☐				0	0	Internal Structure for Sales and Distribution Area
22	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
23	CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
24	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUS_SET0020_BW	DLV_PRIORITY	CRMC_DLV_PRIO	DLV_PRIO	REF	C	CN
2	CRMT_BUS_SET0020_BW	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1	REF	C	CN
3	CRMT_BUS_SET0020_BW	SHIPPING_COND	CRMC_SHIP_COND	SHIP_COND	REF	C	CN
4	CRMT_BUS_SET0020_BW	TRANS_MOT	CRMC_TRANS_MOT	MOT		1	1

History

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