C_CntrlPurContrHdrDistrAddrTP

DDL: C_CNTRLPURCONTRHDRDISTRADDRTP SQL: CCPCHDISTRADDRTP Type: view CONSUMPTION
26 Fields 1 Data Sources 6 Associations

C-View for Deliv. Addr. in Central Contract Header Distrib.

C_CntrlPurContrHdrDistrAddrTP is a Consumption CDS View that provides data about "C-View for Deliv. Addr. in Central Contract Header Distrib." in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrHdrDistrAddrTP) and exposes 26 fields with key fields CentralPurchaseContract, DistributionKey. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrHdrDistrAddrTP I_CntrlPurContrHdrDistrAddrTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] C_CntrlPurContrHdrDistrTP _CntrlPurContrHdrDistrTP _CntrlPurContrHdrDistrTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrHdrDistrTP.DistributionKey = $projection.DistributionKey
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..1] I_Region _Region $projection.Region = _Region.Region and $projection.Country = _Region.Country
[1..1] I_TimeZone _TimeZone _TimeZone.TimeZoneID = $projection.AddressTimeZone
[0..1] I_LanguageText _LanguageText _LanguageText.Language = $projection.CorrespondenceLanguage and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CCPCHDISTRADDRTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label C-View for Deliv. Addr. in Central Contract Header Distrib. view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY DistributionKey DistributionKey Distr. Number
CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
ManualDeliveryAddressID ManualDeliveryAddressID Address Number
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
FullName FullName Name
StreetName StreetName Text
HouseNumber HouseNumber House Number
CorrespondenceLanguage CorrespondenceLanguage Language
POBox POBox PO Box
POBoxPostalCode POBoxPostalCode PO Box Postal Code
AddressTimeZone AddressTimeZone Time Zone
CityName CityName Name
PostalCode PostalCode Postal Code
CompanyPostalCode CompanyPostalCode Company Post Cd
Country Country Venue: Ctry/Reg
Region Region Venue Region
PhoneNumber PhoneNumber Telephone no.
FaxNumber FaxNumber Fax Number
_CentralPurchaseContractTP _CentralPurchaseContractTP
_CntrlPurContrHdrDistrTP _CntrlPurContrHdrDistrTP
_Country _Country
_LanguageText _LanguageText
_Region _Region
_TimeZone _TimeZone

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 C_CntrlPurContrHdrDistrAddrTP.
-- 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: CCPCHDISTRADDRTP

CREATE VIEW C_CntrlPurContrHdrDistrAddrTP AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  CentralPurchaseContractItem,
  ManualDeliveryAddressID,
  CompanyCode,
  Plant,
  FullName,
  StreetName,
  HouseNumber,
  CorrespondenceLanguage,
  POBox,
  POBoxPostalCode,
  AddressTimeZone,
  CityName,
  PostalCode,
  CompanyPostalCode,
  Country,
  Region,
  PhoneNumber,
  FaxNumber
FROM I_CntrlPurContrHdrDistrAddrTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrHdrDistrTP AS _CntrlPurContrHdrDistrTP ON _CntrlPurContrHdrDistrTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrDistrTP.DistributionKey = DistributionKey  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON _TimeZone.TimeZoneID = AddressTimeZone  -- association [1..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON _LanguageText.Language = CorrespondenceLanguage AND _LanguageText.LanguageCode = CorrespondenceLanguage  -- association [0..1]
;

Learn More