Show TOC

  Sales Order Item

Technical Name: 0CRM_SALES_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 sales orderitems to the equivalent BW InfoSource ( CRM Sales Order 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_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

BWSTONESYS5

Status

STATUS

STATUS

BWSTONESYS6

Status

STATUS

STATUS

BWSTONESYS7

Status

STATUS

STATUS

BWSTONESYS8

Status

STATUS

STATUS

BWSTTECSYS0

Status

STATUS

STATUS

BWSTTECSYS1

Status

STATUS

STATUS

BWSTTECSYS2

Status

STATUS

STATUS

BW_ASSIGN

Assignment between BW and CO

ORDERADM_I

ITM_TYP

CATEGORY_ID

Category ID

PRODUCT_I

PROD_HIERARCHY

CALDAY

Calendar day

ORDERADM_I

CREATED_AT

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

CONFIRMED_DATE

Latest confirmation date in 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

CREDIT_INDICATOR

Credit/debit indicator

PRICING_I

CREDIT_INDICATOR

CURRENCY

Currency

PRICING

CURRENCY

CUST_GROUP

Customer group

PRICING

CUST_GROUP

CUST_GROUP1 - CUST_GROUP5

Customer group 1-5

SALES

CUST_GROUP1- CUST_GROUP5

DELIVERY_QTY_CUM

Delivered item quantity

CUMULATED_I

QUANTITY

DELIVERY_VAL_CUM

Delivered item value

CUMULATED_I

VALUE

DIS_CHANNEL

Distribution channel

ORGMAN

DIS_CHANNEL

DIVISION

Division

ORGMAN

DIVISION

EARLIEST_CONFIRM

Earliest confirmation date (not yet delivered)

SCHEDLIN

FROM_TIME

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

HOM_FLAG

Indicator for hosted order management scenarios

Flag - not included in any table

CRMT_HOM_FLAG

INDUSTRY

Industry sector

SALES

INDUSTRY

INVOICED_QTY_CUM

Billed quantity of an item

CUMULATED_I

QUANTITY

INVOICED_VAL_CUM

Billed value of an item

CUMULATED_I

VALUE

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

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

O_ORDER_QTY_CUM

Open order quantity of item

CUMULATED_I

QUANTITY

O_ORDER_VAL_CUM

Open order value of item

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

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

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_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

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

SCENARIO

Scenario ID (sales or service)

ORDERADM_H

SCENARIO

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_FROM

Sold-from party

CRMD_PARTNER

CRMT_PARTNER_NO

SOLD_TO_PARTY

Sold-to party

PARTNER

PARTNER_NO

STATUS_DELIVERED

Status - item delivered

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