C_APSOpTimeBufByWrkAreaDEX

DDL: C_APSOPTIMEBUFBYWRKAREADEX Type: view_entity CONSUMPTION
49 Fields 1 Data Sources 10 Associations

DEX for Op Time Buffer by Work Area

C_APSOpTimeBufByWrkAreaDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

C_APSOpTimeBufByWrkAreaDEX is a Consumption CDS View that provides data about "DEX for Op Time Buffer by Work Area" in SAP S/4HANA. It reads from 1 data source (P_APSOpTimeBufferByWrkArea) and exposes 49 fields with key fields AdvncdPlngPlanningVersion, SimulationSessionUUID, PlanningModel, AdvncdPlngResourceID, AdvncdPlngOrderID. It has 10 associations to related views.

SAP Help Documentation

CategoryDEX for MLTB by Work Area
StatusTime buffer calculation status
Purpose
This CDS view is a data extraction view that provides the MultiLevel Time Buffer (MLTB) details available for operations, such as time buffer available which can be calculated keeping a reference of the primary demand or immediate successor or predecessor operation and the latest or earliest time stamp where such an object could be rescheduled to, along with the calculation status. The MLTB details are calculated based on the MLTB profile and Customizing ID. The selected operation depends on the Advanced Planning products and resources in the Work Area/Customizing ID for a given Planning Version and Start Date and End Date passed to the CDS view. This CDS view can serve as a data source for SAP Business Information Warehouse (BW) or other SAP data extraction processes.

Prerequisites
Authorizations Ensure that the following authorization objects are assigned to your user: C_APO_VERS (APO: Planning Version, Planning Model) C_APO_MOD (APO: Planning Model) C_APO_RELO (APO: Advanced Planning Location ID, Advanced Planning Resource Name) C_APO_LOC (APO: Advanced Planning Location ID) C_APO_PROD (APO: Advanced Planning Product Name, Advanced Planning Location ID) C_APO_PPL (APO: Resource Planner) C_APO_PPL (APO: Production Planner)

Structure
Parameters P_PlanningVersionExternal : This parameter is used to specify the Planning Version to be used for evaluating the capacity details. P_AdvancedPlanningWorkArea : This parameter is used to specify the Work Area. The resources, products, and orders defined in the work area are used for evaluating the capacity details. P_PPDSWorkAreaCstmzgID : This parameter is used to specify the Customizing ID. If you are working with user-specific profiles, you must enter the Customizing ID of the profile. If you are working with general profiles, you must pass a blank space. P_StartDate : This parameter is used to specify the Start Date for evaluating the capacity details (the Start Date is included in the evaluation). P_EndDate : This parameter is used to specify the End Date for evaluating the capacity details (the End Date is included in the evaluation). P_PPDSTimeBufferProfile : This parameter is used to specify the MultiLevel Time Buffer Profile. P_PPDSTimeBufPrflCstmzgID : This parameter is used to specify the MultiLevel Time Buffer Customizing ID (User-Specific Identification). Important Fields Important fields in this view include the following: Field Name Description PPDSTimeBufferDuration Time Buffer duration PPDSTimeBufferIsNegative Marker to identify negative time buffer value PPDSTimeBufferDate Earliest or Latest date, when object can be rescheduled PPDSTimeBufferTime Earliest or Latest time, when object can be rescheduled PPDSTimeBufferCalcStatus Time buffer calculation status

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables)

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentSCM-APO-PPS-ANA
CapabilitiesData Source for Data Extraction
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is a data extraction view that provides the MultiLevel Time Buffer (MLTB) details available for operations, such as time buffer available which can be calculated keeping a reference of the primary demand or immediate successor or predecessor operation and the latest or earliest time stamp where such an object could be rescheduled to, along with the calculation status. The MLTB details are calculated based on the MLTB profile and Customizing ID. The selected operation depends on the Advanced Planning products and resources in the Work Area/Customizing ID for a given Planning Version and Start Date and End Date passed to the CDS view. This CDS view can serve as a data source for SAP Business Information Warehouse (BW) or other SAP data extraction processes. </p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_APSOpTimeBufferByWrkArea P_APSOpTimeBufferByWrkArea from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date

Associations (10)

