I_PURCTRADDRESS

CDS View

Address For Contract Item

I_PURCTRADDRESS is a CDS View in S/4HANA. Address For Contract Item. It contains 46 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 46 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_PurchaseContractAddress_2 view from COMPOSITE Delivery Address
A_PurCtrAddress view from COMPOSITE Delivery Address
C_PurCtrItemAdrs view from CONSUMPTION Consumption view for Item address
I_PurCtrAddressWD view from TRANSACTIONAL Contract Address Info with Draft
R_PPS_PurContrDelivAddressTP view_entity from TRANSACTIONAL Purchase Contract Address
R_PurContrAddressTP view_entity from TRANSACTIONAL Purchase Contract Address

Fields (46)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressIDForEdit 2
KEY PurchaseContract PurchaseContract,PurchaseContractForEdit 2
KEY PurchaseContractItem PurchaseContractItem,PurchaseContractItemForEdit 2
AdditionalStreetPrefixName AdditionalStreetPrefixName 1
AdditionalStreetSuffixName AdditionalStreetSuffixName 1
AddressTimeZone AddressTimeZone 1
Building Building 1
CareOfName CareOfName 1
CityCode CityCode 1
CityName CityName 1
CompanyPostalCode CompanyPostalCode 1
ConsigneeName3 ConsigneeName3 1
ConsigneeName4 ConsigneeName4 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 2
County County 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
District District 1
EmailAddress EmailAddress 1
FaxNumber FaxNumber 1
Floor Floor 1
FormOfAddress FormOfAddress 1
FullName FullName 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
MobilePhoneNumber MobilePhoneNumber 1
PhoneNumber PhoneNumber 1
Plant Plant 2
POBox POBox 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
RoomNumber RoomNumber 1
StreetName StreetName 1
StreetPrefixName StreetPrefixName 1
StreetSuffixName StreetSuffixName 1
TaxJurisdiction TaxJurisdiction 1
TransportZone TransportZone 1 
@AbapCatalog.sqlViewName: 'IPURCTRITMADRS'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Address For Contract Item'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED //TRANSACTIONAL


@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
//@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

 
define view I_PurCtrAddress
  as select from I_Purctraddressint

  association [1..1] to I_PurchaseContractItem as _PurchaseContractItem 
  //on  _PurchaseContractItem.ManualDeliveryAddressID = $projection.AddressID

                                                                        on _PurchaseContractItem.PurchaseContractItem    = $projection.PurchaseContractItem
                                                                        and _PurchaseContractItem.PurchaseContract        = $projection.PurchaseContract

  //association [1..1] to I_PurchaseContract     as _PurchaseContract     on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract

  association [1..1] to I_TimeZone             as _TimeZone             on  _TimeZone.TimeZoneID = $projection.AddressTimeZone
{
  key PurchaseContract,
  key PurchaseContractItem,
      AddressID,
      Plant,
      CareOfName,
      AdditionalStreetSuffixName,
      CorrespondenceLanguage,
      PrfrdCommMediumType,
      POBox,
      POBoxIsWithoutNumber,
      POBoxPostalCode,
      POBoxLobbyName,
      POBoxDeviatingCityName,
      POBoxDeviatingRegion,
      POBoxDeviatingCountry,
      DeliveryServiceTypeCode,
      DeliveryServiceNumber,
      AddressTimeZone,
      FullName,
      CityName,
      District,
      CityCode,
      HomeCityName,
      PostalCode,
      CompanyPostalCode,
      StreetName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      HouseNumber,
      HouseNumberSupplementText,
      Building,
      Floor,
      RoomNumber,
      Country,
      Region,
      County,
      FormOfAddress,
      ConsigneeName3,
      ConsigneeName4,
      TaxJurisdiction,
      TransportZone,
      PhoneNumber,
      MobilePhoneNumber,
      FaxNumber,
      EmailAddress,

      _Country,
      _Region,
      _TimeZone,

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

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

}                                                              
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCTRADDRESSINT"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_REGION",
"I_TIMEZONE"
],
"BASE":
[
"I_PURCTRADDRESSINT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More