Show TOC

 CRM Service - Data from Planned Orders

Technical name: 0CRM_SRV_PRO_PLAN

Technical Data

DataSource Type

Transaction data

Application Components

0CRM_SERVICE

Available as from OLTP Release

CRM 4.0

RemoteCube-Capable

No

Use

You use this DataSource to extract data from service orders generated during a service plan simulation.

Delta Update

AIMD: After images with deletion flag via delta queue

Fields of Origin for the Extract Structure

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