R_PurOrdItemDeliveryAddressTP

DDL: R_PURORDITEMDELIVERYADDRESSTP Type: view_entity TRANSACTIONAL

PO Item Delivery Address TP View

R_PurOrdItemDeliveryAddressTP is a Transactional CDS View that provides data about "PO Item Delivery Address TP View" in SAP S/4HANA. It reads from 1 data source (R_PurOrderItemDeliveryAddress) and exposes 62 fields with key fields PurchaseOrder, PurchaseOrderItem, DeliveryAddressID. It has 1 association to related views.

1 data source(s) 62 fields

Data Sources (1)

SourceAliasJoin Type
R_PurOrderItemDeliveryAddress R_PurOrderItemDeliveryAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label PO Item Delivery Address TP View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY DeliveryAddressID DeliveryAddressID
AddressID AddressID
AddressPersonID AddressPersonID
AddressRepresentationCode AddressRepresentationCode
CorrespondenceLanguage CorrespondenceLanguage
PrfrdCommMediumType PrfrdCommMediumType
AddresseeFullName AddresseeFullName
OrganizationName1 OrganizationName1
OrganizationName2 OrganizationName2
OrganizationName3 OrganizationName3
OrganizationName4 OrganizationName4
AddressSearchTerm1 AddressSearchTerm1
AddressSearchTerm2 AddressSearchTerm2
CityName CityName
DistrictName DistrictName
VillageName VillageName
PostalCode PostalCode
CompanyPostalCode CompanyPostalCode
StreetName StreetName
StreetPrefixName1 StreetPrefixName1
StreetPrefixName2 StreetPrefixName2
StreetSuffixName1 StreetSuffixName1
StreetSuffixName2 StreetSuffixName2
HouseNumber HouseNumber
HouseNumberSupplementText HouseNumberSupplementText
Building Building
Floor Floor
RoomNumber RoomNumber
Country Country
Region Region
FormOfAddress FormOfAddress
TaxJurisdiction TaxJurisdiction
TransportZone TransportZone
POBox POBox
POBoxIsWithoutNumber POBoxIsWithoutNumber
POBoxPostalCode POBoxPostalCode
POBoxLobbyName POBoxLobbyName
POBoxDeviatingCityName POBoxDeviatingCityName
POBoxDeviatingRegion POBoxDeviatingRegion
POBoxDeviatingCountry POBoxDeviatingCountry
CareOfName CareOfName
DeliveryServiceTypeCode DeliveryServiceTypeCode
DeliveryServiceNumber DeliveryServiceNumber
AddressTimeZone AddressTimeZone
EmailAddress _CurrentDfltEmailAddress EmailAddress
InternationalPhoneNumber _CurrentDfltLandlinePhoneNmbr InternationalPhoneNumber
InternationalFaxNumber _CurrentDfltFaxNumber InternationalFaxNumber
RegionalStructureCheckStatus RegionalStructureCheckStatus
_Country _Country
_CurrentDfltEmailAddress _CurrentDfltEmailAddress
_CurrentDfltFaxNumber _CurrentDfltFaxNumber
_CurrentDfltLandlinePhoneNmbr _CurrentDfltLandlinePhoneNmbr
_CurrentDfltMobilePhoneNumber _CurrentDfltMobilePhoneNumber
_DeliveryAddress _DeliveryAddress
_EmailAddress _EmailAddress
_FaxNumber _FaxNumber
_PhoneNumber _PhoneNumber
_Region _Region
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: { authorizationCheck: #PRIVILEGED_ONLY, personalData.blocking: #BLOCKED_DATA_EXCLUDED, privilegedAssociations: ['_DeliveryAddress'] }
@EndUserText.label: 'PO Item Delivery Address TP View'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
define view entity R_PurOrdItemDeliveryAddressTP
  as select from R_PurOrderItemDeliveryAddress

  association        to parent R_PurchaseOrderItemTP as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                           and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

  association [1..1] to R_PurchaseOrderTP            as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

{

  key  PurchaseOrder,
  key  PurchaseOrderItem,
  key  DeliveryAddressID,
       AddressID,
       AddressPersonID,
       AddressRepresentationCode,
       CorrespondenceLanguage,
       //@Consumption.hidden: true        StorageLocation,

       //@Consumption.hidden: true        Plant,

       PrfrdCommMediumType,
       AddresseeFullName,
       OrganizationName1,
       OrganizationName2,
       OrganizationName3,
       OrganizationName4,
       AddressSearchTerm1,
       AddressSearchTerm2,
       CityName,
       DistrictName,
       VillageName,
       PostalCode,
       CompanyPostalCode,
       StreetName,
       StreetPrefixName1,
       StreetPrefixName2,
       StreetSuffixName1,
       StreetSuffixName2,
       HouseNumber,
       HouseNumberSupplementText,
       Building,
       Floor,
       RoomNumber, 
       Country,
       Region,
       FormOfAddress,
       TaxJurisdiction,
       TransportZone,
       POBox,
       POBoxIsWithoutNumber,
       POBoxPostalCode,
       POBoxLobbyName,
       POBoxDeviatingCityName,
       POBoxDeviatingRegion,
       POBoxDeviatingCountry,
       CareOfName,
       DeliveryServiceTypeCode,
       DeliveryServiceNumber,
       AddressTimeZone,

       _CurrentDfltEmailAddress.EmailAddress,
       _CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber, // Code + tel_number - standard (Long)

       // _CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber, // tel_number

       // _CurrentDfltMobilePhoneNumber.InternationalPhoneNumber,  // second tel num (long)

       // _CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber, // second tel num

       _CurrentDfltFaxNumber.InternationalFaxNumber, //Long fax_number

       // _CurrentDfltFaxNumber.FaxExtensionNumber,

       RegionalStructureCheckStatus,

       /* Associations */
       _Country,
       _CurrentDfltEmailAddress,
       _CurrentDfltFaxNumber,
       _CurrentDfltLandlinePhoneNmbr,
       _CurrentDfltMobilePhoneNumber,
       _DeliveryAddress,
       _EmailAddress,
       _FaxNumber,
       _PhoneNumber,
       _Region,
       _PurchaseOrder,
       _PurchaseOrderItem

}  where _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"R_PURCHASEORDERITEMTP",
"R_PURORDERITEMDELIVERYADDRESS"
],
"ASSOCIATED":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_ADDRESSEMAILADDRESS_2",
"I_ADDRESSFAXNUMBER_2",
"I_ADDRESSPHONENUMBER_2",
"I_ADDRESS_2",
"I_COUNTRY",
"I_REGION",
"R_PURCHASEORDERITEMTP",
"R_PURCHASEORDERTP"
],
"BASE":
[
"R_PURORDERITEMDELIVERYADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More