Show TOC

 Order / Quotation Item

Technical Name: 0CRM_QUOTA_ORDER_I

Technical Data

DataSource Type

Transactional Data (Transaction Data)

Application Components

CRM Sales (CRM-BTX-SLO)

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 quotation s for sales order items to the equivalent BW InfoSource ( Quotations for Sales Orders: 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

BW_ASSIGN

Assignment between BW and CO

ORDERADM_I

ITM_TYPE

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

INCOTERMS1

Incoterms 1

SHIPPING

INCOTERMS1

INCOTERMS2

Incoterms 2

SHIPPING

INCOTERMS2

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

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

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

TAX_AMOUNT

Tax amount in document currency

PRICING_I

TAX_AMOUNT

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