A_InbDeliveryPartner_1

DDL: A_INBDELIVERYPARTNER_1 SQL: AINBDELIVERYP1 Type: view BASIC

CDS View for Business Partner

A_InbDeliveryPartner_1 is a Basic CDS View that provides data about "CDS View for Business 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_InbDeliveryHeader_1 _DeliveryDocumentHeader _DeliveryDocumentHeader.DeliveryDocument = $projection.SDDocument
[1..1] A_InbDeliveryAddress _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 AINBDELIVERYP1 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 CDS View for Business 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: 'AINBDELIVERYP1'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label:  'CDS View for Business 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_InbDeliveryPartner_1 as select from I_SDDocumentCompletePartners 
association [1..1] to A_InbDeliveryHeader_1 as _DeliveryDocumentHeader on _DeliveryDocumentHeader.DeliveryDocument = $projection.SDDocument
association [1..1] to A_InbDeliveryAddress 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,
    @ObjectModel.sapObjectNodeTypeReference: 'PartnerFunction'
    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
}
where _DeliveryDocumentHeader.SDDocumentCategory = '7'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_INBDELIVERYHEADER_1",
"I_SDDOCUMENTCOMPLETEPARTNERS"
],
"ASSOCIATED":
[
"A_CUSTOMER",
"A_INBDELIVERYADDRESS",
"A_INBDELIVERYHEADER_1",
"A_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More