P_CENTRALPURCONTRDISTRADDRESS

CDS View

Private View for Deliv. Addr. in Cntrl Contract Distribution

P_CENTRALPURCONTRDISTRADDRESS is a CDS View in S/4HANA. Private View for Deliv. Addr. in Cntrl Contract Distribution. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CentralPurContrDistrAddress view from COMPOSITE Basic View for Deliv. Addr. in Central Contract Distribution 
@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
}

Learn More