I_SLSMATLDETERMINATIONRECORD

CDS View
24 Fields 2 CDS Views

Material Determination Condition Record

I_SLSMATLDETERMINATIONRECORD is a CDS View in S/4HANA. Material Determination Condition Record. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SlsMatlDetnRecordDEX view_entity union_all CONSUMPTION Material Detn Condition Recd Extraction
R_SlsMatlDeterminationRecordTP view_entity from TRANSACTIONAL Sales Material Determination - TP

Fields (24)

KeyField CDS FieldsUsed in Views
ConditionApplication ConditionApplication 1
ConditionTable ConditionTable 1
ConditionType ConditionType 1
ConditionValidityEndDate ConditionValidityEndDate 1
ConditionValidityStartDate ConditionValidityStartDate 1
Customer Customer 1
CustomerGroup CustomerGroup 1
DistributionChannel DistributionChannel 1
Division Division 1
ForwardingAgent ForwardingAgent 1
LastChangeDateTime LastChangeDateTime 1
MaterialPricingGroup MaterialPricingGroup 1
MaterialSubstitutionReason MaterialSubstitutionReason 1
OriginallyRequestedMaterial OriginallyRequestedMaterial 1
PayerParty PayerParty 1
Product Product 1
ProductGroup ProductGroup 1
ProductType ProductType 1
SalesDocumentType SalesDocumentType 1
SalesEmployee SalesEmployee 1
SalesOrganization SalesOrganization 1
SDDocumentCategory SDDocumentCategory 1
ShipToParty ShipToParty 1
SoldToParty SoldToParty 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.

-- Material Determination Condition Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSMATLDETERMINATIONRECORD (
    CONDITIONAPPLICATION,
    CONDITIONTABLE,
    CONDITIONTYPE,
    CONDITIONVALIDITYENDDATE,
    CONDITIONVALIDITYSTARTDATE,
    CUSTOMER,
    CUSTOMERGROUP,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    FORWARDINGAGENT,
    LASTCHANGEDATETIME,
    MATERIALPRICINGGROUP,
    MATERIALSUBSTITUTIONREASON,
    ORIGINALLYREQUESTEDMATERIAL,
    PAYERPARTY,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTTYPE,
    SALESDOCUMENTTYPE,
    SALESEMPLOYEE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SHIPTOPARTY,
    SOLDTOPARTY
);

Learn More