C_ProdAssgblToDistrCtrVH

DDL: C_PRODASSGBLTODISTRCTRVH SQL: CPRODASGBLTODC Type: view CONSUMPTION Package: RFM_LIST_PRODUCT_IN_DISTR_CTRS
21 Fields 1 OData Services

Product Assignable to Distribution Center

C_ProdAssgblToDistrCtrVH is a Consumption CDS View that provides data about "Product Assignable to Distribution Center" in SAP S/4HANA. It is exposed through 1 OData service (JOULE_RFM_ASSIGN_PROD_TO_DCS). Part of development package RFM_LIST_PRODUCT_IN_DISTR_CTRS.

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPRODASGBLTODC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Assignable to Distribution Center view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Product view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

OData Services (1)

ServiceBindingVersionContractRelease
JOULE_RFM_ASSIGN_PROD_TO_DCS JOULE_RFM_ASSGN_PROD_TO_DC V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductVH Product Product Sold
_Text I_ProductVH _Text
ProductExternalID I_ProductVH ProductExternalID Material
IndustrySector I_ProductVH IndustrySector Industry
ProductType I_ProductVH ProductType Product Type Group
_ProductType I_ProductVH _ProductType
ProductGroup
_ProductGroup I_ProductVH _ProductGroup
BaseUnit I_ProductVH BaseUnit Unit of Measure
_BaseUnit I_ProductVH _BaseUnit
GrossWeight I_ProductVH GrossWeight Total Weight
NetWeight I_ProductVH NetWeight Net weight
WeightUnit I_ProductVH WeightUnit Weight unit
_WeightUnit I_ProductVH _WeightUnit
ManufacturerNumber I_ProductVH ManufacturerNumber Manufacturer No
AuthorizationGroup I_ProductVH AuthorizationGroup AuthorizGroup
IsBatchManagementRequired I_ProductVH IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
ProductManufacturerNumber I_ProductVH ProductManufacturerNumber Mfr Part Number
ArticleCategory I_ProductVH ArticleCategory Prod Category
_ProductCategory I_ProductVH _ProductCategory
_ProductPlant I_ProductVH _ProductPlant

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_ProdAssgblToDistrCtrVH.
-- 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: CPRODASGBLTODC

CREATE VIEW C_ProdAssgblToDistrCtrVH AS
SELECT
  I_ProductVH.Product AS Product,
  I_ProductVH._Text AS _Text,
  I_ProductVH.ProductExternalID AS ProductExternalID,
  I_ProductVH.IndustrySector AS IndustrySector,
  I_ProductVH.ProductType AS ProductType,
  I_ProductVH._ProductType AS _ProductType,
  cast ( I_ProductVH.ProductGroup as rfm_mrchdscategory preserving type ) AS ProductGroup,
  I_ProductVH._ProductGroup AS _ProductGroup,
  I_ProductVH.BaseUnit AS BaseUnit,
  I_ProductVH._BaseUnit AS _BaseUnit,
  I_ProductVH.GrossWeight AS GrossWeight,
  I_ProductVH.NetWeight AS NetWeight,
  I_ProductVH.WeightUnit AS WeightUnit,
  I_ProductVH._WeightUnit AS _WeightUnit,
  I_ProductVH.ManufacturerNumber AS ManufacturerNumber,
  I_ProductVH.AuthorizationGroup AS AuthorizationGroup,
  I_ProductVH.IsBatchManagementRequired AS IsBatchManagementRequired,
  I_ProductVH.ProductManufacturerNumber AS ProductManufacturerNumber,
  I_ProductVH.ArticleCategory AS ArticleCategory,
  I_ProductVH._ProductCategory AS _ProductCategory,
  I_ProductVH._ProductPlant AS _ProductPlant
;

Learn More