C_AdvncdSchedgOrderDetsTP

DDL: C_ADVNCDSCHEDGORDERDETSTP Type: view_entity CONSUMPTION
82 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Order details of ASB App

C_AdvncdSchedgOrderDetsTP is a Consumption CDS View that provides data about "Order details of ASB App" in SAP S/4HANA. It reads from 1 data source (R_AdvncdSchedgOrderDetsTP) and exposes 82 fields with key fields SimulationSessionUUID, PlanningVersionExternal, AdvncdPlngOrderID, AdvncdPlngOrderInternalNumber, AdvancedPlanningProductName. It has 1 association to related views. It is exposed through 1 OData service (UI_SCM_ADVNCD_SCHEDG_BOARD). It is used in 1 Fiori application: Advanced Scheduling Board.

Data Sources (1)

SourceAliasJoin Type
R_AdvncdSchedgOrderDetsTP R_AdvncdSchedgOrderDetsTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_AdvncdSchedgOrdAlertOverlay _AlertOverlay $projection.AdvncdPlngOrderID = _AlertOverlay.AdvncdPlngOrderID

Annotations (9)

NameValueLevelField
EndUserText.label Order details of ASB App view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #CONSUMPTION view
ObjectModel.query.implementedBy ABAP:CL_ASB_ORDER_QUERY view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SCM_ADVNCD_SCHEDG_BOARD UI_SCM_ADVNCD_SCHEDG_BOARD V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5460 Advanced Scheduling Board Transactional An application to monitor and schedule the capacity of production resources.

Advanced Scheduling Board

Business Role: Production Planner

