I_BUSPARTRELATIONSHIPPROCESS
Core Business Partner Relationship Proc
I_BUSPARTRELATIONSHIPPROCESS is a CDS View in S/4HANA. Core Business Partner Relationship Proc. It contains 40 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BPCntctPersnEmlAddrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Address Email Process Changes |
| I_BPCntctPersnFaxNmbrProcChgs | view_entity | inner | TRANSACTIONAL | CntctPrsn WrkplceAddr FaxNmbr Proc Chngs |
| I_BPCntctPersnMblNmbrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Addr Mobile Phone Proc Changes |
| I_BPCntctPersnTelNmbrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Addr Telephone Proc Changes |
| I_BPCntctPersnWbsteURLProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person Workplace Address Website Process Changes |
| I_BPContactPersonAddrProcChgs | view_entity | inner | TRANSACTIONAL | BP Contact Person WplcAddr Process Chgs |
| I_BPRelshpTmeDpndcyProcChgs | view_entity | inner | TRANSACTIONAL | BP Relationship Time Dependency Process Changes |
| I_BusPartContactPersonProcChgs | view_entity | inner | TRANSACTIONAL | BP Relationship Contact Person Process Changes |
| I_BusPartRelationshipGov | view_entity | from | COMPOSITE | Business Partner Relationship Governance |
| I_BusPartRelationshipGov | view_entity | union_all | COMPOSITE | Business Partner Relationship Governance |
| I_BusPartRelationshipProcessTP | view_entity | from | TRANSACTIONAL | BP Relationship Process Data - TP |
| I_BusPartRelshpProcessChanges | view | from | TRANSACTIONAL | Business Partner Process Changes |
| I_BusPartRelshpProcessChanges | view | union_all | TRANSACTIONAL | Business Partner Process Changes |
| P_BusPartGovRelationshipList | view_entity | from | BASIC | Base list for all Relationships of BP |
Fields (40)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MasterDataChangeProcess | MasterDataChangeProcess | 4 |
| KEY | MDChgProcessSrceBusPart1 | BusinessPartner1,BusinessPartner2,MDChgProcessSrceBusPart1 | 12 |
| KEY | MDChgProcessSrceBusPart2 | BusinessPartner1,BusinessPartner2,MDChgProcessSrceBusPart2 | 12 |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | 4 |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | 4 |
| KEY | MDChgProcessStep | MDChgProcessStep | 4 |
| KEY | RelationshipCategory | RelationshipCategory | 11 |
| _BusinessPartner1 | _BusinessPartner1 | 1 | |
| _BusinessPartner2 | _BusinessPartner2 | 1 | |
| BP1AuthorizationGroup | BP1AuthorizationGroup | 11 | |
| BP1DataController1 | BP1DataController1,BP2DataController1 | 9 | |
| BP1DataController10 | BP1DataController10,BP2DataController10 | 9 | |
| BP1DataController2 | BP1DataController2,BP2DataController2 | 9 | |
| BP1DataController3 | BP1DataController3,BP2DataController3 | 9 | |
| BP1DataController4 | BP1DataController4,BP2DataController4 | 9 | |
| BP1DataController5 | BP1DataController5,BP2DataController5 | 9 | |
| BP1DataController6 | BP1DataController6,BP2DataController6 | 9 | |
| BP1DataController7 | BP1DataController7,BP2DataController7 | 9 | |
| BP1DataController8 | BP1DataController8,BP2DataController8 | 9 | |
| BP1DataController9 | BP1DataController9,BP2DataController9 | 9 | |
| BP1DataControllerSet | BP1DataControllerSet,BP2DataControllerSet | 9 | |
| BP2AuthorizationGroup | BP1AuthorizationGroup,BP2AuthorizationGroup | 10 | |
| BP2DataController1 | BP1DataController1,BP2DataController1 | 9 | |
| BP2DataController10 | BP1DataController10,BP2DataController10 | 9 | |
| BP2DataController2 | BP1DataController2,BP2DataController2 | 9 | |
| BP2DataController3 | BP1DataController3,BP2DataController3 | 9 | |
| BP2DataController4 | BP1DataController4,BP2DataController4 | 9 | |
| BP2DataController5 | BP1DataController5,BP2DataController5 | 9 | |
| BP2DataController6 | BP1DataController6,BP2DataController6 | 9 | |
| BP2DataController7 | BP1DataController7,BP2DataController7 | 9 | |
| BP2DataController8 | BP1DataController8,BP2DataController8 | 9 | |
| BP2DataController9 | BP1DataController9,BP2DataController9 | 9 | |
| BP2DataControllerSet | BP1DataControllerSet,BP2DataControllerSet | 9 | |
| BPRelshpCatIsInFwdDirection | BPRelshpCatIsInFwdDirection | 10 | |
| BusinessPartner1 | BusinessPartner1 | 9 | |
| BusinessPartner2 | BusinessPartner2 | 9 | |
| BusinessPartnerCategory | BusinessPartnerCategory | 1 | |
| MDChgProcessSourceModifBinary | MDChgProcessSourceModifBinary | 1 | |
| MDChgProcessSourceModified | MDChgProcessSourceModified | 2 | |
| MDChgProcessValidationStatus | MDChgProcessValidationStatus | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Core Business Partner Relationship Proc
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSPARTRELATIONSHIPPROCESS (
MASTERDATACHANGEPROCESS,
MDCHGPROCESSSRCEBUSPART1,
MDCHGPROCESSSRCEBUSPART2,
MDCHGPROCESSSRCEOBJECT,
MDCHGPROCESSSRCESYSTEM,
MDCHGPROCESSSTEP,
RELATIONSHIPCATEGORY,
_BUSINESSPARTNER1,
_BUSINESSPARTNER2,
BP1AUTHORIZATIONGROUP,
BP1DATACONTROLLER1,
BP1DATACONTROLLER10,
BP1DATACONTROLLER2,
BP1DATACONTROLLER3,
BP1DATACONTROLLER4,
BP1DATACONTROLLER5,
BP1DATACONTROLLER6,
BP1DATACONTROLLER7,
BP1DATACONTROLLER8,
BP1DATACONTROLLER9,
BP1DATACONTROLLERSET,
BP2AUTHORIZATIONGROUP,
BP2DATACONTROLLER1,
BP2DATACONTROLLER10,
BP2DATACONTROLLER2,
BP2DATACONTROLLER3,
BP2DATACONTROLLER4,
BP2DATACONTROLLER5,
BP2DATACONTROLLER6,
BP2DATACONTROLLER7,
BP2DATACONTROLLER8,
BP2DATACONTROLLER9,
BP2DATACONTROLLERSET,
BPRELSHPCATISINFWDDIRECTION,
BUSINESSPARTNER1,
BUSINESSPARTNER2,
BUSINESSPARTNERCATEGORY,
MDCHGPROCESSSOURCEMODIFBINARY,
MDCHGPROCESSSOURCEMODIFIED,
MDCHGPROCESSVALIDATIONSTATUS,
PRIMARY KEY (MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCEBUSPART1, MDCHGPROCESSSRCEBUSPART2, MDCHGPROCESSSRCEOBJECT, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSTEP, RELATIONSHIPCATEGORY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA