C_ProcmtQltyMgmtDsbldProd

DDL: C_PROCMTQLTYMGMTDSBLDPROD SQL: CGRCQMDISPROD Type: view CONSUMPTION
57 Fields 1 Data Sources

QM in procurement disabled product

C_ProcmtQltyMgmtDsbldProd is a Consumption CDS View that provides data about "QM in procurement disabled product" in SAP S/4HANA. It reads from 1 data source (I_Product) and exposes 57 fields with key field Product.

Data Sources (1)

SourceAliasJoin Type
I_Product I_Product from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CGRCQMDISPROD view
EndUserText.label QM in procurement disabled product view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
ProductExternalID ProductExternalID Material
ProductType ProductType Product Type Group
ProductGroup ProductGroup Product Sold Group
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
CreationTime CreationTime Time of Change
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
CrossPlantStatus CrossPlantStatus X-Plant Status
CrossPlantStatusValidityDate CrossPlantStatusValidityDate Valid From
ProductOldID ProductOldID Old Prd Number
SourceOfSupply SourceOfSupply Supply source
CountryOfOrigin CountryOfOrigin Country/Region of Origin
ItemCategoryGroup ItemCategoryGroup Item Cat. Group
ProductHierarchy ProductHierarchy Prod.hierarchy
Division Division Internal Division ID
AuthorizationGroup AuthorizationGroup AuthorizGroup
ANPCode ANPCode ANP Code
ProductCategory ProductCategory Prod Category
Brand Brand Fire-Cont.Sect.
ProductIsConfigurable ProductIsConfigurable Configurable
IsBatchManagementRequired IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
HasEmptiesBOM HasEmptiesBOM W/ Empties BOM
ExternalProductGroup ExternalProductGroup Ext. prod group
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
QltyMgmtInProcmtIsActive QltyMgmtInProcmtIsActive QM procurement
IsApprovedBatchRecordReqd IsApprovedBatchRecordReqd Batch rec. req.
_Text _Text
_ProdUnivHierarchyNode _ProdUnivHierarchyNode
_ProductType _ProductType
_ProductTypeName _ProductTypeName
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_ProductStatus _ProductStatus
_ProductStatusText _ProductStatusText
_ProductGroup _ProductGroup
_ProductGroupText _ProductGroupText
_ProductGroup_2 _ProductGroup_2
_ProductGroupText_2 _ProductGroupText_2
_ItemCategoryGroup _ItemCategoryGroup
_ItemCategoryGroupText _ItemCategoryGroupText
_ProductHierarchy _ProductHierarchy
_ProductHierarchyText _ProductHierarchyText
_Division _Division
_DivisionText _DivisionText
_BR_ANPCode _BR_ANPCode
_BR_ANPCodeText _BR_ANPCodeText
_ProductCategory _ProductCategory
_ProductCategoryText _ProductCategoryText
_Brand _Brand
_BrandText _BrandText
_ExternalProductGroup _ExternalProductGroup
_ExtProdGrpText _ExtProdGrpText
_CrossPlantConfigurableProduct _CrossPlantConfigurableProduct
_MaterialText _MaterialText

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_ProcmtQltyMgmtDsbldProd.
-- 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: CGRCQMDISPROD

CREATE VIEW C_ProcmtQltyMgmtDsbldProd AS
SELECT
  Product,
  ProductExternalID,
  ProductType,
  ProductGroup,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  CreationTime,
  IsMarkedForDeletion,
  CrossPlantStatus,
  CrossPlantStatusValidityDate,
  ProductOldID,
  SourceOfSupply,
  CountryOfOrigin,
  ItemCategoryGroup,
  ProductHierarchy,
  Division,
  AuthorizationGroup,
  ANPCode,
  ProductCategory,
  Brand,
  ProductIsConfigurable,
  IsBatchManagementRequired,
  HasEmptiesBOM,
  ExternalProductGroup,
  CrossPlantConfigurableProduct,
  QltyMgmtInProcmtIsActive,
  IsApprovedBatchRecordReqd
FROM I_Product
;

Learn More