I_SubordinateCntrlContrTP

DDL: I_SUBORDINATECNTRLCONTRTP SQL: ISUBORDCCTRTP Type: view TRANSACTIONAL Package: APPL_MM_PUR_OA_CCTR
20 Fields 1 Data Sources 5 Associations

Transactional View for Subordinate Central Contracts

I_SubordinateCntrlContrTP is a Transactional CDS View that provides data about "Transactional View for Subordinate Central Contracts" in SAP S/4HANA. It reads from 1 data source (I_SubordinateCntrlContr) and exposes 20 fields with key fields PurchasingParentDocument, SubordCntrlPurContract, ProcmtHubCompanyCodeGroupingID. It has 5 associations to related views. Part of development package APPL_MM_PUR_OA_CCTR.

Data Sources (1)

SourceAliasJoin Type
I_SubordinateCntrlContr I_SubordinateCntrlContr from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContractTP _ParentContractTP _ParentContractTP.CentralPurchaseContract = $projection.PurchasingParentDocument
[1..1] I_ProcmtHubCompanyCodeGroup _ProcmtHubCompanyCodeGroup _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = $projection.ProcmtHubCompanyCodeGroupingID
[0..1] I_PurchasingOrganization _PurchasingOrganization _PurchasingOrganization.PurchasingOrganization = $projection.PurchasingOrganization
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_SubordCntrlContrUpdtStsTxt _SubordCntrlContrUpdtStsTxt _SubordCntrlContrUpdtStsTxt.SubordCntrlPurContrLastUpdtSts = $projection.SubordCntrlPurContrLastUpdtSts

Annotations (13)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchasingParentDocument PurchasingParentDocument Parent Document ID
KEY SubordCntrlPurContract SubordCntrlPurContract Active Purchase Doc
KEY ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
PurchaseContractType PurchaseContractType Order Type
CompanyCode CompanyCode Receiver Company Code
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
PurchasingOrganization PurchasingOrganization Purchasing Organization
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
PurchasingGroup PurchasingGroup Purchasing Group
IsEndOfPurposeBlocked
CntrlPurContrDescription CntrlPurContrDescription Contract Name
SubordCntrlPurContrLastUpdtSts SubordCntrlPurContrLastUpdtSts
SubordCntrlContrLastUpdtStsTxt _SubordCntrlContrUpdtStsTxt SubordCntrlContrLastUpdtStsTxt
SubordCntrlContrLastUpdtDteTme SubordCntrlContrLastUpdtDteTme
DistrResponseMessageUUID DistrResponseMessageUUID GUID
_ParentContractTP _ParentContractTP
_ProcmtHubCompanyCodeGroup _ProcmtHubCompanyCodeGroup
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization

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_SubordinateCntrlContrTP.
-- 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: ISUBORDCCTRTP

CREATE VIEW I_SubordinateCntrlContrTP AS
SELECT
  PurchasingParentDocument,
  SubordCntrlPurContract,
  ProcmtHubCompanyCodeGroupingID,
  PurchaseContractType,
  CompanyCode,
  PurchasingDocumentSubtype,
  PurchasingOrganization,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingGroup,
  ' ' AS IsEndOfPurposeBlocked,
  CntrlPurContrDescription,
  SubordCntrlPurContrLastUpdtSts,
  _SubordCntrlContrUpdtStsTxt.SubordCntrlContrLastUpdtStsTxt AS SubordCntrlContrLastUpdtStsTxt,
  SubordCntrlContrLastUpdtDteTme,
  DistrResponseMessageUUID
FROM I_SubordinateCntrlContr
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _ParentContractTP ON _ParentContractTP.CentralPurchaseContract = PurchasingParentDocument  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubCompanyCodeGroup AS _ProcmtHubCompanyCodeGroup ON _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = ProcmtHubCompanyCodeGroupingID  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SubordCntrlContrUpdtStsTxt AS _SubordCntrlContrUpdtStsTxt ON _SubordCntrlContrUpdtStsTxt.SubordCntrlPurContrLastUpdtSts = SubordCntrlPurContrLastUpdtSts  -- association [0..1]
;

Learn More