A_CrdtMemoReqItemPartnerSimln

DDL: A_CRDTMEMOREQITEMPARTNERSIMLN Type: view_entity COMPOSITE

Item Partner Simulation

A_CrdtMemoReqItemPartnerSimln is a Composite CDS View that provides data about "Item Partner Simulation" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_SDDocumentItemPartner) and exposes 13 fields with key fields CreditMemoRequest, CreditMemoRequestItem, PartnerFunction. It has 1 association to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CreditMemoRequest inner
I_SDDocumentItemPartner Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_CreditMemoRequestSimulation _CreditMemoRequest $projection.CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest

Annotations (8)

NameValueLevelField
EndUserText.label Item Partner Simulation view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest I_SDDocumentItemPartner SDDocument
KEY CreditMemoRequestItem I_SDDocumentItemPartner SDDocumentItem
KEY PartnerFunction
Customer I_SDDocumentItemPartner Customer
Supplier I_SDDocumentItemPartner Supplier
Personnel I_SDDocumentItemPartner Personnel
ContactPerson I_SDDocumentItemPartner ContactPerson
CreditMemoRequestType I_SalesDocumentBasic SalesDocumentType
OrganizationDivision I_SalesDocumentBasic OrganizationDivision
SalesOrganization I_SalesDocumentBasic SalesOrganization
DistributionChannel I_SalesDocumentBasic DistributionChannel
_CreditMemoRequest _CreditMemoRequest
_CreditMemoRequestItem _CreditMemoRequestItem 
@EndUserText.label: 'Item Partner Simulation'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view entity A_CrdtMemoReqItemPartnerSimln
  as select from I_SDDocumentItemPartner as Partner
    inner join   I_SalesDocumentBasic    as CreditMemoRequest on  CreditMemoRequest.SalesDocument      = Partner.SDDocument
                                                              and CreditMemoRequest.SDDocumentCategory = 'K'
  association [1..1] to A_CreditMemoRequestSimulation        as _CreditMemoRequest        on  $projection.CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest
  association        to parent A_CreditMemoReqItemSimulation as _CreditMemoRequestItem    on  $projection.CreditMemoRequest     = _CreditMemoRequestItem.CreditMemoRequest
                                                                                          and $projection.CreditMemoRequestItem = _CreditMemoRequestItem.CreditMemoRequestItem

//  association [0..1] to I_BusPartAddress                     as _BusinessPartnerAddressCP on  Partner.AddressID                  = _BusinessPartnerAddressCP.AddressID

//                                                                                          and $projection.ContactPerson          is not initial

//                                                                                          and Partner.SDDocPartnerAddressRefType = 'I'


{
      @ObjectModel.readOnly: true
  key Partner.SDDocument                                as CreditMemoRequest,

      @ObjectModel.readOnly: true
  key Partner.SDDocumentItem                            as CreditMemoRequestItem,
      @ObjectModel.sapObjectNodeTypeReference: 'PartnerFunction'
      @ObjectModel.mandatory: true
  key cast(Partner.PartnerFunction as parvw_unv) as PartnerFunction,

      Partner.Customer,

      Partner.Supplier,

      Partner.Personnel,

      Partner.ContactPerson,

//      @Feature: 'SW:Q2C_MULTIPLE_BP_ADDRESSES, SW:Q2C_MULTIPLE_BP_ADDRESSES2'

//      case Partner.ContactPerson

//        when '0000000000' then

//         Partner._BusinessPartnerAddress.AddressUUID

//       else

//         _BusinessPartnerAddressCP.AddressUUID

//                                                    end as BusinessPartnerAddressUUID,

//

//      @Feature: 'SW:Q2C_MULTIPLE_BP_ADDRESSES, SW:Q2C_MULTIPLE_BP_ADDRESSES2'

//      @ObjectModel.readOnly: true

//      Partner._BPRefAddressForDocSpcfcAddr.AddressUUID  as BPRefAddrForDocSpcfcAddrUUID,


      // For Access control

      @Consumption.hidden: true
      CreditMemoRequest.SalesDocumentType               as CreditMemoRequestType,
      @Consumption.hidden: true
      CreditMemoRequest.OrganizationDivision,
      @Consumption.hidden: true
      CreditMemoRequest.SalesOrganization,
      @Consumption.hidden: true
      CreditMemoRequest.DistributionChannel,

      //Expose associations

      _CreditMemoRequest,
      _CreditMemoRequestItem
} where Partner.SDDocument = '0' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTBASIC",
"I_SDDOCUMENTITEMPARTNER"
],
"ASSOCIATED":
[
"A_CREDITMEMOREQITEMSIMULATION",
"A_CREDITMEMOREQUESTSIMULATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More