I_BPCustPartnerFunctionsProc

DDL: I_BPCUSTPARTNERFUNCTIONSPROC Type: view_entity BASIC
23 Fields 2 Data Sources 1 Associations

BP Customer Partner Functions Data

I_BPCustPartnerFunctionsProc is a Basic CDS View that provides data about "BP Customer Partner Functions Data" in SAP S/4HANA. It reads from 2 data sources (knvp_prc, tpar) and exposes 23 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
knvp_prc knvp_prc from
tpar tpar inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BPCustomerProcess _Customer $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject and $projection.BPAssignmentID = _Customer.BPAssignmentID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Partner Functions 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 (23)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess knvp_prc process_id Process Instance ID
KEY MDChgProcessStep knvp_prc process_step_no Step Number
KEY MDChgProcessSrceSystem knvp_prc source_system Source System
KEY MDChgProcessSrceObject knvp_prc source_id UUID
KEY SalesOrganization knvp_prc vkorg SD Sales Org.
KEY DistributionChannel knvp_prc vtweg RefDistCh-Cust/Mat.
KEY Division knvp_prc spart Source supplier
KEY PartnerFunction
KEY PartnerCounter knvp_prc parza Partner counter
KEY BPAssignmentID knvp_prc assignment_id Assignment ID
Customer knvp_prc kunnr Stock customer
PartnerFunctionType tpar nrart Partner Type
BPCustomerNumber knvp_prc kunn2 Customer
Supplier knvp_prc lifnr Vendor no.
PersonnelNumber knvp_prc pernr Personnel no.
ContactPerson knvp_prc parnr Responsible
CustomerPartnerDescription knvp_prc knref Partner Desc.
DefaultPartner knvp_prc defpa Default Partner
AddressID knvp_prc adrnr Sold-To Address
MDChgProcSrceLastChgdDateTime knvp_prc source_recency Last Changed On
MDChgProcessSourceModified knvp_prc source_modified Modified
MDChgProcessSourceModifBinary knvp_prc source_modification_blip Modification
_Customer _Customer

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_BPCustPartnerFunctionsProc.
-- 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_BPCustPartnerFunctionsProc AS
SELECT
  knvp_prc.process_id AS MasterDataChangeProcess,
  knvp_prc.process_step_no AS MDChgProcessStep,
  knvp_prc.source_system AS MDChgProcessSrceSystem,
  knvp_prc.source_id AS MDChgProcessSrceObject,
  knvp_prc.vkorg AS SalesOrganization,
  knvp_prc.vtweg AS DistributionChannel,
  knvp_prc.spart AS Division,
  cast(knvp_prc.parvw as parvw_unv) AS PartnerFunction,
  knvp_prc.parza AS PartnerCounter,
  knvp_prc.assignment_id AS BPAssignmentID,
  knvp_prc.kunnr AS Customer,
  tpar.nrart AS PartnerFunctionType,
  knvp_prc.kunn2 AS BPCustomerNumber,
  knvp_prc.lifnr AS Supplier,
  knvp_prc.pernr AS PersonnelNumber,
  knvp_prc.parnr AS ContactPerson,
  knvp_prc.knref AS CustomerPartnerDescription,
  knvp_prc.defpa AS DefaultPartner,
  knvp_prc.adrnr AS AddressID,
  knvp_prc.source_recency AS MDChgProcSrceLastChgdDateTime,
  knvp_prc.source_modified AS MDChgProcessSourceModified,
  knvp_prc.source_modification_blip AS MDChgProcessSourceModifBinary
FROM knvp_prc
INNER JOIN tpar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BPCustomerProcess AS _Customer ON MasterDataChangeProcess = _Customer.MasterDataChangeProcess AND MDChgProcessStep = _Customer.MDChgProcessStep AND MDChgProcessSrceSystem = _Customer.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Customer.MDChgProcessSrceObject AND BPAssignmentID = _Customer.BPAssignmentID  -- association [0..1]
;

Learn More