I_MaterialPlanningUsageText_SL

DDL: I_MATERIALPLANNINGUSAGETEXT_SL SQL: IAUTETTEXT Type: view BASIC Package: VDM_MM_PUR_SOS_SL

Source List Usage in Materials Planning Texts

I_MaterialPlanningUsageText_SL is a Basic CDS View that provides data about "Source List Usage in Materials Planning Texts" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 5 fields with key fields Language, MRPSourcingControl. It has 2 associations to related views. Part of development package VDM_MM_PUR_SOS_SL.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaterialPlanningUsage_SL _MRPSourcingControl $projection.MRPSourcingControl = _MRPSourcingControl.MRPSourcingControl
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IAUTETTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
EndUserText.label Source List Usage in Materials Planning Texts view
VDM.viewType #BASIC view
ObjectModel.representativeKey MRPSourcingControl view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language
KEY MRPSourcingControl dd07t domvalue_l
MRPSourcingControlName dd07t ddtext
_MRPSourcingControl _MRPSourcingControl
_Language _Language 
@AbapCatalog.sqlViewName: 'IAUTETTEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.dataCategory: #TEXT
@EndUserText.label: 'Source List Usage in Materials Planning Texts'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'MRPSourcingControl'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
define view I_MaterialPlanningUsageText_SL as select from dd07t
   association [0..1] to I_MaterialPlanningUsage_SL as _MRPSourcingControl
        on  $projection.MRPSourcingControl = _MRPSourcingControl.MRPSourcingControl
    association [0..1] to I_Language as _Language
        on $projection.Language = _Language.Language
{
    @Semantics.language
    key cast(ddlanguage as spras) as Language,
    key dd07t.domvalue_l as MRPSourcingControl,
    @Semantics.text
    dd07t.ddtext as MRPSourcingControlName,
_MRPSourcingControl,
_Language    
}where dd07t.domname = 'AUTET' and dd07t.as4local = 'A'

Learn More