C_AdvncdSchedgSuccssrPrdcssr

DDL: C_ADVNCDSCHEDGSUCCSSRPRDCSSR SQL: CASSUCCSSRPRD Type: view CONSUMPTION

Advanced Scheduling Successor Predecess

C_AdvncdSchedgSuccssrPrdcssr is a Consumption CDS View that provides data about "Advanced Scheduling Successor Predecess" in SAP S/4HANA. It reads from 1 data source (I_AdvncdPlngSuccssrPrdcssrOrd) and exposes 63 fields with key fields AdvncdPlngOrderID, SimulationSessionUUID, AdvncdPlngOrderOperationNumber, AdvncdPlngResourceName, AdvncdPlngTimeProfileID. 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
I_AdvncdPlngSuccssrPrdcssrOrd I_AdvncdPlngSuccssrPrdcssrOrd from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CASSUCCSSRPRD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Advanced Scheduling Successor Predecess view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.query.implementedBy ABAP:CL_ASB_MISC_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 (63)

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
AdvncdPlngExternalSimlnUUID AdvncdPlngExternalSimlnUUID
PlanningVersionUUID PlanningVersionUUID Plan Version
AdvncdPlngResourceID AdvncdPlngResourceID Internal Resrce
AdvncdPlngOperationID AdvncdPlngOperationID
AdvncdPlngOpStartDateTime AdvncdPlngOpStartDateTime
AdvncdPlngOrderIsDallcd AdvncdPlngOrderIsDallcd
AdvncdPlngOrderIsFixed AdvncdPlngOrderIsFixed
AdvncdPlngOrderIsConfirmed AdvncdPlngOrderIsConfirmed
AdvncdPlngOrderIsPrtlyConfirm AdvncdPlngOrderIsPrtlyConfirm
AdvncdPlngOrderIsReleased AdvncdPlngOrderIsReleased
AdvncdPlngOrderIsStarted AdvncdPlngOrderIsStarted
AdvncdPlngOrderIsInterrupted AdvncdPlngOrderIsInterrupted
AdvncdPlngOrderIsSetupDactvtd AdvncdPlngOrderIsSetupDactvtd
AdvncdPlngOrdIsSeqDpndcyActive AdvncdPlngOrdIsSeqDpndcyActive
AdvncdPlngOpEndDateTime AdvncdPlngOpEndDateTime
AdvncdPlngOpSetupGroup AdvncdPlngOpSetupGroup
AdvncdPlngOpSetupKey AdvncdPlngOpSetupKey
AdvancedPlanningOperationTxt AdvancedPlanningOperationTxt
AdvncdPlngOrderInternalNumber AdvncdPlngOrderInternalNumber
AdvncdPlngOrderStartDateTime AdvncdPlngOrderStartDateTime
AdvncdPlngOrderEndDateTime AdvncdPlngOrderEndDateTime
AdvncdPlngOrderPriority AdvncdPlngOrderPriority
AdvancedPlanningProductName AdvancedPlanningProductName
AdvancedPlanningProductTxt AdvancedPlanningProductTxt
Location Location Text
AdvncdPlngDisplayHorizonDte AdvncdPlngDisplayHorizonDte
AdvncdPlngPlanningHorizonDte AdvncdPlngPlanningHorizonDte
AdvncdPlngOrderQuantityUnit AdvncdPlngOrderQuantityUnit
AdvncdPlngOrderQuantity AdvncdPlngOrderQuantity
AdvncdPlngSetpActStartDateTime AdvncdPlngSetpActStartDateTime
AdvncdPlngSetpActEndDateTime AdvncdPlngSetpActEndDateTime
AdvncdPlngTearDwnActStrtDteTme AdvncdPlngTearDwnActStrtDteTme
AdvncdPlngTearDwnActEndDteTme AdvncdPlngTearDwnActEndDteTme
AdvncdPlngProcActEndDateTime AdvncdPlngProcActEndDateTime
AdvncdPlngProcActStartDateTime AdvncdPlngProcActStartDateTime
AdvncdPlngPggngDesc AdvncdPlngPggngDesc
AdvncdPlngOrderTypeDesc AdvncdPlngOrderTypeDesc
AdvncdPlngRqmtDateTime AdvncdPlngRqmtDateTime
AdvncdPlngOrderRcptsQtyUnit AdvncdPlngOrderRcptsQtyUnit
AdvncdPlngOrderRcptsQuantity AdvncdPlngOrderRcptsQuantity
AdvncdPlngOperationUITaskID AdvncdPlngOperationUITaskID
ResourceIsBottleNeck ResourceIsBottleNeck
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
AdvncdPlngOrderTypeObject AdvncdPlngOrderTypeObject
AdvncdPlngShapeSelectTypeTxt AdvncdPlngShapeSelectTypeTxt

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_AdvncdSchedgSuccssrPrdcssr.
-- 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.
-- SQL view name: CASSUCCSSRPRD

