P_Purchasingdocument_Fs

DDL: P_PURCHASINGDOCUMENT_FS SQL: PPurchasingdocFs Type: view BASIC Package: VDM_MD_PRODUCT_OBSOLETE

Private Factsheet - Purchasing Document

P_Purchasingdocument_Fs is a Basic CDS View that provides data about "Private Factsheet - Purchasing Document" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocument, I_PurchasingInfoRecord) and exposes 3 fields with key fields Supplier, Supplier, Material. Part of development package VDM_MD_PRODUCT_OBSOLETE.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocument PurchasingDoc from
I_PurchasingInfoRecord PurchasingInfoRecord union

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPurchasingdocFs view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_PurchasingDocument Supplier
KEY Supplier
KEY Material I_PurchasingInfoRecord Material 
@AbapCatalog.sqlViewName: 'PPurchasingdocFs'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
define view P_Purchasingdocument_Fs as select from I_PurchasingDocument as PurchasingDoc 
join I_PurchasingDocumentItem  as PurchasingDocItem  on PurchasingDocItem.PurchasingDocument = PurchasingDoc.PurchasingDocument 
//left outer join I_PurchasingInfoRecord  as PurchasingInfoRecord  on PurchasingDocItem.Material = PurchasingInfoRecord.Material and PurchasingInfoRecord.Supplier = PurchasingDoc.Supplier

{
    
   // key PurchasingDoc.PurchasingDocument,

      key PurchasingDoc.Supplier,
      key PurchasingDocItem.Material
}

union select from I_PurchasingInfoRecord as PurchasingInfoRecord

{

  key PurchasingInfoRecord.Supplier,
  key PurchasingInfoRecord.Material

}

Learn More