A_ReturnsDeliveryPartner

DDL: A_RETURNSDELIVERYPARTNER SQL: ARETSDELIVERYP Type: view BASIC

Returns Delivery Partner

A_ReturnsDeliveryPartner is a Basic CDS View that provides data about "Returns Delivery Partner" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentCompletePartners) and exposes 12 fields with key fields SDDocument, SDDocumentItem, PartnerFunction. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentCompletePartners I_SDDocumentCompletePartners from

Associations (4)

CardinalityTargetAliasCondition
[1..1] A_ReturnsDeliveryHeader _DeliveryDocumentHeader _DeliveryDocumentHeader.DeliveryDocument = $projection.SDDocument
[1..1] A_ReturnsDeliveryAddress _Address _Address.AddressID = $projection.AddressID
[0..1] A_Supplier _AuthSupplier $projection.Supplier = _AuthSupplier.Supplier
[0..1] A_Customer _AuthCustomer $projection.Customer = _AuthCustomer.Customer

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ARETSDELIVERYP view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Returns Delivery Partner view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SDDocument SDDocument
KEY SDDocumentItem SDDocumentItem
KEY PartnerFunction PartnerFunction
Customer Customer
Supplier Supplier
Personnel Personnel
AddressID AddressID
ContactPerson ContactPerson
_Address _Address
_DeliveryDocumentHeader _DeliveryDocumentHeader
_AuthSupplier _AuthSupplier
_AuthCustomer _AuthCustomer 
@AbapCatalog.sqlViewName: 'ARETSDELIVERYP'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@EndUserText.label: 'Returns Delivery Partner'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel: {
  usageType.dataClass: #MIXED,
  usageType.serviceQuality: #D,
  usageType.sizeCategory: #L
}

@AccessControl.privilegedAssociations:  [ '_Address' ]

/* !! Direct Exposure to Odata is not allowed with this view !! */

define view A_ReturnsDeliveryPartner as select from I_SDDocumentCompletePartners 

association [1..1] to A_ReturnsDeliveryHeader as _DeliveryDocumentHeader on _DeliveryDocumentHeader.DeliveryDocument = $projection.SDDocument
association [1..1] to A_ReturnsDeliveryAddress as _Address on _Address.AddressID = $projection.AddressID
association [0..1] to A_Supplier as _AuthSupplier on $projection.Supplier = _AuthSupplier.Supplier
association [0..1] to A_Customer as _AuthCustomer on $projection.Customer = _AuthCustomer.Customer

{
    key SDDocument,
    key SDDocumentItem,
    key PartnerFunction,
    Customer,
    Supplier,
    Personnel,
    AddressID,
    ContactPerson,
    
    /* Associations */
    _Address,
    @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,#TO_COMPOSITION_ROOT]
    _DeliveryDocumentHeader,
    
    //only for DCL

    @Consumption.hidden: true
    _AuthSupplier,
    @Consumption.hidden: true
    _AuthCustomer
    
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SDDOCUMENTCOMPLETEPARTNERS"
],
"ASSOCIATED":
[
"A_CUSTOMER",
"A_RETURNSDELIVERYADDRESS",
"A_RETURNSDELIVERYHEADER",
"A_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More