P_CentralPurContrDistrAddress

DDL: P_CENTRALPURCONTRDISTRADDRESS SQL: PCPCDISTRADDR Type: view COMPOSITE

P_CentralPurContrDistrAddress is a Composite CDS View 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.

1 data source(s) 23 fields

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
KEY CentralPurchaseContractItem CentralPurchaseContractItem
KEY DistributionKey DistributionKey
CompanyCode CompanyCode
Plant Plant
PurchasingGroup PurchasingGroup
ManualDeliveryAddressID ManualDeliveryAddressID
CntrlPurContrDistributionLevel CntrlPurContrDistributionLevel
FullName _Address AddresseeFullName
StreetName _Address StreetName
HouseNumber _Address HouseNumber
CorrespondenceLanguage _Address CorrespondenceLanguage
POBox _Address POBox
POBoxPostalCode _Address POBoxPostalCode
AddressTimeZone _Address AddressTimeZone
CityName _Address CityName
PostalCode _Address PostalCode
CompanyPostalCode _Address CompanyPostalCode
Country _Address Country
Region _Address Region
PhoneNumber
FaxNumber
_CentralPurchaseContract _CentralPurchaseContract 
@AbapCatalog.sqlViewName: 'PCPCDISTRADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_CentralPurContrDistrAddress
  as select from I_CntrlPurContrDistribution
//  association [0..1] to I_Address as _Address on $projection.ManualDeliveryAddressID = _Address.AddressID

  association [0..1] to I_Address_2 as _Address on $projection.ManualDeliveryAddressID = _Address.AddressID
{
  key CentralPurchaseContract,
  key CentralPurchaseContractItem,
  key DistributionKey,
      CompanyCode,
      Plant,
      PurchasingGroup,
      ManualDeliveryAddressID,
      CntrlPurContrDistributionLevel,
 //     _Address.FullName,

      _Address.AddresseeFullName as FullName,
      _Address.StreetName,
      _Address.HouseNumber,
      _Address.CorrespondenceLanguage,
      _Address.POBox,
      _Address.POBoxPostalCode,
      _Address.AddressTimeZone,
      _Address.CityName,
      _Address.PostalCode,
      _Address.CompanyPostalCode,
      _Address.Country,
      _Address.Region,
   //   _Address.PhoneNumber,

      _Address._PhoneNumber.PhoneAreaCodeSubscriberNumber as PhoneNumber, 
   //   _Address.FaxNumber,

      _Address._FaxNumber.FaxAreaCodeSubscriberNumber as FaxNumber,
      /* Associations */
      _CentralPurchaseContract
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSFAXNUMBER_2",
"I_ADDRESSPHONENUMBER_2",
"I_ADDRESS_2",
"I_CNTRLPURCONTRDISTRIBUTION"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_CENTRALPURCHASECONTRACT"
],
"BASE":
[
"I_CNTRLPURCONTRDISTRIBUTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More