Technical name: 0CRM_SRV_PRO_PLAN
DataSource Type |
Transaction data |
---|---|
Application Components |
|
Available as from OLTP Release |
CRM 4.0 |
RemoteCube-Capable |
No |
You use this DataSource to extract data from service orders generated during a service plan simulation.
AIMD: After images with deletion flag via delta queue
Fields in the Extract Structure |
Description of the Field in the Extract Structure |
---|---|
BASE_QTY_UNIT |
Base Unit of Measure of Product |
BILLING_BLOCK |
Business Partner (CRM): Billing Block Reason |
BILLING_DATE |
Billing Date |
BILL_TO_PARTY |
Bill-To Party |
BWSTTECSYS0 |
BW Status |
BWSTTECSYS1 |
BW Status |
BWSTTECSYS2 |
BW Status |
BW_ASSIGN |
Assign BW and CO |
CALDAY |
Calendar Day |
CATALOG_ID |
Catalog ID from which the line was selected |
CATALOG_ITEM_ID |
Catalog Item (Unique Key) |
CATEGORY_GUID |
Category GUID |
CATEGORY_ID |
Category ID |
CHA_SRV_CUST_END |
Data Element for Service-Date Char. :Date Requested by Cust. |
CHA_SRV_RREADY |
Data Element for Service-Date Characteristic SLA Date |
CLIENT |
Client |
CONFIRMED_DATE |
Latest Confirmation Date for Item Schedule Line |
CONFIRMED_QTY |
CRM: Confirmed Quantity |
CONFIRM_RELEVANT |
Relevant for Confirmation |
CONTACT_PERSON |
Customer Contact Person |
CREDIT_INDICATOR |
Credit Debit Indicator |
CURRENCY |
Currency |
CUST_GROUP |
Customer group |
CYCLE_COUNTS |
No. of Releases |
DATE_FROM |
Start Date for Simulation |
DATE_TO |
End Date for Simulation |
DESCRIPTION_UC |
Business Transaction Description (Capital Letters) |
DESCR_LANGUAGE |
Language Key of Description |
DISPO_FLG |
Relevant for Resource Planning |
DIS_CHANNEL |
Distribution channel |
DIVISION |
Division |
DURATION |
Duration |
DURATION_UNIT |
Unit for Duration of Work |
EXCHG_DATE |
Exchange rate date |
EXCHG_RATE |
Exchange Rate |
EXCHG_TYPE |
Exchange Rate Type |
EXECUTING_CC |
Executing Interaction Center |
EXPONENT10 |
10 Exponent for Quantity Conversion |
FREIGHT |
Shipment costs in document currency |
GROSS_VALUE |
Gross order value in PO currency |
GROSS_VALUE_H |
Gross Value for Document in Total Document Currency |
GUID |
GUID for a Transaction |
GUID_OBJECT |
GUID for a Transaction |
HEADER_FLG |
Indicates Whether Order Header or Item |
IB_COMP_REF_GUID |
GUID for a Transaction |
IB_COMP_VALID |
Date |
ITEM_GUID |
GUID for a Transaction |
ITEM_OBJECT_TYPE |
CRM Item Object Type |
ITM_TYPE |
Item Category |
ITM_USAGE |
Usage of Higher-Level Item |
LOGICAL_SYSTEM |
Logical System |
LOGSYS_PRED |
Logical System |
MATERIAL |
Distribution CRM -> R/3: Material |
NET_PRICE |
Net Price |
NET_VALUE |
Total Expected Net Value Products in Document Currency |
NET_VALUE_H |
Total Net Value of Document in Document Currency |
NET_VALUE_MAN |
Total Expected Net Value Products in Document Currency |
NET_VALUE_MAN_H |
Expected Net Value Products in Document Currency Total |
NUMBER_INT |
Item Number in Document |
NUMBER_OF_I |
Order Item Number |
NUMBER_PARENT |
Higher-Level Item Number in Document |
NUM_OF_HEAD |
Order Header Number |
OBJECT_ID |
Transaction Number |
OBJECT_TYPE |
Business Transaction Category |
OCCURRENCE |
Numerator: Document Cat. Appears at Least Once in Document |
ORDER_DATE |
Posting Date |
ORDER_QTY |
CRM: Order Quantity |
PARTNER_PROD |
Product Number of Business Partner |
PAYER |
Vendor |
PERSONS |
Number of Persons |
PERSON_RESP |
Employee Responsible |
PLANNED_DATE |
Plan Date of Service Order (Simulation) |
PMNTTRMS |
Terms of Payment |
PREDEC_OBJKEY |
GUID for a Transaction |
PREDEC_OBJTYPE |
Object Type of a Preceding Document |
PRICE_DATE |
Pricing Date |
PROCESS_QTY_DEN |
Denominator (factor) for conversion trans. quantity in BME |
PROCESS_QTY_NUM |
Numerator (factor) for conversion trans. quantity in BME |
PROCESS_QTY_UNIT |
Unit of Measure in Which the Product is Sold |
PROCESS_TYPE |
Business Transaction Type |
PRODUCT_GUID |
GUID for Product CHAR32 |
PRODUCT_ID |
Product ID |
PROD_PR_GROUP |
Product Group |
RECORDMODE |
BW Delta Process: Update Mode |
REF_CURRENCY |
Reference Currency |
REQUESTED_DATE |
Order Date |
SALESPARTNER |
Sales Partners |
SALES_EMPLOYEE |
Employee |
SALES_GROUP |
Sales Group Abbreviation |
SALES_OFFICE |
Sales Office Abbreviation |
SALES_ORG |
Sales Organization: Description of Department |
SALES_ORG_RESP |
Organizational Unit (Sales) |
SCHED_QUANTITY |
CRM Schedule Line Quantity |
SERVICE_EMPLOYEE |
Responsible Service Representative |
SERVICE_ORG |
Service Organization Identifier |
SERVICE_ORG_RESP |
Organizational Unit (Service) |
SERVICE_TEAM |
Service Team |
SERVICE_TYPE |
Service Type |
SHIP_TO_PARTY |
Ship-To Party |
SHORT_TEXT_UC |
Short Text for Product in Capital Letters for BW |
SIMULATED_AT |
Simulated On (Forecast) |
SOLD_TO_PARTY |
Sold-To Party |
SRV_CONTR_VALID |
General flag |
SRV_ESCAL |
Response Profile |
SRV_SERWI |
Service Profile |
SUBTOTAL1 |
Subtotal 1 from pricing procedure for condition |
SUBTOTAL2 |
Subtotal 2 from pricing procedure for condition |
SUBTOTAL3 |
Subtotal 3 from pricing procedure for condition |
SUBTOTAL4 |
Subtotal 4 from pricing procedure for condition |
SUBTOTAL5 |
Subtotal 5 from pricing procedure for condition |
SUBTOTAL6 |
Subtotal 6 from pricing procedure for condition |
TARGET_VALUE |
Target Value for Value Contract |
TAX_AMOUNT |
Tax amount in document currency |
TIMESTAMP_FROM |
Time Stamp (In UTC) |
VALUATION_TYPE |
Valuation Type |