CardinalityTargetAliasCondition
[0..1] I_APSPlanVersion _PlanningVersion $projection.AdvncdPlngPlanningVersion = _PlanningVersion.AdvncdPlngPlanningVersion
[0..1] I_APSSimulationSession _SimulationSession $projection.SimulationSessionUUID = _SimulationSession.SimulationSessionUUID
[0..1] I_LocationBasic _Location $projection.AdvncdPlngLocationID = _Location.LocationUUID
[0..1] I_APSResource _Resource $projection.AdvncdPlngResourceID = _Resource.AdvncdPlngResourceID and $projection.AdvncdPlngPlanningVersion = _Resource.AdvncdPlngPlanningVersion and $projection.SimulationSessionUUID = _Resource.SimulationSessionUUID
[0..1] I_SCMPlanner _ProdPlanner $projection.ProductionPlanner = _ProdPlanner.Planner
[0..*] I_APSPlanningModelText _PlanningModelText $projection.PlanningModel = _PlanningModelText.PlanningModel
[0..*] I_AdvncdPlngATPCategoryText _ATPCategoryText $projection.AdvncdPlngOrderATPCategory = _ATPCategoryText.AdvncdPlngOrderATPCategory
[0..*] I_ProductText _ProductText $projection.AdvancedPlanningProductName = _ProductText.Product
[0..*] I_ProductGroupText_2 _ProductGroupText $projection.AdvancedPlanningMaterialGroup = _ProductGroupText.ProductGroup
[0..*] I_AdvncdPlngResourceGroupTxt _ResourceGroupText $projection.resourcegroup = _ResourceGroupText.ResourceGroup

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label DEX for Op Time Buffer by Work Area view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY AdvncdPlngPlanningVersion core_tb AdvncdPlngPlanningVersion Name of Planning Version
KEY SimulationSessionUUID core_tb SimulationSessionUUID GUID for Identifying Transactional Simulation Session
KEY PlanningModel core_tb PlanningModel Model Name in Supply Chain Network
KEY AdvncdPlngResourceID core_tb AdvncdPlngResourceID Internal Key (GUID) of a Resource
KEY AdvncdPlngOrderID core_tb AdvncdPlngOrderID Internal Number (UID) for an Order in APO
KEY AdvncdPlngOrderOperationKey core_tb AdvncdPlngOrderOperationKey General Counter of Operation in Order
KEY PPDSTimeBufferType core_tb PPDSTimeBufferType Time Buffer Type
PlanningVersionExternal core_tb PlanningVersionExternal Planning Version
AdvncdPlngOrderInternalNumber core_tb AdvncdPlngOrderInternalNumber Order Number
AdvncdPlngOrderOperationNumber core_tb AdvncdPlngOrderOperationNumber Operation Number
AdvncdPlngOrdSubOpNmbr core_tb AdvncdPlngOrdSubOpNmbr Suboperation Number
AdvncdPlngOrderType core_tb AdvncdPlngOrderType Order Type
AdvncdPlngOrderATPCategory core_tb AdvncdPlngOrderATPCategory ATP Category
AdvncdPlngLocationID core_tb AdvncdPlngLocationID Internal Location Number for Customer, Supplier, or Plant
Location Location
LocationType _Location LocationType Location Type
AdvancedPlanningProductName core_tb AdvancedPlanningProductName Product Number
AdvncdPlngProductID core_tb AdvncdPlngProductID Internal Number (UID) for Product
AdvancedPlanningMaterialGroup core_tb AdvancedPlanningMaterialGroup Material Group
ProductionPlanner core_tb ProductionPlanner Production Planner
ProductionPlannerName _ProdPlanner PlannerName Production Planner Name
AdvncdPlngResourceName _Resource AdvncdPlngResourceName Resource Name
ResourceType _Resource ResourceType Resource Type
ResourceCategory _Resource ResourceCategory Resource Category
ResourceGroup _Resource ResourceGroup Resource Group
ResourcePlanner _Resource ResourcePlanner Production Planner
PlannerName _Resource PlannerName Planner Name
AdvancedPlanningSpclStkType core_tb AdvancedPlanningSpclStkType Special Stock Indicator
AdvncdPlngSpclStkSgmtKeyVal core_tb AdvncdPlngSpclStkSgmtKeyVal Key for Special Stock Segment
AdvncdPlngOpStrtDte core_tb AdvncdPlngOpStrtDte Start Date for the Operation
AdvncdPlngOpStrtTme core_tb AdvncdPlngOpStrtTme Start Time for Operation
AdvncdPlngOpEndDte core_tb AdvncdPlngOpEndDte End Date of the Operation
AdvncdPlngOpEndTme core_tb AdvncdPlngOpEndTme End Time for Operation
PPDSTimeBufferDuration core_tb PPDSTimeBufferDuration MultiLevel Time Buffer Duration
PPDSTimeBufferIsNegative core_tb PPDSTimeBufferIsNegative MultiLevel Time Buffer: Indicator for Negative Time Buffer
PPDSTimeBufferDate core_tb PPDSTimeBufferDate MultiLevel Time Buffer: Earliest/Latest Date
PPDSTimeBufferTime core_tb PPDSTimeBufferTime MultiLevel Time Buffer: Earliest/Latest Time
PPDSTimeBufferCalcStatus core_tb PPDSTimeBufferCalcStatus MultiLevel Time Buffer Calculation Status
PPDSTimeUnit core_tb PPDSTimeUnit Unit of Measurement for Time
_PlanningVersion _PlanningVersion
_SimulationSession _SimulationSession
_Location _Location
_Resource _Resource
_ProdPlanner _ProdPlanner
_ATPCategoryText _ATPCategoryText
_ResourceGroupText _ResourceGroupText
_ProductText _ProductText
_ProductGroupText _ProductGroupText
_PlanningModelText _PlanningModelText

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_APSOpTimeBufByWrkAreaDEX.
-- 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.
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date

CREATE VIEW C_APSOpTimeBufByWrkAreaDEX AS
SELECT
  core_tb.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  core_tb.SimulationSessionUUID AS SimulationSessionUUID,
  core_tb.PlanningModel AS PlanningModel,
  core_tb.AdvncdPlngResourceID AS AdvncdPlngResourceID,
  core_tb.AdvncdPlngOrderID AS AdvncdPlngOrderID,
  core_tb.AdvncdPlngOrderOperationKey AS AdvncdPlngOrderOperationKey,
  core_tb.PPDSTimeBufferType AS PPDSTimeBufferType,
  core_tb.PlanningVersionExternal AS PlanningVersionExternal,
  core_tb.AdvncdPlngOrderInternalNumber AS AdvncdPlngOrderInternalNumber,
  core_tb.AdvncdPlngOrderOperationNumber AS AdvncdPlngOrderOperationNumber,
  core_tb.AdvncdPlngOrdSubOpNmbr AS AdvncdPlngOrdSubOpNmbr,
  core_tb.AdvncdPlngOrderType AS AdvncdPlngOrderType,
  core_tb.AdvncdPlngOrderATPCategory AS AdvncdPlngOrderATPCategory,
  core_tb.AdvncdPlngLocationID AS AdvncdPlngLocationID,
  cast( _Location.Location as /sapapo/locno preserving type ) AS Location,
  _Location.LocationType AS LocationType,
  core_tb.AdvancedPlanningProductName AS AdvancedPlanningProductName,
  core_tb.AdvncdPlngProductID AS AdvncdPlngProductID,
  core_tb.AdvancedPlanningMaterialGroup AS AdvancedPlanningMaterialGroup,
  core_tb.ProductionPlanner AS ProductionPlanner,
  _ProdPlanner.PlannerName AS ProductionPlannerName,
  _Resource.AdvncdPlngResourceName AS AdvncdPlngResourceName,
  _Resource.ResourceType AS ResourceType,
  _Resource.ResourceCategory AS ResourceCategory,
  _Resource.ResourceGroup AS ResourceGroup,
  _Resource.ResourcePlanner AS ResourcePlanner,
  _Resource.PlannerName AS PlannerName,
  core_tb.AdvancedPlanningSpclStkType AS AdvancedPlanningSpclStkType,
  core_tb.AdvncdPlngSpclStkSgmtKeyVal AS AdvncdPlngSpclStkSgmtKeyVal,
  core_tb.AdvncdPlngOpStrtDte AS AdvncdPlngOpStrtDte,
  core_tb.AdvncdPlngOpStrtTme AS AdvncdPlngOpStrtTme,
  core_tb.AdvncdPlngOpEndDte AS AdvncdPlngOpEndDte,
  core_tb.AdvncdPlngOpEndTme AS AdvncdPlngOpEndTme,
  core_tb.PPDSTimeBufferDuration AS PPDSTimeBufferDuration,
  core_tb.PPDSTimeBufferIsNegative AS PPDSTimeBufferIsNegative,
  core_tb.PPDSTimeBufferDate AS PPDSTimeBufferDate,
  core_tb.PPDSTimeBufferTime AS PPDSTimeBufferTime,
  core_tb.PPDSTimeBufferCalcStatus AS PPDSTimeBufferCalcStatus,
  core_tb.PPDSTimeUnit AS PPDSTimeUnit
FROM P_APSOpTimeBufferByWrkArea
LEFT OUTER JOIN I_APSPlanVersion AS _PlanningVersion ON AdvncdPlngPlanningVersion = _PlanningVersion.AdvncdPlngPlanningVersion  -- association [0..1]
LEFT OUTER JOIN I_APSSimulationSession AS _SimulationSession ON SimulationSessionUUID = _SimulationSession.SimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _Location ON AdvncdPlngLocationID = _Location.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_APSResource AS _Resource ON AdvncdPlngResourceID = _Resource.AdvncdPlngResourceID AND AdvncdPlngPlanningVersion = _Resource.AdvncdPlngPlanningVersion AND SimulationSessionUUID = _Resource.SimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_SCMPlanner AS _ProdPlanner ON ProductionPlanner = _ProdPlanner.Planner  -- association [0..1]
LEFT OUTER JOIN I_APSPlanningModelText AS _PlanningModelText ON PlanningModel = _PlanningModelText.PlanningModel  -- association [0..*]
LEFT OUTER JOIN I_AdvncdPlngATPCategoryText AS _ATPCategoryText ON AdvncdPlngOrderATPCategory = _ATPCategoryText.AdvncdPlngOrderATPCategory  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON AdvancedPlanningProductName = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON AdvancedPlanningMaterialGroup = _ProductGroupText.ProductGroup  -- association [0..*]
LEFT OUTER JOIN I_AdvncdPlngResourceGroupTxt AS _ResourceGroupText ON resourcegroup = _ResourceGroupText.ResourceGroup  -- association [0..*]
;

Learn More