I_SubordCntrlContrStaging

DDL: I_SUBORDCNTRLCONTRSTAGING SQL: ISUBORDCCTRSTG Type: view BASIC
11 Fields 1 Data Sources

Temporary Persistence of Subordinate Central Contracts

I_SubordCntrlContrStaging is a Basic CDS View that provides data about "Temporary Persistence of Subordinate Central Contracts" in SAP S/4HANA. It reads from 1 data source (mmpur_cctr_det) and exposes 11 fields with key fields PurchasingParentDocument, ProcmtHubCompanyCodeGroupingID, SubordCntrlPurContract.

Data Sources (1)

SourceAliasJoin Type
mmpur_cctr_det mmpur_cctr_det from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISUBORDCCTRSTG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Temporary Persistence of Subordinate Central Contracts view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchasingParentDocument documentparentid Purchasing Doc.
KEY ProcmtHubCompanyCodeGroupingID procmthubcompanycodegroupingid Grouping ID
KEY SubordCntrlPurContract subordinatecentralcontract Purchasing Doc.
CompanyCode companycode Receiver Company Code
PurchasingOrganization purchasingorganization Purchasing Organization
PurchasingGroup purchasingroup Purch. Group
PurchaseContractType purchasecontracttype Order Type
PurchasingDocumentSubtype purchasindocumentsubtype Control
ValidityStartDate validitystartdate Validity Start Date
ValidityEndDate validityenddate ValidTo
CntrlPurContrDescription cntrlpurcontrdescription Contract Name

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_SubordCntrlContrStaging.
-- 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: ISUBORDCCTRSTG

CREATE VIEW I_SubordCntrlContrStaging AS
SELECT
  documentparentid AS PurchasingParentDocument,
  ProcmtHubCompanyCodeGroupingID,
  subordinatecentralcontract AS SubordCntrlPurContract,
  CompanyCode,
  PurchasingOrganization,
  purchasingroup AS PurchasingGroup,
  PurchaseContractType,
  purchasindocumentsubtype AS PurchasingDocumentSubtype,
  ValidityStartDate,
  ValidityEndDate,
  CntrlPurContrDescription
FROM mmpur_cctr_det
;

Learn More