R_CustRetDelivItemSerialNmbrTP

DDL: R_CUSTRETDELIVITEMSERIALNMBRTP Type: view_entity TRANSACTIONAL

Customer Returns Deliv Item SrlNmbr - TP

R_CustRetDelivItemSerialNmbrTP is a Transactional CDS View that provides data about "Customer Returns Deliv Item SrlNmbr - TP" in SAP S/4HANA. It reads from 1 data source (I_SerialNumberDeliveryDocument) and exposes 7 fields with key fields CustomerReturnDelivery, CustomerReturnDeliveryItem, SerialNumber. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SerialNumberDeliveryDocument CustomerReturnsDelivSerialNmbr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_CustomerReturnsDeliveryTP _Delivery $projection.CustomerReturnDelivery = _Delivery.CustomerReturnDelivery

Annotations (9)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey SerialNumber view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Customer Returns Deliv Item SrlNmbr - TP view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturnDelivery DeliveryDocument
KEY CustomerReturnDeliveryItem DeliveryDocumentItem
KEY SerialNumber SerialNumber
Equipment Equipment
Material Material
_Item _Item
_Delivery _Delivery 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

@ObjectModel: {
    usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #A,
        sizeCategory:   #XL
    },
    semanticKey: ['CustomerReturnDelivery', 'CustomerReturnDeliveryItem', 'SerialNumber'],
    representativeKey: 'SerialNumber'
}
@Metadata.ignorePropagatedAnnotations: true

@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Customer Returns Deliv Item SrlNmbr - TP'
define view entity R_CustRetDelivItemSerialNmbrTP
  as select from I_SerialNumberDeliveryDocument as CustomerReturnsDelivSerialNmbr

  association to parent R_CustomerReturnsDelivItemTP as _Item     on  $projection.CustomerReturnDelivery     = _Item.CustomerReturnDelivery
                                                                  and $projection.CustomerReturnDeliveryItem = _Item.CustomerReturnDeliveryItem
                                                              
  association [1..1] to R_CustomerReturnsDeliveryTP  as _Delivery on  $projection.CustomerReturnDelivery     = _Delivery.CustomerReturnDelivery
{
      @ObjectModel.foreignKey.association: '_Delivery'
  key DeliveryDocument as CustomerReturnDelivery,
      @ObjectModel.foreignKey.association: '_Item'
  key DeliveryDocumentItem as CustomerReturnDeliveryItem,
  key SerialNumber,
      
      Equipment,
      Material,

      //Associations

      _Item,
      _Delivery
}
where
  _Delivery.SDDocumentCategory = 'T';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERIALNUMBERDELIVERYDOCUMENT",
"R_CUSTOMERRETURNSDELIVERYTP"
],
"ASSOCIATED":
[
"R_CUSTOMERRETURNSDELIVERYTP",
"R_CUSTOMERRETURNSDELIVITEMTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More