I_SubordinateCntrlContr

DDL: I_SUBORDINATECNTRLCONTR SQL: ISUBRODCCTR Type: view COMPOSITE Package: VDM_MM_PUR_CCTR
26 Fields 3 Data Sources 1 Associations

Basic View for Subordinate Central Contracts

I_SubordinateCntrlContr is a Composite CDS View that provides data about "Basic View for Subordinate Central Contracts" in SAP S/4HANA. It reads from 3 data sources (R_CentralPurchaseContract, I_SubordCntrlContrStaging, I_SubordCntrlContrStaging) and exposes 26 fields with key fields PurchasingParentDocument, SubordCntrlPurContract, ProcmtHubCompanyCodeGroupingID, SubordCntrlPurContract, ProcmtHubCompanyCodeGroupingID. It has 1 association to related views. Part of development package VDM_MM_PUR_CCTR.

Data Sources (3)

SourceAliasJoin Type
R_CentralPurchaseContract Original from
I_SubordCntrlContrStaging Temp left_outer
I_SubordCntrlContrStaging TempOnly union

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SubordCntrlContrHierLink _SubordCntrlContrHierLink _SubordCntrlContrHierLink.PurchasingParentDocument = $projection.PurchasingParentDocument and _SubordCntrlContrHierLink.SubordCntrlPurContract = $projection.SubordCntrlPurContract

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISUBRODCCTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
EndUserText.label Basic View for Subordinate Central Contracts view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PurchasingParentDocument R_CentralPurchaseContract PurchasingParentDocument Parent Document ID
KEY SubordCntrlPurContract R_CentralPurchaseContract ActivePurchasingDocument Purchasing Doc.
KEY ProcmtHubCompanyCodeGroupingID R_CentralPurchaseContract ProcmtHubCompanyCodeGroupingID Grouping ID
CompanyCode R_CentralPurchaseContract CompanyCode Receiver Company Code
PurchasingOrganization R_CentralPurchaseContract PurchasingOrganization Purchasing Organization
PurchasingGroup R_CentralPurchaseContract PurchasingGroup Purchasing Group
PurchaseContractType R_CentralPurchaseContract PurchaseContractType Order Type
PurchasingDocumentSubtype R_CentralPurchaseContract PurchasingDocumentSubtype Control
ValidityStartDate R_CentralPurchaseContract ValidityStartDate Validity Start Date
ValidityEndDate R_CentralPurchaseContract ValidityEndDate ValidTo
CntrlPurContrDescription R_CentralPurchaseContract PurchasingDocumentName Contract Name
SubordCntrlPurContrLastUpdtSts _SubordCntrlContrHierLink SubordCntrlPurContrLastUpdtSts
SubordCntrlContrLastUpdtDteTme _SubordCntrlContrHierLink SubordCntrlContrLastUpdtDteTme
KEY SubordCntrlPurContract SubordCntrlPurContract Purchasing Doc.
KEY ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseContractType PurchaseContractType Order Type
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CntrlPurContrDescription CntrlPurContrDescription Contract Name
SubordCntrlPurContrLastUpdtSts _SubordCntrlContrHierLink SubordCntrlPurContrLastUpdtSts
SubordCntrlContrLastUpdtDteTme _SubordCntrlContrHierLink SubordCntrlContrLastUpdtDteTme
DistrResponseMessageUUID _SubordCntrlContrHierLink DistrResponseMessageUUID GUID

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_SubordinateCntrlContr.
-- 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.
-- SQL view name: ISUBRODCCTR

CREATE VIEW I_SubordinateCntrlContr AS
SELECT
  Original.PurchasingParentDocument AS PurchasingParentDocument,
  Original.ActivePurchasingDocument AS SubordCntrlPurContract,
  Original.ProcmtHubCompanyCodeGroupingID AS ProcmtHubCompanyCodeGroupingID,
  Original.CompanyCode AS CompanyCode,
  Original.PurchasingOrganization AS PurchasingOrganization,
  Original.PurchasingGroup AS PurchasingGroup,
  Original.PurchaseContractType AS PurchaseContractType,
  Original.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  Original.ValidityStartDate AS ValidityStartDate,
  Original.ValidityEndDate AS ValidityEndDate,
  Original.PurchasingDocumentName AS CntrlPurContrDescription,
  _SubordCntrlContrHierLink.SubordCntrlPurContrLastUpdtSts AS SubordCntrlPurContrLastUpdtSts,
  _SubordCntrlContrHierLink.SubordCntrlContrLastUpdtDteTme AS SubordCntrlContrLastUpdtDteTme,
  _SubordCntrlContrHierLink.DistrResponseMessageUUID AS DistrResponseMessageUUID
FROM R_CentralPurchaseContract AS Original
LEFT OUTER JOIN I_SubordCntrlContrStaging AS Temp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SubordCntrlContrHierLink AS _SubordCntrlContrHierLink ON _SubordCntrlContrHierLink.PurchasingParentDocument = PurchasingParentDocument AND _SubordCntrlContrHierLink.SubordCntrlPurContract = SubordCntrlPurContract  -- association [0..1]
-- UNION with additional select branch(es): I_SubordCntrlContrStaging
;

Learn More