P_PurOrdMaintainHeaderActAddr

DDL: P_PURORDMAINTAINHEADERACTADDR SQL: PPOMAINTHDRACTAD Type: view CONSUMPTION
12 Fields 4 Data Sources

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.

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 Purchasing Document
PurchaseOrderAddressNumber I_PurchaseOrder SupplierAddressID Address Number
AddressIDendasAddressID
FullNameendasAddressName
StreetNameendasAddressStreetName
HouseNumberendasAddressHouseNumber
PostalCodeendasAddressPostalCode
CityNameendasAddressCityName
PhoneNumberendasAddressPhoneNumber
FaxNumberendasAddressFaxNumber
RegionendasAddressRegion
CountryendasAddressCountry

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PurOrdMaintainHeaderActAddr.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PPOMAINTHDRACTAD

CREATE VIEW P_PurOrdMaintainHeaderActAddr AS
SELECT
  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 AS AddressIDendasAddressID,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.FullName else ekko_address.FullName end as AddressName AS FullNameendasAddressName,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.StreetName else ekko_address.StreetName end as AddressStreetName AS StreetNameendasAddressStreetName,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.HouseNumber else ekko_address.HouseNumber end as AddressHouseNumber AS HouseNumberendasAddressHouseNumber,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.PostalCode else ekko_address.PostalCode end as AddressPostalCode AS PostalCodeendasAddressPostalCode,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.CityName else ekko_address.CityName end as AddressCityName AS CityNameendasAddressCityName,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address._DefaultPhoneNumber.PhoneNumber else ekko_address._DefaultPhoneNumber.PhoneNumber end as AddressPhoneNumber AS PhoneNumberendasAddressPhoneNumber,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address._DefaultFaxNumber.FaxNumber else ekko_address._DefaultFaxNumber.FaxNumber end as AddressFaxNumber AS FaxNumberendasAddressFaxNumber,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.Region else ekko_address.Region end as AddressRegion AS RegionendasAddressRegion,
  case when header.SupplierAddressID = '' or header.SupplierAddressID is null then supplier_address.Country else ekko_address.Country end as AddressCountry AS CountryendasAddressCountry
FROM I_PurchaseOrder AS header
LEFT OUTER JOIN I_Address AS ekko_address ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Address AS supplier_address ON /* join condition not captured in parsed metadata */
;

Learn More