I_PlndOrdSupplierCoByPlant

DDL: I_PLNDORDSUPPLIERCOBYPLANT Type: view_entity BASIC

Planned Order Supplier Company By Plant

I_PlndOrdSupplierCoByPlant is a Basic CDS View that provides data about "Planned Order Supplier Company By Plant" in SAP S/4HANA. It reads from 4 data sources (lfb1, plaf, t001k, t001w) and exposes 9 fields with key fields PlannedOrder, Plant, Supplier.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
lfb1 lfb1 inner
plaf plaf from
t001k t001k inner
t001w t001w inner

Annotations (10)

NameValueLevelField
EndUserText.label Planned Order Supplier Company By Plant view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey Plant view
Analytics.technicalName IPLDORDSUPCOPLT view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PlannedOrder plaf plnum
KEY Plant t001w werks
KEY Supplier lfb1 lifnr
ValuationArea t001k bwkey
CompanyCode t001k bukrs
AuthorizationGroup lfb1 begru
cvp_xblck_basIsBusinessPurposeCompleted
_Supplier _Supplier
_PlannedOrder _PlannedOrder 
@EndUserText.label: 'Planned Order Supplier Company By Plant'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'Plant'
@Analytics.technicalName: 'IPLDORDSUPCOPLT'

//@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API 

@VDM.viewType: #BASIC

@Metadata.ignorePropagatedAnnotations:true
//Mainy used for Enterprise Search

define view entity I_PlndOrdSupplierCoByPlant 
as select from plaf as plaf
inner join t001w as t001w on t001w.werks = plaf.plwrk -- to one JOIN
inner join t001k as t001k on t001k.bwkey = t001w.bwkey -- to one JOIN
//association [1..1] to I_Purreqvaluationarea as val on  $projection.ValuationArea = val.ValuationArea

inner join lfb1 as lfb1 on t001k.bukrs = lfb1.bukrs -- to many JOIN
association[0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association[0..1] to I_PlannedOrder as _PlannedOrder on $projection.PlannedOrder = _PlannedOrder.PlannedOrder
{
    @ObjectModel.foreignKey.association: '_PlannedOrder'
    key plaf.plnum                                    as PlannedOrder,
    
    key t001w.werks                                   as Plant,
    @ObjectModel.foreignKey.association: '_Supplier'
    key lfb1.lifnr                                    as Supplier,
    t001k.bwkey                                       as ValuationArea,
    t001k.bukrs                                       as CompanyCode,
    lfb1.begru as AuthorizationGroup,
    
    -- fields and associations for authorization checks
    lfb1.cvp_xblck_b as IsBusinessPurposeCompleted,
    _Supplier,
    _PlannedOrder
} where t001w.bwkey <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LFB1",
"PLAF",
"T001K",
"T001W"
],
"ASSOCIATED":
[
"I_PLANNEDORDER",
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More