C_APSFillLvlInfoByWrkAreaDEX

DDL: C_APSFILLLVLINFOBYWRKAREADEX Type: view_entity CONSUMPTION
43 Fields 1 Data Sources 7 Associations

DEX for Fill Lvl Info by Work Area

C_APSFillLvlInfoByWrkAreaDEX (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_APSFillLvlInfoByWrkAreaDEX is a Consumption CDS View that provides data about "DEX for Fill Lvl Info by Work Area" in SAP S/4HANA. It reads from 1 data source (P_APSFillLvlInfoByWrkArea) and exposes 43 fields with key fields AdvncdPlngPlanningVersion, SimulationSessionUUID, AdvncdPlngResourceID, AdvncdPlngLocationID, AdvncdPlngProductID. It has 7 associations to related views.

SAP Help Documentation

CategoryDEX for Fill Level by Work Area
StatusProduct Mix Status Code
Purpose
This CDS view is a data extraction view that provides the fill level information of a storage resource based on the Work Area/Customizing ID for a given Planning Version between Start Date and End Date passed to the CDS view. These details include storage characteristics defined for the resource such as maximum stock quantity, minimum stock quantity, threshold quantity, allow multiple products flag, set remaining fill Level to zero flag, and product quantity and fill level of the storage resource for a day and time. All the changes done to the above listed attributes are also displayed by the CDS view along with the timestamp of occurrence of the change event. 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: Location, Advanced Planning Resource Name) C_APO_LOC (APO: Location) C_APO_PROD (APO: Advanced Planning Product Name, Location) 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 fill level details. P_AdvancedPlanningWorkArea : This parameter is used to specify the Work Area. The resources defined in the work area are used for evaluating the fill level details. P_AdvncdPlngOptPrflCustID : 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 fill level details (the Start Date is included in the evaluation). P_EndDate : This parameter is used to specify the End Date for evaluating the fill level details (the End Date is included in the evaluation). Important Fields Important fields in this view include the following: Field Name Description PPDSRsceEvaluationStartDate Start Date PPDSRsceEvaluationStartTime Start Time PPDSRsceEvaluationEndDate End Date PPDSRsceEvaluationEndTime End Time PPDSProductQuantity Product Quantity PPDSResourceFillLevelQuantity Fill Level Quantity PPDSRsceRemainingFillQuantity Remaining Fill Quantity PPDSRsceMaximumStockQuantity Maximum Stock Quantity PPDSRsceMinimumStockQuantity Minimum Stock Quantity PPDSResourceThresholdQuantity Threshold Quantity PPDSQuantityUnit Quantity Unit PPDSFillLevelStatusCode Fill Level Status Code PPDSRsceThresholdStatusCode Threshold Status Code PPDSRsceMaxStockLvlStatusCode Maximum Stock Level Status Code PPDSRsceForceToZeroStatusCode Force To Zero Status Code PPDSProductMixStatusCode Product Mix Status Code PPDSResourceIsSetToZeroActive Set To Zero Flag PPDSRsceAreMltplProdsAllowed Multiple Products Allowed Flag PPDSIsEndOfBucket End of Bucket Flag

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 fill level information of a storage resource based on the Work Area/Customizing ID for a given Planning Version between Start Date and End Date passed to the CDS view. These details include storage characteristics defined for the resource such as maximum stock quantity, minimum stock quantity, threshold quantity, allow multiple products flag, set remaining fill Level to zero flag, and product quantity and fill level of the storage resource for a day and time. All the changes done to the above listed attributes are also displayed by the CDS view along with the timestamp of occurrence of the change event. 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_APSFillLvlInfoByWrkArea P_APSFillLvlInfoByWrkArea from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_start_date
P_EndDate vdm_v_end_date

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_APSResource _Resource $projection.AdvncdPlngResourceID = _Resource.AdvncdPlngResourceID and $projection.AdvncdPlngPlanningVersion = _Resource.AdvncdPlngPlanningVersion and $projection.SimulationSessionUUID = _Resource.SimulationSessionUUID
[0..1] I_APSPlanVersion _PlanningVersion $projection.AdvncdPlngPlanningVersion = _PlanningVersion.AdvncdPlngPlanningVersion
[0..1] I_APSSimulationSession _SimulationSession $projection.SimulationSessionUUID = _SimulationSession.SimulationSessionUUID
[0..*] I_APSPlanningModelText _ModelText $projection.PlanningModel = _ModelText.PlanningModel
[0..*] I_LocationText _LocationText $projection.AdvncdPlngLocationID = _LocationText.LocationUUID
[0..1] I_SCMPlanner _SCMPlanner $projection.PPDSProductionPlanner = _SCMPlanner.Planner
[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 Fill Lvl Info 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 (43)

KeyFieldSource TableSource FieldDescription
KEY AdvncdPlngPlanningVersion fl_info AdvncdPlngPlanningVersion Name of Planning Version
KEY SimulationSessionUUID fl_info SimulationSessionUUID GUID for Identifying Transactional Simulation Session
KEY AdvncdPlngResourceID fl_info AdvncdPlngResourceID Internal Key (GUID) of a Resource
KEY AdvncdPlngLocationID _Resource LocationUUID Internal Location Number (Customer, Supplier, or Plant)
KEY AdvncdPlngProductID AdvncdPlngProductID Internal Number (UID) for Product
KEY PPDSRsceEvaluationStartDate PPDSRsceEvaluationStartDate Start Date for the Operation
KEY PPDSRsceEvaluationStartTime PPDSRsceEvaluationStartTime Start Time for Operation
KEY PPDSRsceEvaluationEndDate PPDSRsceEvaluationEndDate End Date of the Operation
KEY PPDSRsceEvaluationEndTime PPDSRsceEvaluationEndTime End Time for Operation
AdvancedPlanningProductName fl_info AdvancedPlanningProductName Product Number
ResourcePlanner _Resource ResourcePlanner Production Planner
ResourcePlannerName _Resource PlannerName Resource Planner Name
ResourceGroup _Resource ResourceGroup Resource Group
PlanningModel fl_info PlanningModel Model Name in Supply Chain Network
PlanningVersionExternal fl_info PlanningVersionExternal Planning Version
AdvncdPlngResourceName _Resource AdvncdPlngResourceName Resource Name
ResourceType _Resource ResourceType Resource Type
ResourceCategory _Resource ResourceCategory Resource Category
Location _Resource ResourceHomeLocation Location
LocationType _Resource LocationType Location Type
PPDSProductionPlanner PPDSProductionPlanner Production Planner
ProductionPlannerName _SCMPlanner PlannerName Production Planner Name
PPDSProductQuantity PPDSProductQuantity Product Quantity
PPDSResourceFillLevelQuantity PPDSResourceFillLevelQuantity Fill Level Quantity
PPDSRsceRemainingFillQuantity PPDSRsceRemainingFillQuantity Available Remaining Quantity
PPDSRsceMaximumStockQuantity PPDSRsceMaximumStockQuantity Allowed Maximum Stock Quanity
PPDSRsceMinimumStockQuantity PPDSRsceMinimumStockQuantity Allowed Minimum Stock Quanity
PPDSResourceThresholdQuantity PPDSResourceThresholdQuantity Threshold Quantity
PPDSQuantityUnit PPDSQuantityUnit Base Unit of Measure
PPDSFillLevelStatusCode PPDSFillLevelStatusCode Fill Level Indicator
PPDSRsceThresholdStatusCode PPDSRsceThresholdStatusCode Force-to-zero Threshold
PPDSRsceMaxStockLvlStatusCode PPDSRsceMaxStockLvlStatusCode Maximum Stock Level Indicator
PPDSRsceForceToZeroStatusCode PPDSRsceForceToZeroStatusCode Force-to-Zero Indicator
PPDSProductMixStatusCode PPDSProductMixStatusCode Product Mix Indicator
PPDSResourceIsSetToZeroActive PPDSResourceIsSetToZeroActive For Resource with Storage: "Force-to-Zero" Semantic
PPDSRsceAreMltplProdsAllowed PPDSRsceAreMltplProdsAllowed Allow Multiple Products
_Resource _Resource
_PlanningVersion _PlanningVersion
_SimulationSession _SimulationSession
_SCMPlanner _SCMPlanner
_ModelText _ModelText
_LocationText _LocationText
_ResourceGroupText _ResourceGroupText

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_APSFillLvlInfoByWrkAreaDEX.
-- 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_APSFillLvlInfoByWrkAreaDEX AS
SELECT
  fl_info.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  fl_info.SimulationSessionUUID AS SimulationSessionUUID,
  fl_info.AdvncdPlngResourceID AS AdvncdPlngResourceID,
  _Resource.LocationUUID AS AdvncdPlngLocationID,
  AdvncdPlngProductID,
  PPDSRsceEvaluationStartDate,
  PPDSRsceEvaluationStartTime,
  PPDSRsceEvaluationEndDate,
  PPDSRsceEvaluationEndTime,
  fl_info.AdvancedPlanningProductName AS AdvancedPlanningProductName,
  _Resource.ResourcePlanner AS ResourcePlanner,
  _Resource.PlannerName AS ResourcePlannerName,
  _Resource.ResourceGroup AS ResourceGroup,
  fl_info.PlanningModel AS PlanningModel,
  fl_info.PlanningVersionExternal AS PlanningVersionExternal,
  _Resource.AdvncdPlngResourceName AS AdvncdPlngResourceName,
  _Resource.ResourceType AS ResourceType,
  _Resource.ResourceCategory AS ResourceCategory,
  _Resource.ResourceHomeLocation AS Location,
  _Resource.LocationType AS LocationType,
  PPDSProductionPlanner,
  _SCMPlanner.PlannerName AS ProductionPlannerName,
  PPDSProductQuantity,
  PPDSResourceFillLevelQuantity,
  PPDSRsceRemainingFillQuantity,
  PPDSRsceMaximumStockQuantity,
  PPDSRsceMinimumStockQuantity,
  PPDSResourceThresholdQuantity,
  PPDSQuantityUnit,
  PPDSFillLevelStatusCode,
  PPDSRsceThresholdStatusCode,
  PPDSRsceMaxStockLvlStatusCode,
  PPDSRsceForceToZeroStatusCode,
  PPDSProductMixStatusCode,
  PPDSResourceIsSetToZeroActive,
  PPDSRsceAreMltplProdsAllowed
FROM P_APSFillLvlInfoByWrkArea
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_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_APSPlanningModelText AS _ModelText ON PlanningModel = _ModelText.PlanningModel  -- association [0..*]
LEFT OUTER JOIN I_LocationText AS _LocationText ON AdvncdPlngLocationID = _LocationText.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_SCMPlanner AS _SCMPlanner ON PPDSProductionPlanner = _SCMPlanner.Planner  -- association [0..1]
LEFT OUTER JOIN I_AdvncdPlngResourceGroupTxt AS _ResourceGroupText ON resourcegroup = _ResourceGroupText.ResourceGroup  -- association [0..*]
;

Learn More