C_PODeliveryAddressFactSheet

DDL: C_PODELIVERYADDRESSFACTSHEET SQL: CPODELADDTPFS Type: view CONSUMPTION

Purchase Order Fact Sheet Delivery Address

C_PODeliveryAddressFactSheet is a Consumption CDS View that provides data about "Purchase Order Fact Sheet Delivery Address" in SAP S/4HANA. It reads from 1 data source (I_PurOrdItemDeliveryAddress) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdItemDeliveryAddress I_PurOrdItemDeliveryAddress from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_PurOrdDeliveryAddressTP PurOrdDeliveryAddressTP PurOrdDeliveryAddressTP.PurchaseOrder = $projection.PurchaseOrder and PurOrdDeliveryAddressTP.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPODELADDTPFS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Order Fact Sheet Delivery Address view
ObjectModel.representativeKey PurchaseOrder view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurOrdItemDeliveryAddress PurchaseOrder
KEY PurchaseOrderItem I_PurOrdItemDeliveryAddress PurchaseOrderItem
Plant Plant
ItemDeliveryAddressID ItemDeliveryAddressID
AddresseeFullName
StreetName
HouseNumber
PostalCode
CityName
PhoneNumber PurOrdDeliveryAddressTP PhoneNumber
InternationalFaxNumber
Region
Country
CountryName PurOrdDeliveryAddressTP CountryName
RegionName PurOrdDeliveryAddressTP RegionName
_PurchaseOrder _PurchaseOrder
@AbapCatalog.sqlViewName: 'CPODELADDTPFS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchase Order Fact Sheet Delivery Address'
@ObjectModel: {
    semanticKey: ['PurchaseOrder', 'PurchaseOrderItem'],
    representativeKey: 'PurchaseOrder',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #M,
    usageType.dataClass: #MIXED
}
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
define view C_PODeliveryAddressFactSheet
  as select from I_PurOrdItemDeliveryAddress
  association [1..1] to C_PurOrdDeliveryAddressTP as PurOrdDeliveryAddressTP on  PurOrdDeliveryAddressTP.PurchaseOrder     = $projection.PurchaseOrder
                                                                             and PurOrdDeliveryAddressTP.PurchaseOrderItem = $projection.PurchaseOrderItem
{

  key I_PurOrdItemDeliveryAddress.PurchaseOrder,

  key I_PurOrdItemDeliveryAddress.PurchaseOrderItem,

      @UI.hidden:true
      Plant,
      @UI.hidden:true
      ItemDeliveryAddressID,
      @UI.fieldGroup: [ { position: 10, qualifier: 'DeliveryAddress1' } ]
      I_PurOrdItemDeliveryAddress._Address_2.AddresseeFullName,
      @UI.fieldGroup: [ { position: 20, qualifier: 'DeliveryAddress1' } ]
      I_PurOrdItemDeliveryAddress._Address_2.StreetName,
      @UI.fieldGroup: [ { position: 30, qualifier: 'DeliveryAddress1' } ]
      I_PurOrdItemDeliveryAddress._Address_2.HouseNumber,
      @UI.fieldGroup: [ { position: 10, qualifier: 'DeliveryAddress2' } ]
      I_PurOrdItemDeliveryAddress._Address_2.PostalCode,
      @UI.fieldGroup: [ { position: 20, qualifier: 'DeliveryAddress2' } ]
      I_PurOrdItemDeliveryAddress._Address_2.CityName,
      PurOrdDeliveryAddressTP.PhoneNumber,
      I_PurOrdItemDeliveryAddress._Address_2._CurrentDfltFaxNumber.InternationalFaxNumber,
      @UI.fieldGroup: [ { position: 10, qualifier: 'DeliveryAddress3' } ]
      @Consumption.valueHelp: 'C_MM_RegionValueHelp'
      @ObjectModel.text.element: ['RegionName']
      I_PurOrdItemDeliveryAddress._Address_2.Region,
      @UI.fieldGroup: [ { position: 10, qualifier: 'DeliveryAddress3' } ]
      @Consumption.valueHelp: 'C_MM_CountryValueHelp'
      @ObjectModel.text.element: ['CountryName']
      I_PurOrdItemDeliveryAddress._Address_2.Country,
      @UI.hidden: true
      @ObjectModel.readOnly: true
      PurOrdDeliveryAddressTP.CountryName,
      @UI.hidden: true
      @ObjectModel.readOnly: true
      PurOrdDeliveryAddressTP.RegionName,
      _PurchaseOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_PURORDDELIVERYADDRESSTP",
"I_ADDRCURDEFAULTFAXNUMBER",
"I_ADDRESS_2",
"I_PURORDITEMDELIVERYADDRESS"
],
"ASSOCIATED":
[
"C_PURORDDELIVERYADDRESSTP",
"I_PURCHASEORDER"
],
"BASE":
[
"I_PURORDITEMDELIVERYADDRESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/