The DS Optimizer application has been integrated with the Advanced Scheduling Board application. The DS Optimizer can be started interactively within the Advanced Scheduling Board application to support the planner in creation of a production plan considering constraints such as limited capacity or requirement due dates.

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY SimulationSessionUUID SimulationSessionUUID Sim. Session
KEY PlanningVersionExternal PlanningVersionExternal
KEY AdvncdPlngOrderID AdvncdPlngOrderID
KEY AdvncdPlngOrderInternalNumber AdvncdPlngOrderInternalNumber
KEY AdvancedPlanningProductName AdvancedPlanningProductName
KEY Location Location Text
KEY AdvncdPlngTimeProfileID AdvncdPlngTimeProfileID Time Profile
AdvncdPlngExternalSimlnUUID AdvncdPlngExternalSimlnUUID
AdvncdPlngPrsnlznProductName AdvncdPlngPrsnlznProductName Product
AdvncdPlngProductID AdvncdPlngProductID
AdvncdPlngPrsnlznOrderNumber AdvncdPlngPrsnlznOrderNumber
AdvncdPlngPrsnlznLocation AdvncdPlngPrsnlznLocation Plant
LocationUUID LocationUUID UUID
AdvncdPlngApplPrflID AdvncdPlngApplPrflID
AdvncdPlngOrderStartDateTime AdvncdPlngOrderStartDateTime Order Start Date/ Time
AdvncdPlngOrderEndDateTime AdvncdPlngOrderEndDateTime Order End Date/ Time
AdvncdPlngResourceName AdvncdPlngResourceName Resource
AdvncdPlngOrderQuantityUnit AdvncdPlngOrderQuantityUnit Base Unit of Measure
AdvncdPlngOrderQuantity AdvncdPlngOrderQuantity Receipt Quantity/ Requirements Quantity
AdvncdPlngResourceID AdvncdPlngResourceID Internal Resrce
AdvncdPlngOrderIsDallcd AdvncdPlngOrderIsDallcd
AdvncdPlngOrderIsFixed AdvncdPlngOrderIsFixed
AdvncdPlngOrderIsPrtlyConfirm AdvncdPlngOrderIsPrtlyConfirm
AdvncdPlngOrderIsConfirmed AdvncdPlngOrderIsConfirmed
AdvncdPlngOrderIsReleased AdvncdPlngOrderIsReleased
AdvncdPlngOrderType AdvncdPlngOrderType Order Category
AdvncdPlngOpStatus AdvncdPlngOpStatus
AdvncdPlngOrderATPCategory AdvncdPlngOrderATPCategory
AdvncdPlngOrderObjectType AdvncdPlngOrderObjectType
AdvancedPlanningProductTxt AdvancedPlanningProductTxt
AdvncdPlngDisplayHorizonDte AdvncdPlngDisplayHorizonDte
AdvncdPlngDisplayHorizonDteTme AdvncdPlngDisplayHorizonDteTme
AdvncdPlngPlanningHorizonDte AdvncdPlngPlanningHorizonDte
ResourceIsBottleNeck ResourceIsBottleNeck
AdvncdPlngRsceIsSeldFltr AdvncdPlngRsceIsSeldFltr
AdvncdPlngProdIsSeldFltr AdvncdPlngProdIsSeldFltr
AdvncdPlngOrdIsSeldFltr AdvncdPlngOrdIsSeldFltr
RsceIsRelevantForFinitePlng RsceIsRelevantForFinitePlng
ResourceSortText ResourceSortText
OperationStatusInternalID OperationStatusInternalID
ProductPlanningGroup ProductPlanningGroup Planning Group
ResourcePlanner ResourcePlanner
ResourceGroup ResourceGroup
ResourceCategory ResourceCategory
SimulationSessionName SimulationSessionName
AdvncdPlngRsceHasStorageCharcs AdvncdPlngRsceHasStorageCharcs
ResourceFinitenessLevelValue ResourceFinitenessLevelValue
AdvncdPlngOrderOperationNumber AdvncdPlngOrderOperationNumber
AdvncdPlngNrOfObjectsInTotal AdvncdPlngNrOfObjectsInTotal
AdvncdPlngNrOfObjectsLoaded AdvncdPlngNrOfObjectsLoaded
AdvncdPlngUIHierDrillState AdvncdPlngUIHierDrillState
AdvncdPlngOrdChildEntyFltr AdvncdPlngOrdChildEntyFltr
AdvncdPlngOrdHasRelationships AdvncdPlngOrdHasRelationships
AdvncdPlngOrderTitleText AdvncdPlngOrderTitleText
AdvncdPlngProdOrderTitleText AdvncdPlngProdOrderTitleText
AdvncdPlngIsDragPossible AdvncdPlngIsDragPossible
AdvncdPlngIsSOSChangePossible AdvncdPlngIsSOSChangePossible
AdvncdPlngIsOrdQtyChangeable AdvncdPlngIsOrdQtyChangeable
AdvncdPlngIsCrteOrdTmplPosbl AdvncdPlngIsCrteOrdTmplPosbl
AdvncdPlngParentOrderID AdvncdPlngParentOrderID
AdvncdPlngShrdMemoryModeFilter AdvncdPlngShrdMemoryModeFilter
LocationTimeZone LocationTimeZone
AdvncdPlngAccountAssgmtObj AdvncdPlngAccountAssgmtObj Account Assignment Object
AdvncdPlngProcurementType AdvncdPlngProcurementType
AdvncdPlngOrderPriority AdvncdPlngOrderPriority
AdvncdPlngProdGrossWeight AdvncdPlngProdGrossWeight Gross Weight
AdvncdPlngProdWeightUoM AdvncdPlngProdWeightUoM
AdvncdPlngProductVolume AdvncdPlngProductVolume Volume
AdvncdPlngProductVolumeUoM AdvncdPlngProductVolumeUoM
AdvncdPlngProdPurchasingGroup AdvncdPlngProdPurchasingGroup
AdvancedPlanningMaterialGroup AdvancedPlanningMaterialGroup
AdvncdPlngLowLevelCode AdvncdPlngLowLevelCode
AdvncdPlngATPGroup AdvncdPlngATPGroup
AdvancedPlanningNumberOfNotes AdvancedPlanningNumberOfNotes Notes (Order) Counter
AdvncdPlngOrderIsCombined AdvncdPlngOrderIsCombined
AdvncdPlngOrderIsConvertible AdvncdPlngOrderIsConvertible
AdvncdPlngOrdIsPrtlyDlvrd AdvncdPlngOrdIsPrtlyDlvrd
AdvncdPlngOrderIsFinalDelivery AdvncdPlngOrderIsFinalDelivery
AdvncdPlngOrderIsOutputFirmed AdvncdPlngOrderIsOutputFirmed
AdvncdPlngOrderIsInputFirmed AdvncdPlngOrderIsInputFirmed
AdvncdPlngOrderIsInterrupted AdvncdPlngOrderIsInterrupted Interrupted
_AlertOverlay _AlertOverlay

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_AdvncdSchedgOrderDetsTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_AdvncdSchedgOrderDetsTP AS
SELECT
  SimulationSessionUUID,
  PlanningVersionExternal,
  AdvncdPlngOrderID,
  AdvncdPlngOrderInternalNumber,
  AdvancedPlanningProductName,
  Location,
  AdvncdPlngTimeProfileID,
  AdvncdPlngExternalSimlnUUID,
  AdvncdPlngPrsnlznProductName,
  AdvncdPlngProductID,
  AdvncdPlngPrsnlznOrderNumber,
  AdvncdPlngPrsnlznLocation,
  LocationUUID,
  AdvncdPlngApplPrflID,
  AdvncdPlngOrderStartDateTime,
  AdvncdPlngOrderEndDateTime,
  AdvncdPlngResourceName,
  AdvncdPlngOrderQuantityUnit,
  AdvncdPlngOrderQuantity,
  AdvncdPlngResourceID,
  AdvncdPlngOrderIsDallcd,
  AdvncdPlngOrderIsFixed,
  AdvncdPlngOrderIsPrtlyConfirm,
  AdvncdPlngOrderIsConfirmed,
  AdvncdPlngOrderIsReleased,
  AdvncdPlngOrderType,
  AdvncdPlngOpStatus,
  AdvncdPlngOrderATPCategory,
  AdvncdPlngOrderObjectType,
  AdvancedPlanningProductTxt,
  AdvncdPlngDisplayHorizonDte,
  AdvncdPlngDisplayHorizonDteTme,
  AdvncdPlngPlanningHorizonDte,
  ResourceIsBottleNeck,
  AdvncdPlngRsceIsSeldFltr,
  AdvncdPlngProdIsSeldFltr,
  AdvncdPlngOrdIsSeldFltr,
  RsceIsRelevantForFinitePlng,
  ResourceSortText,
  OperationStatusInternalID,
  ProductPlanningGroup,
  ResourcePlanner,
  ResourceGroup,
  ResourceCategory,
  SimulationSessionName,
  AdvncdPlngRsceHasStorageCharcs,
  ResourceFinitenessLevelValue,
  AdvncdPlngOrderOperationNumber,
  AdvncdPlngNrOfObjectsInTotal,
  AdvncdPlngNrOfObjectsLoaded,
  AdvncdPlngUIHierDrillState,
  AdvncdPlngOrdChildEntyFltr,
  AdvncdPlngOrdHasRelationships,
  AdvncdPlngOrderTitleText,
  AdvncdPlngProdOrderTitleText,
  AdvncdPlngIsDragPossible,
  AdvncdPlngIsSOSChangePossible,
  AdvncdPlngIsOrdQtyChangeable,
  AdvncdPlngIsCrteOrdTmplPosbl,
  AdvncdPlngParentOrderID,
  AdvncdPlngShrdMemoryModeFilter,
  LocationTimeZone,
  AdvncdPlngAccountAssgmtObj,
  AdvncdPlngProcurementType,
  AdvncdPlngOrderPriority,
  AdvncdPlngProdGrossWeight,
  AdvncdPlngProdWeightUoM,
  AdvncdPlngProductVolume,
  AdvncdPlngProductVolumeUoM,
  AdvncdPlngProdPurchasingGroup,
  AdvancedPlanningMaterialGroup,
  AdvncdPlngLowLevelCode,
  AdvncdPlngATPGroup,
  AdvancedPlanningNumberOfNotes,
  AdvncdPlngOrderIsCombined,
  AdvncdPlngOrderIsConvertible,
  AdvncdPlngOrdIsPrtlyDlvrd,
  AdvncdPlngOrderIsFinalDelivery,
  AdvncdPlngOrderIsOutputFirmed,
  AdvncdPlngOrderIsInputFirmed,
  AdvncdPlngOrderIsInterrupted
FROM R_AdvncdSchedgOrderDetsTP
LEFT OUTER JOIN C_AdvncdSchedgOrdAlertOverlay AS _AlertOverlay ON AdvncdPlngOrderID = _AlertOverlay.AdvncdPlngOrderID  -- association [0..*]
;

Learn More