C_PRODASSGBLTOSTOREVH

CDS View
25 Fields 2 CDS Views

Product Assignable to Store

C_PRODASSGBLTOSTOREVH is a CDS View in S/4HANA. Product Assignable to Store. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ProdAssgblToAsstmtMdlVersVH view_entity from CONSUMPTION Product Assignable to Asstmt Mdl Version
C_ProdAssgblToStoreNarrowVH view_entity from CONSUMPTION Product Assignable to Store

Fields (25)

KeyField CDS FieldsUsed in Views
KEY Product Product 1
_ProductGroup _ProductGroup 1
_ProductGroup_2 _ProductGroup_2 1
_ProductType _ProductType 1
ArticleCategory ArticleCategory 1
AuthorizationGroup AuthorizationGroup 1
CreationDate CreationDate 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 1
CrsPlntConfigurableProductName CrsPlntConfigurableProductName 1
LongProductCharacteristic1 LongProductCharacteristic1 1
LongProductCharacteristic2 LongProductCharacteristic2 1
LongProductCharacteristic3 LongProductCharacteristic3 1
MerchandiseCategory MerchandiseCategory 1
MerchandiseCategoryName MerchandiseCategoryName 1
ProductCategoryName ProductCategoryName 1
ProductCharacteristic1Desc ProductCharacteristic1Desc 1
ProductCharacteristic2Desc ProductCharacteristic2Desc 1
ProductCharacteristic3Desc ProductCharacteristic3Desc 1
ProductExternalID ProductExternalID 1
ProductName ProductName 1
ProductStandardID ProductStandardID 1
ProductType ProductType 1
RetailCharc1WithValueName RetailCharc1WithValueName 1
RetailCharc2WithValueName RetailCharc2WithValueName 1
RetailCharc3WithValueName RetailCharc3WithValueName 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Product Assignable to Store
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_PRODASSGBLTOSTOREVH (
    PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTGROUP_2,
    _PRODUCTTYPE,
    ARTICLECATEGORY,
    AUTHORIZATIONGROUP,
    CREATIONDATE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CRSPLNTCONFIGURABLEPRODUCTNAME,
    LONGPRODUCTCHARACTERISTIC1,
    LONGPRODUCTCHARACTERISTIC2,
    LONGPRODUCTCHARACTERISTIC3,
    MERCHANDISECATEGORY,
    MERCHANDISECATEGORYNAME,
    PRODUCTCATEGORYNAME,
    PRODUCTCHARACTERISTIC1DESC,
    PRODUCTCHARACTERISTIC2DESC,
    PRODUCTCHARACTERISTIC3DESC,
    PRODUCTEXTERNALID,
    PRODUCTNAME,
    PRODUCTSTANDARDID,
    PRODUCTTYPE,
    RETAILCHARC1WITHVALUENAME,
    RETAILCHARC2WITHVALUENAME,
    RETAILCHARC3WITHVALUENAME,
    PRIMARY KEY (PRODUCT)
);

Learn More