I_BPSuplrPartnerFunctionProc

DDL: I_BPSUPLRPARTNERFUNCTIONPROC Type: view_entity BASIC Package: MDC_SUPPL_STAGING_BO
21 Fields 1 Data Sources 2 Associations

BP Supplier Partner Function Proc Data

I_BPSuplrPartnerFunctionProc is a Basic CDS View that provides data about "BP Supplier Partner Function Proc Data" in SAP S/4HANA. It reads from 1 data source (wyt3_prc) and exposes 21 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, PurchasingOrganization. It has 2 associations to related views. Part of development package MDC_SUPPL_STAGING_BO.

Data Sources (1)

SourceAliasJoin Type
wyt3_prc wyt3_prc from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BPSupplierProcess _Supplier wyt3_prc.process_id = _Supplier.MasterDataChangeProcess and wyt3_prc.process_step_no = _Supplier.MDChgProcessStep and wyt3_prc.source_system = _Supplier.MDChgProcessSrceSystem and wyt3_prc.source_id = _Supplier.MDChgProcessSrceObject
[1..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Supplier Partner Function Proc Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess wyt3_prc process_id Process Instance ID
KEY MDChgProcessStep wyt3_prc process_step_no Step Number
KEY MDChgProcessSrceSystem wyt3_prc source_system Source System
KEY MDChgProcessSrceObject wyt3_prc source_id UUID
KEY PurchasingOrganization wyt3_prc ekorg Purchasing Org.
KEY SupplierSubrange wyt3_prc ltsnr Suppl. Subrange
KEY Plant wyt3_prc werks Receiving Plant
KEY PartnerFunction
KEY PartnerCounter wyt3_prc parza Partner counter
KEY BPAssignmentID wyt3_prc assignment_id Assignment ID
DefaultPartner wyt3_prc defpa Default Partner
PersonnelNumber wyt3_prc pernr Personnel no.
ContactPerson wyt3_prc parnr Responsible
MDChgProcSrceLastChgdDateTime wyt3_prc source_recency Last Changed On
MDChgProcessSourceModified wyt3_prc source_modified Modified
MDChgProcessSourceModifBinary wyt3_prc source_modification_blip Modification
Supplier wyt3_prc lifnr Vendor no.
ReferenceSupplier wyt3_prc lifn2 Ref. to suplr
PartnerFunctionType tpar nrart Partner Type
_PartnerFunction _PartnerFunction
_Supplier _Supplier

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BPSuplrPartnerFunctionProc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BPSuplrPartnerFunctionProc AS
SELECT
  wyt3_prc.process_id AS MasterDataChangeProcess,
  wyt3_prc.process_step_no AS MDChgProcessStep,
  wyt3_prc.source_system AS MDChgProcessSrceSystem,
  wyt3_prc.source_id AS MDChgProcessSrceObject,
  wyt3_prc.ekorg AS PurchasingOrganization,
  wyt3_prc.ltsnr AS SupplierSubrange,
  wyt3_prc.werks AS Plant,
  cast(wyt3_prc.parvw as parvw_unv) AS PartnerFunction,
  wyt3_prc.parza AS PartnerCounter,
  wyt3_prc.assignment_id AS BPAssignmentID,
  wyt3_prc.defpa AS DefaultPartner,
  wyt3_prc.pernr AS PersonnelNumber,
  wyt3_prc.parnr AS ContactPerson,
  wyt3_prc.source_recency AS MDChgProcSrceLastChgdDateTime,
  wyt3_prc.source_modified AS MDChgProcessSourceModified,
  wyt3_prc.source_modification_blip AS MDChgProcessSourceModifBinary,
  wyt3_prc.lifnr AS Supplier,
  wyt3_prc.lifn2 AS ReferenceSupplier,
  tpar.nrart AS PartnerFunctionType
FROM wyt3_prc
LEFT OUTER JOIN I_BPSupplierProcess AS _Supplier ON wyt3_prc.process_id = _Supplier.MasterDataChangeProcess AND wyt3_prc.process_step_no = _Supplier.MDChgProcessStep AND wyt3_prc.source_system = _Supplier.MDChgProcessSrceSystem AND wyt3_prc.source_id = _Supplier.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [1..1]
;

Learn More