Quotation Item

Technical Name: 0CRM_QUOTATION_I

Technical Data

DataSource Type	Transactional Data (Transaction Data)
Application Components	CRM Sales 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 quotations for sales contracts to the equivalent BW InfoSource ( Quotations for Contracts: Items ).

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_TO_COMPLET	Duration of time between creation of quotation and conversion of quotation to sales order	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
BWSTONESYS0	Status	STATUS	STATUS
BWSTONESYS1	Status	STATUS	STATUS
BWSTONESYS2	Status	STATUS	STATUS
BWSTONESYS3	Status	STATUS	STATUS
BWSTONESYS8	Status	STATUS	STATUS
BWSTTECSYS2	Status	STATUS	STATUS
CALDAY	Calendar day	ORDERADM_I	CREATED_AT
CATEGORY_ID	Product category ID	PRODUCT_I	PROD_HIERARCHY
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
COMPLETE_TO_END	Time between valid-to date of quotation and date of conversion to sales order	APPOINTMENT	TIMESTAMP_TO
COMPL_CURR_CUM	Currency of value converted to sales order	CUMULATED_I	CURRENCY
COMPL_QTY_CUM	Quantity converted to sales order	CUMULATED_I	QUANTITY
COMPL_UNIT_CUM	Unit of quantity converted to sales order	CUMULATED_I	QUANTITY_UNIT
COMPL_VALUE_CUM	Value converted to sales order	CUMULATED_I	VALUE
CONFIRMED_DATE	Latest confirmation date of item schedule line	SCHEDLIN_I	LATEST_TIME_CONF
CONFIRMED_QTY	CRM confirmed quantity	SCHEDLIN_I	CONFIRMED_QTY
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 quotation	APPOINTMENT	TIMESTAMP_FROM
DURA_UNIT	Time unit of duration	APPOINTMENT	TIMESTAMP_FROM
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
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	Business transaction GUID	ORDERADM_H	ORDERADM_H_GUID
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
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
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
PRICE_DATE	Pricing date	PRICING	PRICE_DATE
PROBABILITY	Probability that quotation will become sales order	SALES	PROBABILITY
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
QUOTATION_GUID	Quotation GUID	DOC_FLOW	OBJKEY_A
QUOT_QTY_CUM	Quotation item quantity	SCHEDLIN_I	ORDER_QTY
QUOT_VALID_FROM	Valid-from date of quotation	APPOINTMENT	TIMESTAMP_FROM
QUOT_VAL_CUM	Quotation item value	PRICING_I	NET_VALUE
RECORDMODE	BW delta procedure: update mode	ORDERADM_H	TASK
REF_CURRENCY	Reference currency	PRICING	REF_CURRENCY
REJECTION	Reason for rejection	SALES	REJECTION
REL_BEFORE_END	Duration between quotation completion and end date	APPOINTMENT	TIMESTAMP_TO
REL_TO_BEGIN	Duration between quotation start date and completion	APPOINTMENT	TIMESTAMP_FROM
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
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
STATUS_EXPIRED	Status that quotation has expired	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