C_MATERIALBYSLSORGDISTRCHNL

CDS View
15 Fields 6 CDS Views

Materials By Sales Org and Distr Channel

C_MATERIALBYSLSORGDISTRCHNL is a CDS View in S/4HANA. Materials By Sales Org and Distr Channel. It contains 15 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CrMmRqProdBySlsOrgDistrChnl view_entity from CONSUMPTION CrdMmReq Product by Sls Org Distr Chnl
C_CustRetProdBySlsOrgDistrChnl view_entity from CONSUMPTION Returns Product by Sls Org Distr Chnl
C_MaterialForManageSalesOrder view from CONSUMPTION Materials For Manage Sales Order
C_SlsContrProdByPrtlSalesArea view from CONSUMPTION Product By Partial Sales Area
C_SlsOrdProdBySlsOrgDistrChnl view from CONSUMPTION Product By Distribution Chain
C_SlsQtanProdBySlsOrgDistrChnl view_entity from CONSUMPTION Sls Qtan Product by Sls Org Distr Chnl

Fields (15)

KeyField CDS FieldsUsed in Views
KEY DistributionChannel DistributionChannel 5
KEY Material Product 5
KEY SalesOrganization SalesOrganization 5
_BaseUnit _BaseUnit 5
_DistributionChannel _DistributionChannel 5
_ProductSalesStatus _ProductSalesStatus 5
_SalesMeasureUnit _SalesMeasureUnit 5
_SalesOrganization _SalesOrganization 5
BaseUnit BaseUnit 5
MaterialName ProductName 5
ProductOldID ProductOldID 5
ProductSalesStatus ProductSalesStatus 5
ProductSalesStatusValidityDate ProductSalesStatusValidityDate 5
RequestedQuantityUnit RequestedQuantityUnit,TargetQuantityUnit 5
SalesMeasureUnit SalesMeasureUnit 5

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.

-- Materials By Sales Org and Distr Channel
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_MATERIALBYSLSORGDISTRCHNL (
    DISTRIBUTIONCHANNEL,
    MATERIAL,
    SALESORGANIZATION,
    _BASEUNIT,
    _DISTRIBUTIONCHANNEL,
    _PRODUCTSALESSTATUS,
    _SALESMEASUREUNIT,
    _SALESORGANIZATION,
    BASEUNIT,
    MATERIALNAME,
    PRODUCTOLDID,
    PRODUCTSALESSTATUS,
    PRODUCTSALESSTATUSVALIDITYDATE,
    REQUESTEDQUANTITYUNIT,
    SALESMEASUREUNIT,
    PRIMARY KEY (DISTRIBUTIONCHANNEL, MATERIAL, SALESORGANIZATION)
);

Learn More