Field in SAP SCM

Object in the BI System

Field Description

SO_HEAD_GUID

0CRM_OHGUID

Internal sales order ID (GUID)

SO_ITEM_GUID

0CRM_ITMGUI

Internal sales order item ID (GUID)

SO_LINE_ID

0SPL_SLINE

Schedule line ID

SF_CAT

0SPL_FILLC

Service fill category

DELAY_PERIOD

0SPL_DELAY

Delay period

FILL_RELEVANCE

0SPL_FILLRL

Service fill relevance of schedule lines

SFDE_LOC_GUID

—

GUID of executing service fill location

SFDE_LOC_ID

0SPL_SFELOC

Executing service fill location

In the case of a one-to-many supersession, where products from different locations can be delivered, the system uses either the location of the one-to-many item or the executing location of the customer-requested item. This depends on your settings in Customizing (Make Global Settings for Service Fill Monitor).

SL_USED

—

Service loss analysis for schedule line

If the service loss analysis has processes a schedule line, it sets this indicator for the schedule line.

SL_USED_DATI

—

Shows the point in time, at which the service loss analysis processed this schedule line.

CHANGE_AFTER_SL

—

Change after service loss analysis

If a change to the schedule line of the sales order occurs after the system has performed the service loss analysis, it sets this indicator. In this case, it does not change the schedule line. Thus, the sales order data in the source system differs from the data in the service fill monitor in this case.

SO_TOP_ITEM_GUID

0SPL_CRITEM

Internal sales order item ID (GUID)

SO_TOP_ITEM_ID

0CRM_NUMINT

Sales order item

SO_TOP_LINE_ID

0SPL_CRLINE

Schedule line ID

FILL_QTY

0SPL_FILL

Service Fill Quantity

LOSS_QTY

0SPL_LOSS

Service loss quantity

FILL_LINE

0SPL_GIFILL

Line is filled

LOSS_LINE

0SPL_GINFIL

Line is not filled

SFD_VALID

—

Service fill decision is valid

SFD_DATI

—

Time of service fill decision

ACTGI_QTY

0SPL_ACTGIQ

Goods issue quantity of substitute product

EQIV_QTY

0SPL_EQRQTY

Desired quantity

EQIV_ACTGI_QTY

0SPL_ACTGIE

Goods issue quantity of customer-requested product

SO_HEAD_ID

0CRM_OBJ_ID

Sales order ID

SO_ITEM_ID

0SPL_CMITEM

Sales order item

TARGET_DATI

0SPL_TARGDT

Goods issue date/time

TARGET_PROD_GUID

—

Substitute product GUID

TARGET_PROD_ID

0SPL_TPROD

Substitute product

TARGET_QTY

0SPL_TARGTQ

Quantity for GI

TARGET_BASE_UNIT

0SPL_BASUT

Base unit of measure

SO_PNT_ITEM_GUID

—

GUID of higher-level sales order item

SO_PNT_ITEM_ID

0SPL_PNTITM

Higher-level sales order item

SO_PNT_LINE_ID

0SPL_PNTLIN

Higher-level sales order schedule line

ITEM_USAGE_TYPE

0CRM_ITMUSE

Item usage type

RELEVANT4GI

0SPL_GIREL

Goods movements relevance

EXEC_LOC_GUID

—

GUID of executing location

EXEC_LOC_ID

0SPL_EXELOC

Executing location

DELIVERY_STATUS

—

Delivery Status

REJECT_REASON

0SPL_RJCTRS

Rejection reason

CANCEL_REASON

0SPL_REJECT

Reason for Rejection

SUPERSEDED_MATID

—

Internal key for product

SUPERSEDED_MATNR

—

Product

REPTYPE

—

Replacement type

BACKCASTDT

—

Successor product planning date

DENQUANT

—

Preceding quantity factor

NUMQUANT

—

Factor for Successor Quantity

RELVN

—

Relevance for application

TARGET_LAST_DATI

—

Last planned goods issue date/time. That is the latest date/time of all goods issue deadlines (TARGET_DATI) for a customer-requested schedule line.

TARGET_FRST_DATI

—

Last time for order changes

REQ_PROD_GUID

—

GUID of customer-requested product

REQ_PROD_ID

0SPL_REQPRO

Customer-requested product

REQ_DATI

0SPL_CRDSCH

Customer-requested date/time

FACE_LOC_GUID

—

GUID of customer-facing location

FACE_LOC_ID

0SPL_FACLOC

ID of customer-facing location

STOR_LOC_GUID

—

GUID of first stockholding location

STOR_LOC_ID

0SPL_FSTLOC

ID of first stockholding location

REF_DATI

0SPL_REFSCH

Reference time stamp for definition of evaluation period

Depending on your settings in Customizing (Make Global Settings for the Service Fill Monitor), this timestamp is identical to either REQ_DATI or to TARGET_LAST_DATI.

SL_REF_DATI

0SPL_SFLSCH

Reference date/time of the service loss analysis (identical to TARGET_LAST_DATI).

SODB_COLLECTED

—

Service fill data basis calculated

ORDER_CATEGORY

0SPL_ORDCAT

Sales order attribute

SOLD_TO_PARTNER

0CRM_SOLDTO

Customer

ABNORMAL_DEMAND

0CRM_NOTNRM

Abnormal demand

OVERRIDE_LOC_ID

0SPL_OVRLOC

Location preferred by the customer

SHIPTO_PARTNR_ID

0CRM_SHIPTO

Ship-to Party

EQIV_BASE_UNIT

0SPL_BASUE

Base unit of measure

FLAG_REC_DELE

—

Deletion Indicator

DATI_REC_CHNG

—

Changed On

FFRD_LOSS_LINE

—

Schedule line is not filled and is marked as Default or Redirected. The system uses this indicator to mark all sales order schedule lines that it uses for the service loss analysis.

REQ_LINE

0SPL_FLGREQ

Requested quantity or requested date/time

EXCLUSION_CAT

0SPL_EXCLU

Exclusion reason

UPDMODE

0RECORDMODE

Deletion Indicator

SAFTY_QTY

0SPL_CSSQTY

Consumed safety stock quantity

GIC_TIMES

0SPL_NOGISS

Number of goods issue postings from safety stock

SALES_LOCK

—

Reason code for sales lock

TPDS_FLAG

—

TPOP indicator

ORDER_VALID

—

Sales order accuracy

LC_DELAY_PERIOD

—

Delay period with last change

DELTA_DAYS

—

Difference between planned and actual goods issue date/time

SF_DELAY_PERIOD

—

First delay period with supply chain service fill

NUM_REP_BUOM

0SPL_NUMRBU

Numerator for conversion into base unit of measure (BME) for evaluation

DEN_REP_BUOM

0SPL_DENRBU

Denominator for conversion into BME for evaluation

NUM_REP_SUOM

0SPL_NUMRSU

Numerator for conversion into sales unit of measure (SME) for evaluation

DEN_REP_SUOM

0SPL_DENRSU

Denominator for conversion into SME for evaluation

REP_BASE_UOM

0SPL_RBUOM

BME for evaluation in BI system

REP_SALE_UOM

0SPL_RSUOM

SME for evaluation in BI system

ATPCAT

0SPL_ATPCAT

ATP category of the schedule line