P_PurOrdMaintainHeaderActAddr

DDL: P_PURORDMAINTAINHEADERACTADDR SQL: PPOMAINTHDRACTAD Type: view CONSUMPTION

P_PurOrdMaintainHeaderActAddr is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_Address, I_PurchaseOrder, I_Supplier, I_Address) and exposes 12 fields with key field PurchaseOrder.

4 data source(s) 12 fields

Data Sources (4)

SourceAliasJoin Type
I_Address ekko_address left_outer
I_PurchaseOrder header from
I_Supplier supplier left_outer
I_Address supplier_address left_outer

Annotations (4)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.sqlViewName PPOMAINTHDRACTAD view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder
PurchaseOrderAddressNumber I_PurchaseOrder SupplierAddressID
AddressIDendasAddressID
FullNameendasAddressName
StreetNameendasAddressStreetName
HouseNumberendasAddressHouseNumber
PostalCodeendasAddressPostalCode
CityNameendasAddressCityName
PhoneNumberendasAddressPhoneNumber
FaxNumberendasAddressFaxNumber
RegionendasAddressRegion
CountryendasAddressCountry 
// =========================================================================

//   PO Maintenance: Address of Purchase Order Header

// =========================================================================


@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.sqlViewName: 'PPOMAINTHDRACTAD'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY


define view P_PurOrdMaintainHeaderActAddr 
   
   as select from I_PurchaseOrder as header

    left outer join I_Address  as ekko_address     on header.SupplierAddressID   = ekko_address.AddressID
    left outer join I_Supplier as supplier         on header.Supplier    = supplier.Supplier
    left outer join I_Address  as supplier_address on supplier.AddressID = supplier_address.AddressID
{
                                                                   key header.PurchaseOrder  as  PurchaseOrder,
                                                                       header.SupplierAddressID      as  PurchaseOrderAddressNumber,
   case 
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.AddressID 
     else                                                            ekko_address.AddressID 
   end                                                                                       as  AddressID,   
   case 
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.FullName 
     else                                                            ekko_address.FullName
   end                                                                                       as  AddressName,    
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.StreetName 
     else                                                            ekko_address.StreetName
   end                                                                                       as  AddressStreetName,   
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.HouseNumber 
     else                                                            ekko_address.HouseNumber
   end                                                                                       as  AddressHouseNumber,
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.PostalCode 
     else                                                            ekko_address.PostalCode
   end                                                                                       as  AddressPostalCode,    
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.CityName 
     else                                                            ekko_address.CityName
   end                                                                                       as  AddressCityName,   
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address._DefaultPhoneNumber.PhoneNumber 
     else                                                            ekko_address._DefaultPhoneNumber.PhoneNumber
   end                                                                                       as  AddressPhoneNumber,   
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address._DefaultFaxNumber.FaxNumber 
     else                                                            ekko_address._DefaultFaxNumber.FaxNumber
   end                                                                                       as  AddressFaxNumber,     
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.Region 
     else                                                            ekko_address.Region
   end                                                                                       as  AddressRegion,    
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.Country 
     else                                                            ekko_address.Country
   end                                                                                       as  AddressCountry,         
   case
     when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.CorrespondenceLanguage 
     else                                                            ekko_address.CorrespondenceLanguage
   end                                                                                       as  AddressCorrespondenceLanguage      
  
}
                                                  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_ADDRESSFAXNUMBER",
"I_ADDRESSPHONENUMBER",
"I_PURCHASEORDER",
"I_SUPPLIER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More