P_MRPExtRqmtOrderType

DDL: P_MRPEXTRQMTORDERTYPE Type: view_entity BASIC Package: ODATA_PP_MRP

External Requirements Order Type

P_MRPExtRqmtOrderType is a Basic CDS View that provides data about "External Requirements Order Type" in SAP S/4HANA. It reads from 4 data sources (I_BillingDocumentType, I_DeliveryDocumentType, I_PurchasingDocumentType, I_SalesDocumentType) and exposes 2 fields with key fields OrderType, MRPOrderCategory. Part of development package ODATA_PP_MRP.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
I_BillingDocumentType I_BillingDocumentType from
I_DeliveryDocumentType I_DeliveryDocumentType union_all
I_PurchasingDocumentType I_PurchasingDocumentType union_all
I_SalesDocumentType I_SalesDocumentType union_all

Annotations (5)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey OrderType view
VDM.private true view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY OrderType BillingDocumentType
KEY MRPOrderCategory PurchasingDocumentCategory 
@AbapCatalog.viewEnhancementCategory: [#NONE]

@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.representativeKey: 'OrderType'

@VDM.private: true
@VDM.viewType: #BASIC

define view entity P_MRPExtRqmtOrderType 
as select from I_BillingDocumentType {
     
  key BillingDocumentType as OrderType,
  key SDDocumentCategory as MRPOrderCategory 
}
  union all select from I_DeliveryDocumentType { 
  
  key DeliveryDocumentType as OrderType,
  key SDDocumentCategory as MRPOrderCategory  
} 
  union all select from I_SalesDocumentType { 
  
  key SalesDocumentType as OrderType,
  key SDDocumentCategory as MRPOrderCategory  
}
  union all select from I_PurchasingDocumentType { 
  
  key PurchasingDocumentType as OrderType,
  key PurchasingDocumentCategory as MRPOrderCategory     
}

Learn More