Sales Contract Item

Technical Name: 0CRM_SALES_CONTR_I

Technical Data

DataSource Type	Transactional Data (Transaction Data)
Application Components	CRM Contracts (CRM-BTX-CTR)
Available as from OLTP Release	CRM 3.0A
Available as from PlugIn Release	N/A
RemoteCube-Capable

Use

This DataSource contains the fields necessary for extracting information from the CRM sales contractitems to the equivalent BW InfoSource ( CRM Sales Contract Items ).

Note Note

If you make any modifications to a sales contract, for example, you create a sales order from this contract, then you must run the report Automatic Postprocessing of CRM Transactions (technical name: CRM_ORDER_POSTPROCESSING). This ensures that the delta queueis updated and the changes are uploaded to the BW InfoSource.

For more information about this report, see the SAP Help Portal under Start of the navigation path SAP Cross-Industry Solutions Next navigation step SAP Customer Relationship Mgmt. mySAP Customer Relationship Management CRM Enterprise Contract Management Contract Processing Basic Functions Partial Processing of Business Transactions End of the navigation path .

End of the note.

Delta Update

You can run an initial, complete, and delta upload for this DataSource.

Fields of Origin for the Extract Structure

Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
ACT_CATEGORY	Activity category	ACTIVITY_H	CATEGORY
ACT_DIRECTION	Activity direction	ACTIVITY_H	DIRECTION
ACT_REASON_CAT	Activity reason (category)	SRV_SUBJECT	KATALOGART
ACT_REASON_CODE	Activity reason (code)	SRV_SUBJECT	CODE
ACT_REASON_GROUP	Activity reason (code group)	SRV_SUBJECT	CODEGRUPPE
BASE_QTY_UNIT	Product quantity in base unit of measure	PRODUCT_I	BASE_QTY_UNIT
BEGIN_DATE	Contract start date	APPOINTMENT	TIMESTAMP_FROM
BILLING_BLOCK	Billing block	BILLING	BILLING_BLOCK
BILLING_DATE	Billing date	BILLING	BILL_DATE
BILL_TO_PARTY	Bill-to party	PARTNER	PARTNER_NO
BWSTLOCSYS0	Status	STATUS	STATUS
BWSTLOCSYS1	Status	STATUS	STATUS
BWSTLOCSYS2	Status	STATUS	STATUS
BWSTONESYS0	Status	STATUS	STATUS
BWSTONESYS1	Status	STATUS	STATUS
BWSTONESYS2	Status	STATUS	STATUS
BWSTONESYS3	Status	STATUS	STATUS
BWSTONESYS6	Status	STATUS	STATUS
BWSTONESYS7	Status	STATUS	STATUS
BWSTONESYS8	Status	STATUS	STATUS
BWSTTECSYS1	Status	STATUS	STATUS
BWSTTECSYS2	Status	STATUS	STATUS
CALDAY	Calendar day	ORDERADM_I	CREATED_AT
CALL_OF_CURR_CUM	Currency of released value	CUMULATED_I	CURRENCY
CALL_OF_QTY_CUM	Released quantity of contract	CUMULATED_I	QUANTITY
CALL_OF_UNIT_CUM	Unit of released quantity	CUMULATED_I	QUANTITY_UNIT
CALL_OF_VAL_CUM	Released value of contract	CUMULATED_I	VALUE
CANCPARTY	Cancellation party	CANCEL	CANCPARTY
CANC_REASON	Cancellation reason	CANCEL	CANC_REASON
CHANGED_AT	Date on which transaction was last changed	ORDERADM_H	CHANGED_AT
CHANGED_BY	User by whom transaction was last changed	ORDERADM_H	CHANGED_BY
CLASSIFICATION	Contract classification	FINPROD_I	CLASSIFICATION
CLASSIF_LOCAL	Local classification type	FINPROD_I	CLASSIF_LOCAL
CONTACT_PERSON	Contact person	PARTNER	PARTNER_NO
CREATED_AT	Date on which transaction was created	ORDERADM_H	CREATED_AT
CREATED_BY	User by whom transaction was created	ORDERADM_I	CREATED_BY
CURRENCY	Currency	PRICING	CURRENCY
CUST_GROUP	Customer group	PRICING	CUST_GROUP
CUST_GROUP1 - CUST_GROUP5	Customer group 1-5	SALES	CUST_GROUP1- CUST_GROUP5
DESCRIPTION_UC	Transaction description in upper case	ORDERADM_H	DESCRIPTION_UC
DIS_CHANNEL	Distribution channel	ORGMAN	DIS_CHANNEL
DIVISION	Division	ORGMAN	DIVISION
DURA	Duration of contract	APPOINTMENT	TIMESTAMP_FROM
DURA_FULLFILL	Duration between contract start and contract fulfillment
DURA_UNIT	Time unit of duration	APPOINTMENT	TIMESTAMP_FROM
ENDING_DATE	Contract end date	APPOINTMENT	TIMESTAMP_TO
EXCHG_DATE	Exchange rate date	PRICING	EXCHG_DATE
EXCHG_RATE	Exchange rate	PRICING	EXCHG_RATE
EXCHG_TYPE	Exchange rate type	PRICING	EXCHG_TYPE
EXECUTING_CC	Executing interaction center	PARTNER	PARTNER_NO
EXPONENT10	10x exponent for quantity conversion	PRODUCT_I	EXPONENT10
FREIGHT	Freight cost in document currency	PRICING_I	FREIGHT
FULLFILL_QTY	Degree of fulfillment of quantity	CUMULATED_I	QUANTITY
FULLFILL_VAL	Degree of fulfillment of value	CUMULATED_I	VALUE
GROSS_VALUE	Gross ordered value in purchase order currency	PRICING_I	GROSS_VALUE
GROSS_VALUE_H	Total gross value in document currency	CUMULAT_H	GROSS_VALUE
GROSS_WEIGHT	Gross weight	PRODUCT_I	GROSS_WEIGHT
GUID	Billing plan GUID	BILLPLAN	REF_GUID
GUID	Business transaction GUID	ORDERADM_H	ORDERADM_H_GUID
INVOICED_QTY_CUM	Billed quantity of an item	CUMULATED_I	QUANTITY
INVOICED_VAL_CUM	Billed value of an item	CUMULATED_I	VALUE
INDUSTRY	Industry sector	SALES	INDUSTRY
ITEM_CHANGED_AT	Date on which item was last changed	ORDERADM_I	CHANGED_AT
ITEM_CHANGED_BY	User by whom item was last changed	ORDERADM_I	CHANGED_BY
ITEM_CREATED_AT	Date on which item was last created	ORDERADM_I	CREATED_AT
ITEM_CREATED_BY	User by whom item was last created	ORDERADM_I	CREATED_BY
ITEM_GUID	Transaction GUID	ORDERADM_I	GUID
ITEM_OBJECT_TYPE	CRM item object type	ORDERADM_I	ITM_TYPE
ITM_TYPE	Item category	ORDERADM_I	ITM_TYPE
LEAD_CREATED_AT	Date on which lead was created	ORDERADM_I	CREATED_AT
LESSOR_IRR	Leasor's internal interest rate	FINPROD_I	LESSOR_IRR
LOGICAL_SYSTEM	Logical system	ORDERADM_H	LOGICAL_SYSTEM
LOGSYS_PRED	Logical system of preceding document	DOC_FLOW	LOGSYS_A
MATERIAL	Distribution of CRM product to R/3 material	ORDERADM_I	PRODUCT
MKT_ELEMENT	Marketing plan element	ORDERADM_H	ORDERADM_H_GUID
NET_PRICE	Net price	PRICING_I	NET_PRICE
NET_VALUE	Net value	PRICING_I	NET_VALUE
NET_VALUE_H	Total net value of document in document currency	CUMULAT_H	NET_VALUE
NET_WEIGHT	Net weight	PRODUCT_I	NET_WEIGHT
NUMBER_INT	Item number in document	ORDERADM_I	NUMBER_INT
NUMBER_OF_I	Number of order items	ORDERADM_I	GUID
NUM_OF_HEAD	Number of order headers	ORDERADM_H	ORDERADM_H_GUID
OBJECT_ID	Transaction number	ORDERADM_H	OBJECT_ID
OBJECT_TYPE	Business transaction type	ORDERADM_H	OBJECT_TYPE
OCCURRENCE	Counter: indicates that transaction type occurs at least once in document	ORDERADM_I	GUID
OL_MASTER_PRP_ID	External ID for partner-product range	ORDPRP_OBJL_I_D	MASTER_PRP_ID
OL_MAST_PRP_GUID	External GUID for partner-product range (PPR)	ORDPRP_OBJL_I_D	MASTER_PRP_GUID
OL_PRODUCT_GUID	Product GUID from object list	ORDPRP_OBJL_I_D	PRODUCT_GUID
OL_PRODUCT_ID	Product ID from object list	ORDPRP_OBJL_I_D	PRODUCT_ID
OL_SHORT_TEXT_UC	Product description in upper case	ORDPRP_OBJL_I_D	SHORT_TEXT
OPPT_CREATED_AT	Date on which opportunity was created	ORDERADM_I	CREATED_AT
ORDER_DATE	Posting date	ORDERADM_I	ORDER_DATE
ORDER_QTY	CRM order quantity	SCHEDLIN_I	ORDER_QTY
O_CALLOF_QTY_CUM	Open (to be released) item quantity	CUMULATED_I	QUANTITY
O_CALLOF_VAL_CUM	Open (to be released) item value	CUMULATED_I	VALUE
O_INV_QTY_CUM	Open (to be billed) item quantity	CUMULATED_I	QUANTITY
O_INV_VAL_CUM	Open (to be billed) item value	CUMULATED_I	VALUE
PARTNER_PROD	Business partner's product number	ORDPRP_I	PARTNER_PROD
PAYER	Payer	PARTNER	PARTNER_NO
PCAT_CTY_ID	Catalog area number	SALES	PCAT_CTY_ID
PCAT_HDR_ID	Product catalog number	SALES	PCAT_HDR_ID
PCAT_VRT_ID	Catalog variant number	SALES	PCAT_VRT_ID
PERSON_RESP	Employee responsible	PARTNER	PARTNER_NO
PL_CATALOG_ID	Catalog ID selected from PPR	ORDPRP_I_D	CATALOG_ID
PL_CATEGORY_GUID	Catalog GUID selected from product list	ORDPRP_I_D	CATEGORY_GUID
PL_CATEGORY_ID	Catalog ID selected from product list	ORDPRP_I_D	CATEGORY_ID
PL_CTLOG_ITEM_ID	Catalog item from product list	ORDPRP_I_D	CATALOG_ITEM_ID
PL_MASTER_PRP_ID	ID for PPR assignment	ORDPRP_I_D	MASTER_PRP_ID
PL_MAST_PRP_GUID	Internal, unique key for PPR objects	ORDPRP_I	GUID
PL_MAST_PRP_GUID	Internal, unique key for PPR objects	ORDPRP_I_D	MASTER_PRP_GUID
PL_PARTNER_PROD	PPR product number	ORDPRP_I_D	PARTNER_PROD
PL_PRODUCT_GUID	Product GUID from product list	ORDPRP_I_D	PRODUCT_GUID
PL_PRODUCT_ID	Product ID from product list	ORDPRP_I_D	PRODUCT_ID
PL_SHORT_TEXT_UC	Product description in upper case	ORDPRP_I_D	SHORT_TEXT
POSTING_DATE	Transaction posting date	ORDERADM_H	POSTING_DATE
PRC_GROUP1 - PRC_GROUP5	Product groups 1 to 5	PRODUCT_I	PRC_GROUP1 - PRC_GROUP5
PREDEC_OBJKEY	GUID of preceding transaction	DOC_FLOW	OBJKEY_A
PREDEC_OBJTYPE	Preceding transaction type	DOC_FLOW	OBJTYPE_A
PRED_ACT_GUID	Preceding activity GUID	ACTIVITY_H	GUID
PRED_LEAD_GUID	Preceding lead GUID	DOC_FLOW	OBJKEY_A
PRED_OPPT_GUID	Preceding opportunity GUID	DOC_FLOW	OBJKEY_A
PROCESS_CATALOG	Catalog	SRV_SUBJECT	KATALOGART
PROCESS_CATEGORY	Activity category	ACTIVITY_H	CATEGORY
PROCESS_CODE	Code	SRV_SUBJECT	CODE
PROCESS_CODEGR	Code group	SRV_SUBJECT	CODEGRUPPE
PROCESS_OBJTYPE	Object type of preceding transaction	DOC_FLOW	OBJTYPE_A
PROCESS_QTY_DEN	Denominator for converting quantity into base units of measure	PRODUCT_I	PROCESS_QTY_DEN
PROCESS_QTY_NUM	Numerator for converting quantity into base units of measure	PRODUCT_I	PROCESS_QTY_NUM
PROCESS_QTY_UNIT	Sales unit	PRODUCT_I	PROCESS_QTY_UNIT
PROCESS_TYPE	Business transaction type	ORDERADM_H	PROCESS_TYPE
PRODUCT_GUID	32-character product GUID	ORDERADM_I	PRODUCT
PRODUCT_ID	Product ID	ORDERADM_I	PRODUCT
PROD_PR_GROUP	Product group	PRODUCT_I	PROD_PR_GROUP
PURCHASE_OPTION	Purchasing option	FINPROD_I	PURCHASE_OPTION
QUOTATION_GUID	Quotation GUID	DOC_FLOW	OBJKEY_A
QUOT_VALID_FROM	Valid-from date of quotation	APPOINTMENT	TIMESTAMP_FROM
RECORDMODE	BW delta procedure: update mode	ORDERADM_H	TASK
REF_CURRENCY	Reference currency	PRICING	REF_CURRENCY
REJECTION	Reason for rejection	SALES	REJECTION
RESULT_RATEPERK	Residual value (pricing)	BILLPLAN_D	RESULT_RATEPERK
RESID_VALUE_FLAG	Rate per X	FINPROD_I	ROUND_PROFILE
SALES_EMPLOYEE	Sales employee	PARTNER	PARTNER_NO
SALES_GROUP	Sales group	ORGMAN	SALES_GROUP
SALES_OFFICE	Sales office	ORGMAN	SALES_OFFICE
SALES_ORG	Sales organization	ORGMAN	SALES_ORG
SALES_ORG_RESP	Responsible sales organization	ORGMAN	SALES_ORG_RESP
SALESPARTNER	Sales partner	PARTNER	PARTNERNO
SERVICE_ORG	Service organization	ORGMAN	SERVICE_ORG
SERVICE_ORG_RESP	Responsible service organization	ORGMAN	SERVICE_ORG_RESP
SHIP_TO_PARTY	Ship-to party	PARTNER	PARTNER_NO
SHORT_TEXT_UC	Product description in upper case	ORDERADM_I	DESCRIPTION_UC
SOLD_TO_PARTY	Sold-to party	PARTNER	PARTNER_NO
SRV_ESCAL	Response profile (service contracts)	SERVICE_I	SRV_ESCAL
SRV_SERWI	Service profile	SERVICE_I	SRV_SERWI
START_OF_BILLING	Start date of billing plan	BILLING	BILL_DATE
STATUS_ACCEPTED	Quotation accepted	STATUS	STATUS
STATUS_CANCELLED	Rejected	STATUS	STATUS
STATUS_DOC_SYS	Individual status of object	STATUS	STATUS
STATUS_ERROR	Indicates document contains errors	STATUS	STATUS
STATUS_INVOICED	Billing status	STATUS	STATUS
STATUS_QUOTATION	Quotation accepted	STATUS	STATUS
SUBTOTAL1- SUBTOTAL6	Condition subtotals 1-6 from pricing procedure	PRICING_I	SUBTOTAL1- SUBTOTAL6
TARGET_QUAN_CUM	Cumulated target quantity	SCHEDLIN	QUANTITY
TARGET_VALUE	Cumulated target value	PRICING_I	TARGET_VALUE
TAX_AMOUNT	Tax amount in document currency	PRICING_I	TAX_AMOUNT
TGT_QTY_UNIT_CUM	Unit of target quantity	PRODUCT_I	PROCESS_QTY_UNIT
VALID_FROM_DATE	Quotation valid-from date	APPOINTMENT	ORDERADM_H_GUID
VALID_TO_DATE	Quotation valid-to date	APPOINTMENT	ORDERADM_H_GUID
VOLUME	Volume taken up by one product	PRODUCT_I	VOLUME
VOLUME_UNIT	Volume unit	PRODUCT_I	VOLUME_UNIT
WEIGHT_UNIT	Weight unit	PRODUCT_I	WEIGHT_UNIT