C_CntrlQtanFllwOnDocStagingItm

DDL: C_CNTRLQTANFLLWONDOCSTAGINGITM SQL: CCNTRLQTNFLLWITP Type: view CONSUMPTION
22 Fields 2 Data Sources 1 Associations

Staging view for creating foll-on doc from Central Quotation

C_CntrlQtanFllwOnDocStagingItm is a Consumption CDS View that provides data about "Staging view for creating foll-on doc from Central Quotation" in SAP S/4HANA. It reads from 2 data sources (C_CntrlQtanFllwOnDocStagingHdr, I_CntrlQtanFllwOnDocStagingItm) and exposes 22 fields with key fields CntrlQtanFllwOnDocDraftHdrUUID, CntrlQtanFllwOnDocDraftItmUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
C_CntrlQtanFllwOnDocStagingHdr _CntrlQtanFllwOnDocStagingHdr inner
I_CntrlQtanFllwOnDocStagingItm _CntrlQtanFllwOnDocStagingItm from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_PurDocItemCategoryValueHelp _PurDocItemCategoryValueHelp _CntrlSupplierQuotationItemTP.PurchasingDocumentItemCategory = _PurDocItemCategoryValueHelp.PurchasingDocumentItemCategory

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCNTRLQTNFLLWITP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Staging view for creating foll-on doc from Central Quotation view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.updateEnabled true view
AbapCatalog.preserveKey true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CntrlQtanFllwOnDocDraftHdrUUID I_CntrlQtanFllwOnDocStagingItm CntrlQtanFllwOnDocDraftHdrUUID Key
KEY CntrlQtanFllwOnDocDraftItmUUID I_CntrlQtanFllwOnDocStagingItm CntrlQtanFllwOnDocDraftItmUUID Key
PurchasingDocumentItemCategory _CntrlSupplierQuotationItemTP PurchasingDocumentItemCategory Item Category
ItemCategoryName _PurDocItemCategoryValueHelp PurgDocItemCategoryName Text for ItCat.
ProcmtHubProduct I_CntrlQtanFllwOnDocStagingItm ProcmtHubProduct Material
ProcmtHubPlant I_CntrlQtanFllwOnDocStagingItm Plant Valuation Area
ProcurementHubSourceSystem C_CntrlQtanFllwOnDocStagingHdr ProcurementHubSourceSystem Connected System ID
CentralSupplierQuotation I_CntrlQtanFllwOnDocStagingItm CentralSupplierQuotation Purchasing Doc.
ProcmtHubMaterialName I_CntrlQtanFllwOnDocStagingItm ProcmtHubMaterialName Description
ProcmtHubDeliveryDate I_CntrlQtanFllwOnDocStagingItm ProcmtHubDeliveryDate Delivery Date
ProcmtHubOrderQuantity I_CntrlQtanFllwOnDocStagingItm ProcmtHubOrderQuantity PO Quantity
ProcmtHubOrderQuantityUnit I_CntrlQtanFllwOnDocStagingItm ProcmtHubOrderQuantityUnit Order Unit
ProcmtHubNetPriceAmount I_CntrlQtanFllwOnDocStagingItm ProcmtHubNetPriceAmount Net Price
ProcmtHubDocumentCurrency I_CntrlQtanFllwOnDocStagingItm ProcmtHubDocumentCurrency Currency Key
ProcmtHubNetPriceQuantity I_CntrlQtanFllwOnDocStagingItm ProcmtHubNetPriceQuantity Price Unit
ProcmtHubOrderPriceUnit I_CntrlQtanFllwOnDocStagingItm ProcmtHubOrderPriceUnit PO Price Unit
IsEditable
SourcingProjectQuotationUUID I_CntrlQtanFllwOnDocStagingItm SourcingProjectQuotationUUID Supplier Quotation UUID
SourcingProjectQuotation I_CntrlQtanFllwOnDocStagingItm SourcingProjectQuotation Supplier Quotation
SourcingProjectQuotationItem I_CntrlQtanFllwOnDocStagingItm SourcingProjectQuotationItem Item
_CntrlQtanFllwOnDocStagingHdr I_CntrlQtanFllwOnDocStagingItm _CntrlQtanFllwOnDocStagingHdr
_PurDocItemCategoryValueHelp _PurDocItemCategoryValueHelp

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_CntrlQtanFllwOnDocStagingItm.
-- 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: CCNTRLQTNFLLWITP

CREATE VIEW C_CntrlQtanFllwOnDocStagingItm AS
SELECT
  _CntrlQtanFllwOnDocStagingItm.CntrlQtanFllwOnDocDraftHdrUUID AS CntrlQtanFllwOnDocDraftHdrUUID,
  _CntrlQtanFllwOnDocStagingItm.CntrlQtanFllwOnDocDraftItmUUID AS CntrlQtanFllwOnDocDraftItmUUID,
  _CntrlSupplierQuotationItemTP.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurDocItemCategoryValueHelp.PurgDocItemCategoryName AS ItemCategoryName,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubProduct AS ProcmtHubProduct,
  _CntrlQtanFllwOnDocStagingItm.Plant AS ProcmtHubPlant,
  _CntrlQtanFllwOnDocStagingHdr.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _CntrlQtanFllwOnDocStagingItm.CentralSupplierQuotation AS CentralSupplierQuotation,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubMaterialName AS ProcmtHubMaterialName,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubDeliveryDate AS ProcmtHubDeliveryDate,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubOrderQuantity AS ProcmtHubOrderQuantity,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubOrderQuantityUnit AS ProcmtHubOrderQuantityUnit,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubNetPriceAmount AS ProcmtHubNetPriceAmount,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubDocumentCurrency AS ProcmtHubDocumentCurrency,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubNetPriceQuantity AS ProcmtHubNetPriceQuantity,
  _CntrlQtanFllwOnDocStagingItm.ProcmtHubOrderPriceUnit AS ProcmtHubOrderPriceUnit,
  cast ( ('') as abap.char(1)) AS IsEditable,
  _CntrlQtanFllwOnDocStagingItm.SourcingProjectQuotationUUID AS SourcingProjectQuotationUUID,
  _CntrlQtanFllwOnDocStagingItm.SourcingProjectQuotation AS SourcingProjectQuotation,
  _CntrlQtanFllwOnDocStagingItm.SourcingProjectQuotationItem AS SourcingProjectQuotationItem,
  _CntrlQtanFllwOnDocStagingItm._CntrlQtanFllwOnDocStagingHdr AS _CntrlQtanFllwOnDocStagingHdr
FROM I_CntrlQtanFllwOnDocStagingItm AS _CntrlQtanFllwOnDocStagingItm
INNER JOIN C_CntrlQtanFllwOnDocStagingHdr AS _CntrlQtanFllwOnDocStagingHdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PurDocItemCategoryValueHelp AS _PurDocItemCategoryValueHelp ON _CntrlSupplierQuotationItemTP.PurchasingDocumentItemCategory = _PurDocItemCategoryValueHelp.PurchasingDocumentItemCategory  -- association [1..1]
;

Learn More