I_MRPLotSizingProcedure

DDL: I_MRPLOTSIZINGPROCEDURE SQL: IPPLOTSIZPROC Type: view BASIC Package: VDM_PP_MRP
9 Fields 1 Data Sources 2 Associations 3 OData Services

MRP Lot Sizing Procedure

I_MRPLotSizingProcedure (Basic)

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

MRP Lot Sizing Procedure · Manufacturing

I_MRPLotSizingProcedure is a Basic CDS View (Dimension) that provides data about "MRP Lot Sizing Procedure" in SAP S/4HANA. It reads from 1 data source (t439a) and exposes 9 fields with key field MaterialLotSizingProcedure. It has 2 associations to related views. It is exposed through 3 OData services (ASQL_F0246A, ASQL_F0263A, ASQL_F2825). Part of development package VDM_PP_MRP.

SAP Help Documentation

CategoryCDS Views for Material Requirements Planning
Data CategoryDIMENSION
Purpose
This CDS view provides the prerequisites for answering the following business questions: Which material lot-sizing procedures are maintained?

Structure
Main input parameters This view does not have any input parameters. Measures and attributes The following attribute is provided: Material lot-sizing procedure

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-2CL
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>Which material lot-sizing procedures are maintained?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
t439a proc from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MRPLotSizingProcedureText _Text $projection.MaterialLotSizingProcedure = _Text.MaterialLotSizingProcedure
[1..1] I_MRPLotSizingProcedureType _LotSizingProcedureType $projection.LotSizingProcedureType = _LotSizingProcedureType.LotSizingProcedureType

Annotations (24)

NameValueLevelField
AbapCatalog.sqlViewName IPPLOTSIZPROC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 000 view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey MaterialLotSizingProcedure view
ObjectModel.sapObjectNodeType.name MRPLotSizingProcedure view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label MRP Lot Sizing Procedure view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F0246A ASQL_F0246A C2 NOT_RELEASED
ASQL_F0263A ASQL_F0263A C2 NOT_RELEASED
ASQL_F2825 ASQL_F2825 C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaterialLotSizingProcedure t439a disls Lot Sizing Procedure in Materials Planning
LotSizingProcedureType Type of Lot Sizing Procedure
LotSizeType t439a loskz Lot-Size Indicator for the Short-Term Period
NumberOfLotSizingPeriods
LotSizePeriodSchedulingType t439a terbv Scheduling for period lot sizes in short-term area
LastLotIsPlannedExactly t439a lastl Last Lot is Planned Exactly
UnderDeliveryTolIsChecked t439a untkz Underdelivery Tolerance
_Text _Text
_LotSizingProcedureType _LotSizingProcedureType

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 I_MRPLotSizingProcedure.
-- 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: IPPLOTSIZPROC

CREATE VIEW I_MRPLotSizingProcedure AS
SELECT
  proc.disls AS MaterialLotSizingProcedure,
  cast(proc.losvf as vdm_losvf preserving type) AS LotSizingProcedureType,
  proc.loskz AS LotSizeType,
  proc.terbv AS LotSizePeriodSchedulingType,
  proc.lastl AS LastLotIsPlannedExactly,
  proc.untkz AS UnderDeliveryTolIsChecked
FROM t439a AS proc
LEFT OUTER JOIN I_MRPLotSizingProcedureText AS _Text ON MaterialLotSizingProcedure = _Text.MaterialLotSizingProcedure  -- association [0..*]
LEFT OUTER JOIN I_MRPLotSizingProcedureType AS _LotSizingProcedureType ON LotSizingProcedureType = _LotSizingProcedureType.LotSizingProcedureType  -- association [1..1]
;

Learn More