A_PurchaseContractAddress_2

DDL: A_PURCHASECONTRACTADDRESS_2 SQL: APURCTRITMADRS2 Type: view COMPOSITE Package: ODATA_MM_PUR_CON_API

Delivery Address

A_PurchaseContractAddress_2 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_2 _PurchaseContractItem _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem and _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract
[1..1] A_PurchaseContract_2 _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName APURCTRITMADRS2 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
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
OData.entitySet.name A_PurCtrAddress 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
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
TransportZone TransportZone
HouseNumberSupplementText HouseNumberSupplementText
StreetSuffixName StreetSuffixName
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem 
@AbapCatalog.sqlViewName: 'APURCTRITMADRS2'
@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
}
@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED
@OData.entitySet.name : 'A_PurCtrAddress'

define view A_PurchaseContractAddress_2
  as select from I_PurCtrAddress

  association [1..1] to A_PurchaseContractItem_2 as _PurchaseContractItem on  _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
                                                                          and _PurchaseContractItem.PurchaseContract     = $projection.PurchaseContract
  association [1..1] to A_PurchaseContract_2     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,

      cast(District as ort02_gp) as District,

      cast(CityCode as cityc)    as 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,

      cast(FaxNumber as telfx)   as FaxNumber,

      //Street,


      TransportZone,

      HouseNumberSupplementText,

      StreetSuffixName,

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

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

}

Learn More