I_PURORDDELIVERYADDRESSTP

CDS View

Transactional View for Delivery Address in Purchase Order

I_PURORDDELIVERYADDRESSTP is a CDS View in S/4HANA. Transactional View for Delivery Address in Purchase Order. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PurOrdDeliveryAddressTP view from CONSUMPTION Purchase Order Delivery Address 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'IPODELADDTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transactional View for Delivery Address in Purchase Order'
@ObjectModel: {
    semanticKey: ['PurchaseOrder', 'PurchaseOrderItem'],
    representativeKey: 'PurchaseOrderItem',
    updateEnabled: true,
    writeDraftPersistence: 'POSDELADD_D',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #L,
    usageType.dataClass: #MIXED
}
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurOrdDeliveryAddressTP as select from I_PurOrdItemDeliveryAddress
  association [1..1] to I_PurchaseOrderTP     as _PurchaseOrderTP     on  _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
  association [1..1] to I_PurchaseOrderItemTP as _PurchaseOrderItemTP on  _PurchaseOrderItemTP.PurchaseOrder     = $projection.PurchaseOrder
                                                                      and _PurchaseOrderItemTP.PurchaseOrderItem = $projection.PurchaseOrderItem
 {

 @ObjectModel.foreignKey.association: '_PurchaseOrderTP'
 key I_PurOrdItemDeliveryAddress.PurchaseOrder,

 key I_PurOrdItemDeliveryAddress.PurchaseOrderItem,

I_PurOrdItemDeliveryAddress.ItemDeliveryAddressID,

I_PurOrdItemDeliveryAddress.ReferenceDeliveryAddressID,

      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
      _Address_2.AddresseeFullName                                      as FullName,
      _Address_2.StreetName,
      _Address_2.HouseNumber,
      _Address_2.PostalCode,
      _Address_2.CityName,
      _Address_2._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as PhoneNumber,
      _Address_2._CurrentDfltFaxNumber.InternationalFaxNumber           as FaxNumber,
      _Address_2.Region,
      _Address_2.Country,
      _Address_2.CorrespondenceLanguage,
      @UI.hidden: true
      _Address_2.TaxJurisdiction,                               // 2775950

      _Address_2._Country.TaxCalculationProcedure as TaxCalculationProcedure,
      
      @ObjectModel.association.type: #TO_COMPOSITION_ROOT
      _PurchaseOrderTP,
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _PurchaseOrderItemTP

} where  _PurchaseOrderItemTP.PurchasingDocumentDeletionCode <> 'L'
  and    _PurchaseOrderItemTP.PurgDocAggrgdSubitemCategory   <> 'C'

Learn More