I_CUSTOMERMATERIAL_2

CDS View
10 Fields 6 CDS Views

Customer Material

I_CUSTOMERMATERIAL_2 is a CDS View in S/4HANA. Customer Material. It contains 10 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_CustomerMaterial view from COMPOSITE Customer Materials
C_CustomerMaterialVH view from CONSUMPTION Customer Material Value Help
C_SlsDocItemCustomerMaterialVH view from CONSUMPTION Customer Material
ESH_N_SOR_CUSTMAT view from Anchor view -SOR_CUSTMAT
I_CustomerMaterialTP view from TRANSACTIONAL Customer Material BO Draft
R_CustomerMaterialTP view_entity from TRANSACTIONAL Customer Material - TP

Fields (10)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 2
KEY DistributionChannel DistributionChannel 2
KEY MaterialByCustomer MaterialByCustomer 2
KEY Product Material,Product 2
KEY SalesOrganization SalesOrganization 2
BaseUnit BaseUnit 1
DeliveryPriority DeliveryPriority 1
MaterialDescriptionByCustomer MaterialDescriptionByCustomer 2
MinDeliveryQtyInBaseUnit MinDeliveryQtyInBaseUnit 1
Plant Plant 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.

-- Customer Material
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMERMATERIAL_2 (
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    MATERIALBYCUSTOMER,
    PRODUCT,
    SALESORGANIZATION,
    BASEUNIT,
    DELIVERYPRIORITY,
    MATERIALDESCRIPTIONBYCUSTOMER,
    MINDELIVERYQTYINBASEUNIT,
    PLANT,
    PRIMARY KEY (CUSTOMER, DISTRIBUTIONCHANNEL, MATERIALBYCUSTOMER, PRODUCT, SALESORGANIZATION)
);

Learn More