P_SDDOCUMENTCOMPLETEPARTNERS

CDS View

P_SDDOCUMENTCOMPLETEPARTNERS is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SDDocumentCompletePartners view from BASIC SD Document Complete Partners 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'PSDDOCCMPLTPART',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   }
}
@VDM.private: true
@VDM.viewType: #BASIC

define view P_SDDocumentCompletePartners
as
select from P_SDDocumentCompletePartners_1 as SDPartner1
inner join P_VBPADataMigrationStatus as MigrationStatus1
  on MigrationStatus1.VBPADataMigrationStatus = 'F'
{
  key SDPartner1.SDDocument,
  key SDPartner1.SDDocumentItem,
  key SDPartner1.PartnerFunction,

  SDPartner1.Customer,
  SDPartner1.Supplier,
  SDPartner1.Personnel,
  SDPartner1.ContactPerson,

  SDPartner1.ReferenceBusinessPartner,

  SDPartner1.AddressID,
  SDPartner1.AddressPersonID,
  SDPartner1.SDDocPartnerAddressRefType,
  SDPartner1.AddressObjectType,
  SDPartner1.BPAddrDeterminationTransaction,
  SDPartner1.BPRefAddressIDForDocSpcfcAddr,
  SDPartner1.SDDocPartnerAddrIsDocSpecific,

  SDPartner1.PartnerIsOneTimeAccount,
  SDPartner1.VATRegistration,
  SDPartner1.UnloadingPointName,

  SDPartner1.CountryCode,
  SDPartner1.CustomerHierarchyType,
  SDPartner1.CustIsPrcDetnRlvt,
  SDPartner1.CustomerIsRebateRelevant,
  SDPartner1.CustomerHierarchyLevel,
  SDPartner1.CustomerHierarchyFixedLevel,
  SDPartner1.TransportZone,

  MigrationStatus1.VBPADataMigrationStatus
}

union all

select from P_SDDocumentCompletePartners_2 as SDPartner2
inner join P_VBPADataMigrationStatus as MigrationStatus2
  on MigrationStatus2.VBPADataMigrationStatus = 'X'
{
  key SDPartner2.SDDocument,
  key SDPartner2.SDDocumentItem,
  key SDPartner2.PartnerFunction,

  SDPartner2.Customer,
  SDPartner2.Supplier,
  SDPartner2.Personnel,
  SDPartner2.ContactPerson,

  SDPartner2.ReferenceBusinessPartner,

  SDPartner2.AddressID,
  SDPartner2.AddressPersonID,
  SDPartner2.SDDocPartnerAddressRefType,
  SDPartner2.AddressObjectType,
  SDPartner2.BPAddrDeterminationTransaction,
  SDPartner2.BPRefAddressIDForDocSpcfcAddr,
  SDPartner2.SDDocPartnerAddrIsDocSpecific,

  SDPartner2.PartnerIsOneTimeAccount,
  SDPartner2.VATRegistration,
  SDPartner2.UnloadingPointName,

  SDPartner2.CountryCode,
  SDPartner2.CustomerHierarchyType,
  SDPartner2.CustIsPrcDetnRlvt,
  SDPartner2.CustomerIsRebateRelevant,
  SDPartner2.CustomerHierarchyLevel,
  SDPartner2.CustomerHierarchyFixedLevel,
  SDPartner2.TransportZone,

  MigrationStatus2.VBPADataMigrationStatus
};

Learn More