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 contract items to the equivalent BW InfoSource (CRM Sales Contract Items).
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 queue is updated and the changes are uploaded to the BW InfoSource.
For more information about this report, see the SAP Help Portal under SAP Cross-Industry Solutions ® SAP Customer Relationship Mgmt. ® mySAP Customer Relationship Management ® CRM Enterprise ® Contract Management ® Contract Processing ® Basic Functions ® Partial Processing of Business Transactions.
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 |