I_BPCustPartnerFunctionsProcTP

DDL: I_BPCUSTPARTNERFUNCTIONSPROCTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO
34 Fields 1 Data Sources 8 Associations

BP Customer Partner Functions Data - TP

I_BPCustPartnerFunctionsProcTP is a Transactional CDS View that provides data about "BP Customer Partner Functions Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustPartnerFunctionsProc) and exposes 34 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 8 associations to related views. Part of development package MDC_CUST_STAGING_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPCustPartnerFunctionsProc I_BPCustPartnerFunctionsProc from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_BPProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[1..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction
[0..1] I_ContactPerson _ContactPerson $projection.ContactPerson = _ContactPerson.ContactPerson
[0..1] I_PersonWorkAgreement_1 _PersonWorkAgreement $projection.PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement
[0..1] I_Customer _ReferenceCustomer $projection.BPCustomerNumber = _ReferenceCustomer.Customer
[0..1] I_Supplier _ReferenceSupplier $projection.Supplier = _ReferenceSupplier.Supplier

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Partner Functions Data - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Division Division Internal Division ID
KEY PartnerFunction PartnerFunction Partner Functn
KEY PartnerCounter PartnerCounter Partner counter
KEY BPAssignmentID BPAssignmentID Assignment ID
Customer Customer Sold-to Party
PartnerFunctionType PartnerFunctionType Partner Type
PartnerFunctionPartnerNumber PartnerFunctionPartnerNumber Ref. to suplr
BPCustomerNumber BPCustomerNumber Customer
Supplier Supplier Supplier
PersonnelNumber PersonnelNumber Personnel No.
ContactPerson ContactPerson Contact Person Key
CustomerPartnerDescription CustomerPartnerDescription Partner desc.
DefaultPartner DefaultPartner Default Partner
AddressID AddressID Ship-to address
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime Last Changed On
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary Modification
_CustomerSalesArea _CustomerSalesArea
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_RecordMessages _RecordMessages
_KPIUpdateStatusText _KPIUpdateStatusText
_PartnerFunction _PartnerFunction
_ReferenceCustomer _ReferenceCustomer
_ReferenceSupplier _ReferenceSupplier
_ContactPerson _ContactPerson
_PersonWorkAgreement _PersonWorkAgreement

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_BPCustPartnerFunctionsProcTP.
-- 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_BPCustPartnerFunctionsProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  SalesOrganization,
  DistributionChannel,
  Division,
  PartnerFunction,
  PartnerCounter,
  BPAssignmentID,
  Customer,
  PartnerFunctionType,
  PartnerFunctionPartnerNumber,
  BPCustomerNumber,
  Supplier,
  PersonnelNumber,
  ContactPerson,
  CustomerPartnerDescription,
  DefaultPartner,
  AddressID,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary
FROM I_BPCustPartnerFunctionsProc
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChgProcRecordMessages AS _RecordMessages ON MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess AND MDChgProcessStep = _RecordMessages.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [1..1]
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON ContactPerson = _ContactPerson.ContactPerson  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ReferenceCustomer ON BPCustomerNumber = _ReferenceCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ReferenceSupplier ON Supplier = _ReferenceSupplier.Supplier  -- association [0..1]
;

Learn More