I_MRPLotSizingProcedure
MRP Lot Sizing Procedure
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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| t439a | proc | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_MRPLotSizingProcedureText | _Text | $projection.MaterialLotSizingProcedure = _Text.MaterialLotSizingProcedure |
| [1..1] | I_MRPLotSizingProcedureType | _LotSizingProcedureType | $projection.LotSizingProcedureType = _LotSizingProcedureType.LotSizingProcedureType |
Annotations (23)
| Name | Value | Level | Field |
|---|---|---|---|
| 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.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 |
Fields (9)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MaterialLotSizingProcedure | t439a | disls | |
| LotSizingProcedureType | ||||
| LotSizeType | t439a | loskz | ||
| NumberOfLotSizingPeriods | ||||
| LotSizePeriodSchedulingType | t439a | terbv | ||
| LastLotIsPlannedExactly | t439a | lastl | ||
| UnderDeliveryTolIsChecked | t439a | untkz | ||
| _Text | _Text | |||
| _LotSizingProcedureType | _LotSizingProcedureType |
@AbapCatalog.sqlViewName: 'IPPLOTSIZPROC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering: {status: #ACTIVE, type: #FULL, numberOfKeyFields: 000}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.enabled: true
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.compositionRoot: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'MaterialLotSizingProcedure'
@ObjectModel.semanticKey: ['MaterialLotSizingProcedure']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'MRP Lot Sizing Procedure'
// For value help purposes refer to CDS I_MRPLotSizingProcedureVH
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
define view I_MRPLotSizingProcedure
as select from t439a as proc
association [0..*] to I_MRPLotSizingProcedureText as _Text on $projection.MaterialLotSizingProcedure = _Text.MaterialLotSizingProcedure
association [1..1] to I_MRPLotSizingProcedureType as _LotSizingProcedureType on $projection.LotSizingProcedureType = _LotSizingProcedureType.LotSizingProcedureType
{
@Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
@ObjectModel.text.association: '_Text'
key proc.disls as MaterialLotSizingProcedure,
@ObjectModel.foreignKey.association: '_LotSizingProcedureType'
cast(proc.losvf as vdm_losvf preserving type) as LotSizingProcedureType,
proc.loskz as LotSizeType,
-- proc.peraz as NumberOfLotSizingPeriods, // DEC fields not allowed
proc.terbv as LotSizePeriodSchedulingType,
proc.lastl as LastLotIsPlannedExactly,
proc.untkz as UnderDeliveryTolIsChecked,
// Associations
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_Text,
_LotSizingProcedureType
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T439A"
],
"ASSOCIATED":
[
"I_MRPLOTSIZINGPROCEDURETEXT",
"I_MRPLOTSIZINGPROCEDURETYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA