P_Purchasingdocument_Fs

DDL: P_PURCHASINGDOCUMENT_FS SQL: PPurchasingdocFs Type: view BASIC

P_Purchasingdocument_Fs is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocument, I_PurchasingInfoRecord) and exposes 3 fields with key fields Supplier, Supplier, Material.

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

}                              
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"I_PURCHASINGINFORECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More