C_SubordinateCntrlContrTP

DDL: C_SUBORDINATECNTRLCONTRTP SQL: CSUBORDCCTR Type: view CONSUMPTION
22 Fields 1 Data Sources 6 Associations

Consumption View for Subordinate Central Contracts

C_SubordinateCntrlContrTP is a Consumption CDS View that provides data about "Consumption View for Subordinate Central Contracts" in SAP S/4HANA. It reads from 1 data source (I_SubordinateCntrlContrTP) and exposes 22 fields with key fields PurchasingParentDocument, ProcmtHubCompanyCodeGroupingID, SubordCntrlPurContract. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SubordinateCntrlContrTP I_SubordinateCntrlContrTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_CntrlPurContrHierHdrTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.PurchasingParentDocument
[1..1] I_ProcmtHubCompanyCodeGroup _ProcmtHubCompanyCodeGroup _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = $projection.ProcmtHubCompanyCodeGroupingID
[1..1] C_SubordinateCntrlContrTypeVH _CntrlPurContrTypeValueHelp _CntrlPurContrTypeValueHelp.PurchaseContractType = $projection.PurchaseContractType
[0..1] I_PurchasingOrganization _PurchasingOrganization _PurchasingOrganization.PurchasingOrganization = $projection.PurchasingOrganization
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_PurchasingGroup _PurchasingGroup $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CSUBORDCCTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for Subordinate Central Contracts view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.updateEnabled true view
ObjectModel.transactionalProcessingDelegated true view
UI.headerInfo.typeName Subordinate Central Contract view
UI.headerInfo.typeNamePlural Subordinate Central Contracts view
UI.headerInfo.title.value SubordinateCentralContract view
UI.headerInfo.title.label Subordinate Central Contract view
UI.headerInfo.description.value ContractDescription view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PurchasingParentDocument PurchasingParentDocument Parent Document ID
KEY ProcmtHubCompanyCodeGroupingID ProcmtHubCompanyCodeGroupingID Grouping ID
KEY SubordCntrlPurContract SubordCntrlPurContract
ActivePurchasingDocument ActivePurchasingDocument More Actions
CntrlPurContrDescription CntrlPurContrDescription Contract Name
PurchaseContractType PurchaseContractType Order Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
SubordCntrlPurContrLastUpdtSts SubordCntrlPurContrLastUpdtSts
SubordCntrlContrLastUpdtStsTxt SubordCntrlContrLastUpdtStsTxt Last Update Status Text
SubordCntrlContrLastUpdtDteTme SubordCntrlContrLastUpdtDteTme
DistrResponseMessageUUID DistrResponseMessageUUID GUID
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
PurchasingDocumentSubtype PurchasingDocumentSubtype Control
_CentralPurchaseContractTP _CentralPurchaseContractTP
_ProcmtHubCompanyCodeGroup _ProcmtHubCompanyCodeGroup
_CntrlPurContrTypeValueHelp _CntrlPurContrTypeValueHelp
_PurchasingOrganization _PurchasingOrganization
_CompanyCode _CompanyCode
_PurchasingGroup _PurchasingGroup

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 C_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: CSUBORDCCTR

CREATE VIEW C_SubordinateCntrlContrTP AS
SELECT
  PurchasingParentDocument,
  ProcmtHubCompanyCodeGroupingID,
  SubordCntrlPurContract,
  ActivePurchasingDocument,
  CntrlPurContrDescription,
  PurchaseContractType,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  SubordCntrlPurContrLastUpdtSts,
  SubordCntrlContrLastUpdtStsTxt,
  SubordCntrlContrLastUpdtDteTme,
  DistrResponseMessageUUID,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingDocumentSubtype
FROM I_SubordinateCntrlContrTP
LEFT OUTER JOIN C_CntrlPurContrHierHdrTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = PurchasingParentDocument  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubCompanyCodeGroup AS _ProcmtHubCompanyCodeGroup ON _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = ProcmtHubCompanyCodeGroupingID  -- association [1..1]
LEFT OUTER JOIN C_SubordinateCntrlContrTypeVH AS _CntrlPurContrTypeValueHelp ON _CntrlPurContrTypeValueHelp.PurchaseContractType = PurchaseContractType  -- 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_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
;

Learn More