R_ChgRecdBusinessPartner

DDL: R_CHGRECDBUSINESSPARTNER Type: view_entity COMPOSITE

Change Record Business Partner

R_ChgRecdBusinessPartner is a Composite CDS View that provides data about "Change Record Business Partner" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner_to_BP_Role, I_BusinessPartner) and exposes 5 fields with key field Partner.

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner_to_BP_Role BusinessPartnerToBPRole inner
I_BusinessPartner I_BusinessPartner from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Change Record Business Partner view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Feature BF:API_FULLSCOPE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Partner I_BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory Partner Cat.
AuthorizationGroup I_BusinessPartner AuthorizationGroup AuthorizGroup
BusinessPartnerIsBlocked I_BusinessPartner BusinessPartnerIsBlocked Central Block
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted Purpose Completed

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 R_ChgRecdBusinessPartner.
-- 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 R_ChgRecdBusinessPartner AS
SELECT
  I_BusinessPartner.BusinessPartner AS Partner,
  I_BusinessPartner.BusinessPartnerCategory AS BusinessPartnerCategory,
  I_BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  I_BusinessPartner.BusinessPartnerIsBlocked AS BusinessPartnerIsBlocked,
  I_BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_BusinessPartner
INNER JOIN I_BusinessPartner_to_BP_Role AS BusinessPartnerToBPRole ON /* join condition not captured in parsed metadata */
;