I_MRPLotSizingProcedure

DDL: I_MRPLOTSIZINGPROCEDURE SQL: IPPLOTSIZPROC Type: view BASIC

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)

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 (23)

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.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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/