C_APSOrdTimeBufByWrkAreaDEX

DDL: C_APSORDTIMEBUFBYWRKAREADEX Type: view_entity CONSUMPTION
47 Fields 1 Data Sources 9 Associations

DEX for Order Time Buffer by Work Area

C_APSOrdTimeBufByWrkAreaDEX (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_APSOrdTimeBufByWrkAreaDEX is a Consumption CDS View that provides data about "DEX for Order Time Buffer by Work Area" in SAP S/4HANA. It reads from 1 data source (P_APSOrdTimeBufferByWrkArea) and exposes 47 fields with key fields AdvncdPlngPlanningVersion, SimulationSessionUUID, PlanningModel, AdvncdPlngOrderID, PPDSTimeBufferType. It has 9 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 gets the MultiLevel Time Buffer (MLTB) details available for orders, such as time buffer which can be calculated keeping a reference of the primary demand or immediate successor or predecessor order 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 order 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_PROD (APO: Advanced Planning Product Name, Advanced Planning Source Location) C_APO_LOC (APO: Advanced Planning Source Location) C_APO_LOC (APO: Advanced Planning Destination Location) 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. PP_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 gets the MultiLevel Time Buffer (MLTB) details available for orders, such as time buffer which can be calculated keeping a reference of the primary demand or immediate successor or predecessor order 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 order 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_APSOrdTimeBufferByWrkArea P_APSOrdTimeBufferByWrkArea from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_APSPlanVersion _PlanningVersion $projection.AdvncdPlngPlanningVersion = _PlanningVersion.AdvncdPlngPlanningVersion
[0..1] I_APSSimulationSession _SimulationSession $projection.SimulationSessionUUID = _SimulationSession.SimulationSessionUUID
[0..1] I_LocationBasic _SourceLocation $projection.AdvncdPlngFrmLocID = _SourceLocation.LocationUUID
[0..1] I_LocationBasic _DestinationLocation $projection.AdvncdPlngToLocID = _DestinationLocation.LocationUUID
[0..1] I_SCMPlanner _SCMPlanner $projection.ProductionPlanner = _SCMPlanner.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

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label DEX for Order 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 (47)

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 AdvncdPlngOrderID core_tb AdvncdPlngOrderID Internal Number (UID) for an Order in APO
KEY PPDSTimeBufferType core_tb PPDSTimeBufferType Time Buffer Type
PlanningVersionExternal core_tb PlanningVersionExternal Planning Version
AdvncdPlngOrderInternalNumber core_tb AdvncdPlngOrderInternalNumber Order Number
AdvncdPlngOrderType core_tb AdvncdPlngOrderType Order Type
AdvncdPlngOrderATPCategory core_tb AdvncdPlngOrderATPCategory ATP Category
AdvancedPlanningOrderStatus core_tb AdvancedPlanningOrderStatus Current Status
AdvncdPlngOrderObjectType core_tb AdvncdPlngOrderObjectType OLTP Object Type
AdvncdPlngFrmLocID core_tb AdvncdPlngFrmLocID Internal Location Number for Customer, Supplier, or Plant
AdvancedPlanningSourceLocation Location
SourceLocationType _SourceLocation LocationType Location Type
AdvncdPlngToLocID core_tb AdvncdPlngToLocID Internal Location Number for Customer, Supplier, or Plant
AdvancedPlanningDestLocation Location
AdvncdPlngDestLocType _DestinationLocation 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 _SCMPlanner PlannerName Production Planner Name
AdvancedPlanningSpclStkType core_tb AdvancedPlanningSpclStkType Special Stock Indicator
AdvncdPlngSpclStkSgmtKeyVal core_tb AdvncdPlngSpclStkSgmtKeyVal Key for Special Stock Segment
AdvncdPlngEffctvStrtDte core_tb AdvncdPlngEffctvStrtDte Validity Start Date of an Order
AdvncdPlngEffctvStrtTme core_tb AdvncdPlngEffctvStrtTme Start of Validity Period of an Order
AdvncdPlngEffctvEndDte core_tb AdvncdPlngEffctvEndDte Validity End Date of an Order
AdvncdPlngEffctvEndTme core_tb AdvncdPlngEffctvEndTme End of Validity of an Order
AdvncdPlngOrderStartDate core_tb AdvncdPlngOrderStartDate Start Date of First Order Activity
AdvncdPlngOrderStartTime core_tb AdvncdPlngOrderStartTime Start Time of First Order Activity
AdvncdPlngOrdEndDte core_tb AdvncdPlngOrdEndDte End Date of Last Order Activity
AdvncdPlngOrdEndTme core_tb AdvncdPlngOrdEndTme End Time of Last Order Activity
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
_SourceLocation _SourceLocation
_DestinationLocation _DestinationLocation
_SCMPlanner _SCMPlanner
_PlanningModelText _PlanningModelText
_ATPCategoryText _ATPCategoryText
_ProductGroupText _ProductGroupText
_ProductText _ProductText

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_APSOrdTimeBufByWrkAreaDEX.
-- 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_APSOrdTimeBufByWrkAreaDEX AS
SELECT
  core_tb.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  core_tb.SimulationSessionUUID AS SimulationSessionUUID,
  core_tb.PlanningModel AS PlanningModel,
  core_tb.AdvncdPlngOrderID AS AdvncdPlngOrderID,
  core_tb.PPDSTimeBufferType AS PPDSTimeBufferType,
  core_tb.PlanningVersionExternal AS PlanningVersionExternal,
  core_tb.AdvncdPlngOrderInternalNumber AS AdvncdPlngOrderInternalNumber,
  core_tb.AdvncdPlngOrderType AS AdvncdPlngOrderType,
  core_tb.AdvncdPlngOrderATPCategory AS AdvncdPlngOrderATPCategory,
  core_tb.AdvancedPlanningOrderStatus AS AdvancedPlanningOrderStatus,
  core_tb.AdvncdPlngOrderObjectType AS AdvncdPlngOrderObjectType,
  core_tb.AdvncdPlngFrmLocID AS AdvncdPlngFrmLocID,
  cast( _SourceLocation.Location as /sapapo/locno preserving type ) AS AdvancedPlanningSourceLocation,
  _SourceLocation.LocationType AS SourceLocationType,
  core_tb.AdvncdPlngToLocID AS AdvncdPlngToLocID,
  cast(_DestinationLocation.Location as /sapapo/locno preserving type ) AS AdvancedPlanningDestLocation,
  _DestinationLocation.LocationType AS AdvncdPlngDestLocType,
  core_tb.AdvancedPlanningProductName AS AdvancedPlanningProductName,
  core_tb.AdvncdPlngProductID AS AdvncdPlngProductID,
  core_tb.AdvancedPlanningMaterialGroup AS AdvancedPlanningMaterialGroup,
  core_tb.ProductionPlanner AS ProductionPlanner,
  _SCMPlanner.PlannerName AS ProductionPlannerName,
  core_tb.AdvancedPlanningSpclStkType AS AdvancedPlanningSpclStkType,
  core_tb.AdvncdPlngSpclStkSgmtKeyVal AS AdvncdPlngSpclStkSgmtKeyVal,
  core_tb.AdvncdPlngEffctvStrtDte AS AdvncdPlngEffctvStrtDte,
  core_tb.AdvncdPlngEffctvStrtTme AS AdvncdPlngEffctvStrtTme,
  core_tb.AdvncdPlngEffctvEndDte AS AdvncdPlngEffctvEndDte,
  core_tb.AdvncdPlngEffctvEndTme AS AdvncdPlngEffctvEndTme,
  core_tb.AdvncdPlngOrderStartDate AS AdvncdPlngOrderStartDate,
  core_tb.AdvncdPlngOrderStartTime AS AdvncdPlngOrderStartTime,
  core_tb.AdvncdPlngOrdEndDte AS AdvncdPlngOrdEndDte,
  core_tb.AdvncdPlngOrdEndTme AS AdvncdPlngOrdEndTme,
  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_APSOrdTimeBufferByWrkArea
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 _SourceLocation ON AdvncdPlngFrmLocID = _SourceLocation.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _DestinationLocation ON AdvncdPlngToLocID = _DestinationLocation.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_SCMPlanner AS _SCMPlanner ON ProductionPlanner = _SCMPlanner.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..*]
;

Learn More