CREATE VIEW C_AdvncdSchedgSuccssrPrdcssr AS
SELECT
  AdvncdPlngOrderID,
  SimulationSessionUUID,
  AdvncdPlngOrderOperationNumber,
  AdvncdPlngResourceName,
  AdvncdPlngTimeProfileID,
  PlanningVersionExternal,
  AdvncdPlngExternalSimlnUUID,
  PlanningVersionUUID,
  AdvncdPlngResourceID,
  AdvncdPlngOperationID,
  AdvncdPlngOpStartDateTime,
  AdvncdPlngOrderIsDallcd,
  AdvncdPlngOrderIsFixed,
  AdvncdPlngOrderIsConfirmed,
  AdvncdPlngOrderIsPrtlyConfirm,
  AdvncdPlngOrderIsReleased,
  AdvncdPlngOrderIsStarted,
  AdvncdPlngOrderIsInterrupted,
  AdvncdPlngOrderIsSetupDactvtd,
  AdvncdPlngOrdIsSeqDpndcyActive,
  AdvncdPlngOpEndDateTime,
  AdvncdPlngOpSetupGroup,
  AdvncdPlngOpSetupKey,
  AdvancedPlanningOperationTxt,
  AdvncdPlngOrderInternalNumber,
  AdvncdPlngOrderStartDateTime,
  AdvncdPlngOrderEndDateTime,
  AdvncdPlngOrderPriority,
  AdvancedPlanningProductName,
  AdvancedPlanningProductTxt,
  Location,
  AdvncdPlngDisplayHorizonDte,
  AdvncdPlngPlanningHorizonDte,
  AdvncdPlngOrderQuantityUnit,
  AdvncdPlngOrderQuantity,
  AdvncdPlngSetpActStartDateTime,
  AdvncdPlngSetpActEndDateTime,
  AdvncdPlngTearDwnActStrtDteTme,
  AdvncdPlngTearDwnActEndDteTme,
  AdvncdPlngProcActEndDateTime,
  AdvncdPlngProcActStartDateTime,
  AdvncdPlngPggngDesc,
  AdvncdPlngOrderTypeDesc,
  AdvncdPlngRqmtDateTime,
  AdvncdPlngOrderRcptsQtyUnit,
  AdvncdPlngOrderRcptsQuantity,
  AdvncdPlngOperationUITaskID,
  ResourceIsBottleNeck,
  RsceIsRelevantForFinitePlng,
  ResourceSortText,
  OperationStatusInternalID,
  ProductPlanningGroup,
  ResourcePlanner,
  ResourceGroup,
  ResourceCategory,
  SimulationSessionName,
  AdvncdPlngRsceHasStorageCharcs,
  ResourceFinitenessLevelValue,
  AdvncdPlngOperationGradientID,
  AdvncdPlngRsceChildEntityFltr,
  AdvncdPlngOpHasRelationships,
  AdvncdPlngOrderTypeObject,
  AdvncdPlngShapeSelectTypeTxt
FROM I_AdvncdPlngSuccssrPrdcssrOrd
;