A_PurCtrAddress

DDL: A_PURCTRADDRESS SQL: APURCTRITMADRS Type: view COMPOSITE Package: ODATA_MM_PUR_CON_API

Delivery Address

A_PurCtrAddress is a Composite CDS View that provides data about "Delivery Address" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAddress) and exposes 37 fields with key fields PurchaseContract, AddressID, PurchaseContractItem. It has 2 associations to related views. Part of development package ODATA_MM_PUR_CON_API.

1 data source(s) 37 fields

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAddress I_PurCtrAddress from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseContractItem _PurchaseContractItem _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem and _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract
[1..1] A_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName APURCTRITMADRS view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Address view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY AddressID AddressID
KEY PurchaseContractItem PurchaseContractItem
FormOfAddress FormOfAddress
FullName FullName
ConsigneeName3 ConsigneeName3
ConsigneeName4 ConsigneeName4
CareOfName CareOfName
CityName CityName
District District
CityCode CityCode
PostalCode PostalCode
POBoxPostalCode POBoxPostalCode
CompanyPostalCode CompanyPostalCode
POBox POBox
POBoxDeviatingCityName POBoxDeviatingCityName
StreetName StreetName
HouseNumber HouseNumber
StreetPrefixName StreetPrefixName
AdditionalStreetPrefixName AdditionalStreetPrefixName
AdditionalStreetSuffixName AdditionalStreetSuffixName
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
CorrespondenceLanguage CorrespondenceLanguage
Region Region
AddressTimeZone AddressTimeZone
TaxJurisdiction TaxJurisdiction
PrfrdCommMediumType PrfrdCommMediumType
PhoneNumber PhoneNumber
FaxNumber FaxNumber
TransportZone TransportZone
HouseNumberSupplementText HouseNumberSupplementText
StreetSuffixName StreetSuffixName
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem 
@AbapCatalog.sqlViewName: 'APURCTRITMADRS'
@VDM.viewType : #COMPOSITE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Delivery Address'
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: false
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED

define view A_PurCtrAddress as select from I_PurCtrAddress 

   association [1..1] to A_PurchaseContractItem as _PurchaseContractItem  on _PurchaseContractItem.PurchaseContractItem    = $projection.PurchaseContractItem
                                                                        and _PurchaseContractItem.PurchaseContract        = $projection.PurchaseContract
   association [1..1] to A_PurchaseContract     as _PurchaseContract     on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract
                                                                       
{
     key PurchaseContract,
     key AddressID,
     key PurchaseContractItem,
     
     FormOfAddress,
 
     //Needs a check when we are doing address handling as it is combination of ad_name1 and ad_name2

     FullName,
     
     ConsigneeName3,
     
     ConsigneeName4,
     
     CareOfName,
     
     CityName,
     
     District,
     
     CityCode,
     
     PostalCode,
     
     POBoxPostalCode,
     
     CompanyPostalCode,
     
     POBox,
     
     POBoxDeviatingCityName,
     
     StreetName,
     
     HouseNumber,
     
     StreetPrefixName,
     
     AdditionalStreetPrefixName,
     
     AdditionalStreetSuffixName,
     
     Building,
     
     Floor,
     
     RoomNumber,
     
     @ObjectModel.sapObjectNodeTypeReference : 'Country'
     Country,
     
     CorrespondenceLanguage,
     
     @ObjectModel.sapObjectNodeTypeReference : 'Region'
     Region,
     
     //SearchTerm1,

     
     AddressTimeZone,
      
     @ObjectModel.sapObjectNodeTypeReference: 'TaxJurisdiction'
     TaxJurisdiction,
     
     PrfrdCommMediumType,
     
     PhoneNumber,
     
     FaxNumber,
     
     //Street,

     
     TransportZone,
     
     HouseNumberSupplementText,
     
     StreetSuffixName,
     
        @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT]
      _PurchaseContract,

      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
      _PurchaseContractItem

}

Learn More