P_SalesDocumentPartnerObsolete

DDL: P_SALESDOCUMENTPARTNEROBSOLETE Type: view BASIC Package: VDM_SD_SLS

Sls Doc Part - Delaware SLT Data Rplctn

P_SalesDocumentPartnerObsolete is a Basic CDS View that provides data about "Sls Doc Part - Delaware SLT Data Rplctn" in SAP S/4HANA. It reads from 2 data sources (I_SDDocumentPartner, I_SalesDocumentBasic) and exposes 17 fields with key fields SalesDocument, PartnerFunction. It has 1 association to related views. Part of development package VDM_SD_SLS.

Data Sources (2)

SourceAliasJoin Type
I_SDDocumentPartner Partner from
I_SalesDocumentBasic SalesDocument inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #NONE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName PSDSLSDOCPTOBSL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Sls Doc Part - Delaware SLT Data Rplctn view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument
KEY PartnerFunction I_SDDocumentPartner PartnerFunction
Customer I_SDDocumentPartner Customer
Supplier I_SDDocumentPartner Supplier
Personnel I_SDDocumentPartner Personnel
AddressID I_SDDocumentPartner AddressID
AddressPersonID I_SDDocumentPartner AddressPersonID
AddressObjectType I_SDDocumentPartner AddressObjectType
SDDocPartnerAddressRefType I_SDDocumentPartner SDDocPartnerAddressRefType
BPAddrDeterminationTransaction I_SDDocumentPartner BPAddrDeterminationTransaction
BPRefAddressIDForDocSpcfcAddr I_SDDocumentPartner BPRefAddressIDForDocSpcfcAddr
ContactPerson I_SDDocumentPartner ContactPerson
ReferenceBusinessPartner I_SDDocumentPartner ReferenceBusinessPartner
VATRegistration I_SDDocumentPartner VATRegistration
UnloadingPointName I_SDDocumentPartner UnloadingPointName
SDDocumentCategory I_SalesDocumentBasic SDDocumentCategory
_SalesDocument _SalesDocument
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  private: true,
  viewType: #BASIC,
  lifecycle.contract.type: #NONE
}

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@AbapCatalog: {
  sqlViewName: 'PSDSLSDOCPTOBSL',
  preserveKey: true,
  compiler.compareFilter: true
}

@ObjectModel: {
  representativeKey: 'PartnerFunction',
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #B,
    sizeCategory: #XL
  },
  supportedCapabilities: [ #SQL_DATA_SOURCE ]
}

@Metadata.ignorePropagatedAnnotations:true

@EndUserText.label: 'Sls Doc Part - Delaware SLT Data Rplctn'
define view P_SalesDocumentPartnerObsolete
  as select from I_SDDocumentPartner as Partner
  
  inner join     I_SalesDocumentBasic   as SalesDocument  on SalesDocument.SalesDocument = Partner.SDDocument
  
  association [1..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument  
   
{

  key cast(Partner.SDDocument as vbeln_va preserving type) as SalesDocument,

  key Partner.PartnerFunction,

      Partner.Customer,

      Partner.Supplier,

      Partner.Personnel,

      Partner.AddressID,

      Partner.AddressPersonID,

      Partner.AddressObjectType,

      Partner.SDDocPartnerAddressRefType,

      Partner.BPAddrDeterminationTransaction,

      Partner.BPRefAddressIDForDocSpcfcAddr,

      Partner.ContactPerson,

      Partner.ReferenceBusinessPartner,

      Partner.VATRegistration,

      @Semantics.text: true
      Partner.UnloadingPointName,

      SalesDocument.SDDocumentCategory,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]    
      _SalesDocument
}