P_SDDocumentCompletePartners_1

DDL: P_SDDOCUMENTCOMPLETEPARTNERS_1 Type: view BASIC

P_SDDocumentCompletePartners_1 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (vbpa) and exposes 24 fields with key fields SDDocument, SDDocumentItem, PartnerFunction.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
vbpa vbpa from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDDOCCMPLTPART1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #BASIC view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SDDocument vbpa vbeln
KEY SDDocumentItem vbpa posnr
KEY PartnerFunction vbpa parvw
Customer vbpa kunnr
Supplier vbpa lifnr
Personnel vbpa pernr
ContactPerson vbpa parnr
ReferenceBusinessPartner vbpa assigned_bp
AddressID vbpa adrnr
AddressPersonID vbpa adrnp
SDDocPartnerAddressRefType vbpa adrda
AddressObjectType vbpa addr_type
BPAddrDeterminationTransaction vbpa addr_operation
BPRefAddressIDForDocSpcfcAddr vbpa bp_ref_adrnr
PartnerIsOneTimeAccount vbpa xcpdk
VATRegistration vbpa stceg
UnloadingPointName vbpa ablad
CountryCode vbpa land1
CustomerHierarchyType vbpa hityp
CustIsPrcDetnRlvt vbpa prfre
CustomerIsRebateRelevant vbpa bokre
CustomerHierarchyLevel vbpa histunr
CustomerHierarchyFixedLevel vbpa hzuor
TransportZone vbpa lzone 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'PSDDOCCMPLTPART1',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   }
}
@VDM.private: true
@VDM.viewType: #BASIC

define view P_SDDocumentCompletePartners_1
as
select from vbpa
{
  key vbpa.vbeln as SDDocument,
  key vbpa.posnr as SDDocumentItem,
  key vbpa.parvw as PartnerFunction,

  vbpa.kunnr as Customer,
  vbpa.lifnr as Supplier,
  vbpa.pernr as Personnel,
  vbpa.parnr as ContactPerson,

  vbpa.assigned_bp as ReferenceBusinessPartner,

  vbpa.adrnr as AddressID,
  vbpa.adrnp as AddressPersonID,
  vbpa.adrda as SDDocPartnerAddressRefType,
  vbpa.addr_type as AddressObjectType,
  vbpa.addr_operation as BPAddrDeterminationTransaction,
  vbpa.bp_ref_adrnr as BPRefAddressIDForDocSpcfcAddr,

  cast(
    case vbpa.adrda
      when 'E' then 'X'
      when 'F' then 'X'
      else ' '
  end as sd_pd_doc_spec_addr_flag) as SDDocPartnerAddrIsDocSpecific,

  vbpa.xcpdk as PartnerIsOneTimeAccount,
  vbpa.stceg as VATRegistration,
  vbpa.ablad as UnloadingPointName,

  vbpa.land1 as CountryCode,
  vbpa.hityp as CustomerHierarchyType,
  vbpa.prfre as CustIsPrcDetnRlvt,
  vbpa.bokre as CustomerIsRebateRelevant,
  vbpa.histunr as CustomerHierarchyLevel,
  vbpa.hzuor   as CustomerHierarchyFixedLevel,
  vbpa.lzone   as TransportZone
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBPA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More