P_CentralPurContrDistrAddress

DDL: P_CENTRALPURCONTRDISTRADDRESS SQL: PCPCDISTRADDR Type: view COMPOSITE Package: VDM_MM_PUR_CCTR
23 Fields 1 Data Sources 1 Associations

Private View for Deliv. Addr. in Cntrl Contract Distribution

P_CentralPurContrDistrAddress is a Composite CDS View that provides data about "Private View for Deliv. Addr. in Cntrl Contract Distribution" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrDistribution) and exposes 23 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey. It has 1 association to related views. Part of development package VDM_MM_PUR_CCTR.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrDistribution I_CntrlPurContrDistribution from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Address_2 _Address $projection.ManualDeliveryAddressID = _Address.AddressID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCPCDISTRADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
KEY DistributionKey DistributionKey Distr. Number
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
PurchasingGroup PurchasingGroup Purchasing Group
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
CntrlPurContrDistributionLevel CntrlPurContrDistributionLevel
FullName _Address AddresseeFullName Full Name
StreetName _Address StreetName Text
HouseNumber _Address HouseNumber House Number
CorrespondenceLanguage _Address CorrespondenceLanguage Language
POBox _Address POBox PO Box
POBoxPostalCode _Address POBoxPostalCode PO Box Postal Code
AddressTimeZone _Address AddressTimeZone Time Zone
CityName _Address CityName Name
PostalCode _Address PostalCode Postal Code
CompanyPostalCode _Address CompanyPostalCode Company Post Cd
Country _Address Country Venue: Ctry/Reg
Region _Address Region Venue Region
PhoneNumber
FaxNumber
_CentralPurchaseContract _CentralPurchaseContract

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_CentralPurContrDistrAddress.
-- 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: PCPCDISTRADDR

CREATE VIEW P_CentralPurContrDistrAddress AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  CompanyCode,
  Plant,
  PurchasingGroup,
  ManualDeliveryAddressID,
  CntrlPurContrDistributionLevel,
  _Address.AddresseeFullName AS FullName,
  _Address.StreetName AS StreetName,
  _Address.HouseNumber AS HouseNumber,
  _Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  _Address.POBox AS POBox,
  _Address.POBoxPostalCode AS POBoxPostalCode,
  _Address.AddressTimeZone AS AddressTimeZone,
  _Address.CityName AS CityName,
  _Address.PostalCode AS PostalCode,
  _Address.CompanyPostalCode AS CompanyPostalCode,
  _Address.Country AS Country,
  _Address.Region AS Region,
  _Address._PhoneNumber.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _Address._FaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN I_Address_2 AS _Address ON ManualDeliveryAddressID = _Address.AddressID  -- association [0..1]
;

Learn More