C_AdvncdSchedgOperationDetsTP

DDL: C_ADVNCDSCHEDGOPERATIONDETSTP Type: view_entity CONSUMPTION
75 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Operation Details for ASB App

C_AdvncdSchedgOperationDetsTP is a Consumption CDS View that provides data about "Operation Details for ASB App" in SAP S/4HANA. It reads from 1 data source (R_AdvncdSchedgOperationDetsTP) and exposes 75 fields with key fields AdvncdPlngOrderID, SimulationSessionUUID, AdvncdPlngOrderOperationNumber, AdvncdPlngResourceName, AdvncdPlngTimeProfileID. 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_AdvncdSchedgOperationDetsTP R_AdvncdSchedgOperationDetsTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_AdvncdSchedgOpAlertOverlay _AlertOverlay $projection.AdvncdPlngOperationUITaskID = _AlertOverlay.AdvncdPlngOperationUITaskID

Annotations (9)

NameValueLevelField
EndUserText.label Operation Details for 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_OPERATION_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 (75)

KeyFieldSource TableSource FieldDescription
KEY AdvncdPlngOrderID AdvncdPlngOrderID
KEY SimulationSessionUUID SimulationSessionUUID Sim. Session
KEY AdvncdPlngOrderOperationNumber AdvncdPlngOrderOperationNumber
KEY AdvncdPlngResourceName AdvncdPlngResourceName Resource
KEY AdvncdPlngTimeProfileID AdvncdPlngTimeProfileID Time Profile
KEY PlanningVersionExternal PlanningVersionExternal
KEY AdvncdPlngOrdSubOpNmbr AdvncdPlngOrdSubOpNmbr Sub Operation Number
AdvncdPlngPrsnlznOrdOpNmbr AdvncdPlngPrsnlznOrdOpNmbr
AdvncdPlngExternalSimlnUUID AdvncdPlngExternalSimlnUUID
AdvncdPlngResourceID AdvncdPlngResourceID Internal Resrce
AdvncdPlngOperationID AdvncdPlngOperationID
AdvncdPlngOpStartDateTime AdvncdPlngOpStartDateTime
AdvncdPlngOpStatus AdvncdPlngOpStatus
AdvncdPlngOpEndDateTime AdvncdPlngOpEndDateTime
AdvncdPlngOpSetupGroup AdvncdPlngOpSetupGroup
AdvncdPlngOpSetupKey AdvncdPlngOpSetupKey
AdvancedPlanningOperationTxt AdvancedPlanningOperationTxt Short Description
AdvncdPlngOrderInternalNumber AdvncdPlngOrderInternalNumber
AdvncdPlngPrsnlznOrderNumber AdvncdPlngPrsnlznOrderNumber
AdvncdPlngOrderStartDateTime AdvncdPlngOrderStartDateTime
AdvncdPlngOrderEndDateTime AdvncdPlngOrderEndDateTime
AdvncdPlngOrderPriority AdvncdPlngOrderPriority
AdvancedPlanningProductName AdvancedPlanningProductName
AdvancedPlanningProductTxt AdvancedPlanningProductTxt
AdvncdPlngPrsnlznProductName AdvncdPlngPrsnlznProductName Product
Location Location Text
AdvncdPlngPrsnlznLocation AdvncdPlngPrsnlznLocation Plant
AdvncdPlngDisplayHorizonDte AdvncdPlngDisplayHorizonDte
AdvncdPlngDisplayHorizonDteTme AdvncdPlngDisplayHorizonDteTme
AdvncdPlngPlanningHorizonDte AdvncdPlngPlanningHorizonDte
AdvncdPlngOrderQuantityUnit AdvncdPlngOrderQuantityUnit
AdvncdPlngOrderQuantity AdvncdPlngOrderQuantity
AdvncdPlngPggngDesc AdvncdPlngPggngDesc
AdvncdPlngOrderTypeDesc AdvncdPlngOrderTypeDesc
AdvncdPlngRqmtDateTime AdvncdPlngRqmtDateTime
AdvncdPlngOrderRcptsQtyUnit AdvncdPlngOrderRcptsQtyUnit
AdvncdPlngOrderRcptsQuantity AdvncdPlngOrderRcptsQuantity
AdvncdPlngOperationUITaskID AdvncdPlngOperationUITaskID
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
AdvncdPlngOperationGradientID AdvncdPlngOperationGradientID
AdvncdPlngRsceChildEntityFltr AdvncdPlngRsceChildEntityFltr
AdvncdPlngOpHasRelationships AdvncdPlngOpHasRelationships
AdvncdPlngOrderObjectType AdvncdPlngOrderObjectType
AdvncdPlngNrOfObjectsInTotal AdvncdPlngNrOfObjectsInTotal
AdvncdPlngNrOfObjectsLoaded AdvncdPlngNrOfObjectsLoaded
AdvancedPlanningNumberOfNotes AdvancedPlanningNumberOfNotes Notes (Operation) Counter
AdvncdPlngIsDragPossible AdvncdPlngIsDragPossible
AdvncdPlngShapeTitleText AdvncdPlngShapeTitleText
AdvncdPlngIsSOSChangePossible AdvncdPlngIsSOSChangePossible
AdvncdPlngIsOrdQtyChangeable AdvncdPlngIsOrdQtyChangeable
AdvncdPlngIsCrteOrdTmplPosbl AdvncdPlngIsCrteOrdTmplPosbl
AdvncdPlngOrderType AdvncdPlngOrderType
AdvncdPlngShrdMemoryModeFilter AdvncdPlngShrdMemoryModeFilter
AdvncdPlngOpProduceDurnPercent AdvncdPlngOpProduceDurnPercent
AdvncdPlngOpSetupDurnPercent AdvncdPlngOpSetupDurnPercent
AdvncdPlngOpGRDurnPercent AdvncdPlngOpGRDurnPercent
AdvncdPlngOpTearDurnPercent AdvncdPlngOpTearDurnPercent
LocationTimeZone LocationTimeZone
AdvncdPlngGraphicalObjectID AdvncdPlngGraphicalObjectID
AdvncdPlngConfignProfileID AdvncdPlngConfignProfileID
AdvncdPlngConfignPrflCustID AdvncdPlngConfignPrflCustID
_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_AdvncdSchedgOperationDetsTP.
-- 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_AdvncdSchedgOperationDetsTP AS
SELECT
  AdvncdPlngOrderID,
  SimulationSessionUUID,
  AdvncdPlngOrderOperationNumber,
  AdvncdPlngResourceName,
  AdvncdPlngTimeProfileID,
  PlanningVersionExternal,
  AdvncdPlngOrdSubOpNmbr,
  AdvncdPlngPrsnlznOrdOpNmbr,
  AdvncdPlngExternalSimlnUUID,
  AdvncdPlngResourceID,
  AdvncdPlngOperationID,
  AdvncdPlngOpStartDateTime,
  AdvncdPlngOpStatus,
  AdvncdPlngOpEndDateTime,
  AdvncdPlngOpSetupGroup,
  AdvncdPlngOpSetupKey,
  AdvancedPlanningOperationTxt,
  AdvncdPlngOrderInternalNumber,
  AdvncdPlngPrsnlznOrderNumber,
  AdvncdPlngOrderStartDateTime,
  AdvncdPlngOrderEndDateTime,
  AdvncdPlngOrderPriority,
  AdvancedPlanningProductName,
  AdvancedPlanningProductTxt,
  AdvncdPlngPrsnlznProductName,
  Location,
  AdvncdPlngPrsnlznLocation,
  AdvncdPlngDisplayHorizonDte,
  AdvncdPlngDisplayHorizonDteTme,
  AdvncdPlngPlanningHorizonDte,
  AdvncdPlngOrderQuantityUnit,
  AdvncdPlngOrderQuantity,
  AdvncdPlngPggngDesc,
  AdvncdPlngOrderTypeDesc,
  AdvncdPlngRqmtDateTime,
  AdvncdPlngOrderRcptsQtyUnit,
  AdvncdPlngOrderRcptsQuantity,
  AdvncdPlngOperationUITaskID,
  ResourceIsBottleNeck,
  AdvncdPlngRsceIsSeldFltr,
  AdvncdPlngProdIsSeldFltr,
  AdvncdPlngOrdIsSeldFltr,
  RsceIsRelevantForFinitePlng,
  ResourceSortText,
  OperationStatusInternalID,
  ProductPlanningGroup,
  ResourcePlanner,
  ResourceGroup,
  ResourceCategory,
  SimulationSessionName,
  AdvncdPlngRsceHasStorageCharcs,
  ResourceFinitenessLevelValue,
  AdvncdPlngOperationGradientID,
  AdvncdPlngRsceChildEntityFltr,
  AdvncdPlngOpHasRelationships,
  AdvncdPlngOrderObjectType,
  AdvncdPlngNrOfObjectsInTotal,
  AdvncdPlngNrOfObjectsLoaded,
  AdvancedPlanningNumberOfNotes,
  AdvncdPlngIsDragPossible,
  AdvncdPlngShapeTitleText,
  AdvncdPlngIsSOSChangePossible,
  AdvncdPlngIsOrdQtyChangeable,
  AdvncdPlngIsCrteOrdTmplPosbl,
  AdvncdPlngOrderType,
  AdvncdPlngShrdMemoryModeFilter,
  AdvncdPlngOpProduceDurnPercent,
  AdvncdPlngOpSetupDurnPercent,
  AdvncdPlngOpGRDurnPercent,
  AdvncdPlngOpTearDurnPercent,
  LocationTimeZone,
  AdvncdPlngGraphicalObjectID,
  AdvncdPlngConfignProfileID,
  AdvncdPlngConfignPrflCustID
FROM R_AdvncdSchedgOperationDetsTP
LEFT OUTER JOIN C_AdvncdSchedgOpAlertOverlay AS _AlertOverlay ON AdvncdPlngOperationUITaskID = _AlertOverlay.AdvncdPlngOperationUITaskID  -- association [0..*]
;

Learn More