I_PurCtrAddressWD

DDL: I_PURCTRADDRESSWD SQL: IPURCTRITMADRSWD Type: view TRANSACTIONAL

Contract Address Info with Draft

I_PurCtrAddressWD is a Transactional CDS View that provides data about "Contract Address Info with Draft" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAddress) and exposes 55 fields with key fields PurchaseContract, PurchaseContractItem. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAddress Document from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContractItemWD _PurchaseContractItemWD _PurchaseContractItemWD.PurchaseContractItem = $projection.PurchaseContractItem and _PurchaseContractItemWD.PurchaseContract = $projection.PurchaseContract
[1..1] I_PurchaseContractWD _PurchaseContractWD _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract
[0..1] I_Country _Country $projection.Country = _Country.Country
[0..1] I_Region _Region $projection.Region = _Region.Region and $projection.Country = _Region.Country
[1..1] I_TimeZone _TimeZone _TimeZone.TimeZoneID = $projection.AddressTimeZone association[0..1] to I_LanguageText as _LanguageText on _LanguageText.Language = $projection.CorrespondenceLanguage and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPURCTRITMADRSWD view
EndUserText.label Contract Address Info with Draft view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence PURCTR_ITM_ADR_D view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurCtrAddress PurchaseContract
KEY PurchaseContractItem I_PurCtrAddress PurchaseContractItem
AddressID I_PurCtrAddress AddressID
PurchaseContractItemForEdit I_PurCtrAddress PurchaseContractItem
AddressIDForEdit I_PurCtrAddress AddressID
PurchaseContractForEdit I_PurCtrAddress PurchaseContract
Plant I_PurCtrAddress Plant
CareOfName I_PurCtrAddress CareOfName
AdditionalStreetSuffixName I_PurCtrAddress AdditionalStreetSuffixName
CorrespondenceLanguage I_PurCtrAddress CorrespondenceLanguage
PrfrdCommMediumType I_PurCtrAddress PrfrdCommMediumType
POBox I_PurCtrAddress POBox
POBoxIsWithoutNumber I_PurCtrAddress POBoxIsWithoutNumber
POBoxPostalCode I_PurCtrAddress POBoxPostalCode
POBoxLobbyName I_PurCtrAddress POBoxLobbyName
POBoxDeviatingCityName I_PurCtrAddress POBoxDeviatingCityName
POBoxDeviatingRegion I_PurCtrAddress POBoxDeviatingRegion
POBoxDeviatingCountry I_PurCtrAddress POBoxDeviatingCountry
DeliveryServiceTypeCode I_PurCtrAddress DeliveryServiceTypeCode
DeliveryServiceNumber I_PurCtrAddress DeliveryServiceNumber
AddressTimeZone I_PurCtrAddress AddressTimeZone
FullName I_PurCtrAddress FullName
CityName I_PurCtrAddress CityName
District I_PurCtrAddress District
CityCode I_PurCtrAddress CityCode
HomeCityName I_PurCtrAddress HomeCityName
PostalCode I_PurCtrAddress PostalCode
CompanyPostalCode I_PurCtrAddress CompanyPostalCode
StreetName I_PurCtrAddress StreetName
StreetPrefixName I_PurCtrAddress StreetPrefixName
AdditionalStreetPrefixName I_PurCtrAddress AdditionalStreetPrefixName
StreetSuffixName I_PurCtrAddress StreetSuffixName
HouseNumber I_PurCtrAddress HouseNumber
HouseNumberSupplementText I_PurCtrAddress HouseNumberSupplementText
Building I_PurCtrAddress Building
Floor I_PurCtrAddress Floor
RoomNumber I_PurCtrAddress RoomNumber
Country I_PurCtrAddress Country
Region I_PurCtrAddress Region
County I_PurCtrAddress County
FormOfAddress I_PurCtrAddress FormOfAddress
ConsigneeName3 I_PurCtrAddress ConsigneeName3
ConsigneeName4 I_PurCtrAddress ConsigneeName4
TaxJurisdiction I_PurCtrAddress TaxJurisdiction
TransportZone I_PurCtrAddress TransportZone
PhoneNumber I_PurCtrAddress PhoneNumber
MobilePhoneNumber I_PurCtrAddress MobilePhoneNumber
FaxNumber I_PurCtrAddress FaxNumber
EmailAddress I_PurCtrAddress EmailAddress
_Country _Country
_Region _Region
_TimeZone _TimeZone
_LanguageText _LanguageText
_PurchaseContractWD _PurchaseContractWD
_PurchaseContractItemWD _PurchaseContractItemWD
@AbapCatalog.sqlViewName: 'IPURCTRITMADRSWD'
@EndUserText.label: 'Contract Address Info with Draft'

@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.writeDraftPersistence: 'PURCTR_ITM_ADR_D'
@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_PurCtrAddressWD 
  as select from I_PurCtrAddress as Document

  association [1..1] to I_PurchaseContractItemWD as _PurchaseContractItemWD
  //  //on  _PurchaseContractItemWD.ManualDeliveryAddressID       = $projection.ActiveAddressID


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

  association [1..1] to I_PurchaseContractWD     as _PurchaseContractWD on  _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract


  association [0..1] to I_Country                as _Country            on  $projection.Country = _Country.Country

  association [0..1] to I_Region                 as _Region             on  $projection.Region  = _Region.Region
                                                                        and $projection.Country = _Region.Country

  association [1..1] to I_TimeZone               as _TimeZone           on  _TimeZone.TimeZoneID = $projection.AddressTimeZone
  
  association[0..1] to I_LanguageText as _LanguageText
     on _LanguageText.Language = $projection.CorrespondenceLanguage
     and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage
  
{
  key Document.PurchaseContract,      
  key Document.PurchaseContractItem,
      Document.AddressID,

      Document.PurchaseContractItem as PurchaseContractItemForEdit,

      Document.AddressID            as AddressIDForEdit,

      Document.PurchaseContract     as PurchaseContractForEdit,

      Document.Plant,

      Document.CareOfName,

      Document.AdditionalStreetSuffixName,

      Document.CorrespondenceLanguage,

      Document.PrfrdCommMediumType,

      Document.POBox,

      Document.POBoxIsWithoutNumber,

      Document.POBoxPostalCode,

      Document.POBoxLobbyName,

      Document.POBoxDeviatingCityName,

      Document.POBoxDeviatingRegion,

      Document.POBoxDeviatingCountry,

      Document.DeliveryServiceTypeCode,

      Document.DeliveryServiceNumber,

      @ObjectModel.readOnly:'EXTERNAL_CALCULATION'
      Document.AddressTimeZone,

      Document.FullName,

      Document.CityName,

      Document.District,

      Document.CityCode,

      Document.HomeCityName,

      Document.PostalCode,

      Document.CompanyPostalCode,

      Document.StreetName,

      Document.StreetPrefixName,

      Document.AdditionalStreetPrefixName,

      Document.StreetSuffixName,

      Document.HouseNumber,

      Document.HouseNumberSupplementText,

      Document.Building,

      Document.Floor,

      Document.RoomNumber,

      Document.Country,

      Document.Region,

      Document.County,

      Document.FormOfAddress,

      Document.ConsigneeName3,

      Document.ConsigneeName4,

      Document.TaxJurisdiction,

      Document.TransportZone,

      Document.PhoneNumber,

      Document.MobilePhoneNumber,

      Document.FaxNumber,

      Document.EmailAddress,

      _Country,

      _Region,

      _TimeZone,
      
      _LanguageText,

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

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _PurchaseContractItemWD
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCTRADDRESS"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_LANGUAGETEXT",
"I_PURCHASECONTRACTITEMWD",
"I_PURCHASECONTRACTWD",
"I_REGION",
"I_TIMEZONE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/