What is C_SlsMatlDetnRecordDEX in SAP S/4HANA?

C_SlsMatlDetnRecordDEX is a consumption CDS view in SAP S/4HANA. Material Detn Condition Recd Extraction It contains 56 fields.

Which tables does C_SlsMatlDetnRecordDEX read from?

C_SlsMatlDetnRecordDEX reads data from: I_SlsMatlDetnRecdAddlSubstit, I_SlsMatlDeterminationRecord.

What VDM layer is C_SlsMatlDetnRecordDEX?

C_SlsMatlDetnRecordDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SlsMatlDetnRecordDEX

DDL: C_SLSMATLDETNRECORDDEX Type: view_entity CONSUMPTION Package: VDM_SD_MD_MATL_DETN

56 Fields 2 Data Sources

Material Detn Condition Recd Extraction

C_SlsMatlDetnRecordDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

SlsMatlDetnRecdAddlSubstit · Sales

C_SlsMatlDetnRecordDEX is a Consumption CDS View that provides data about "Material Detn Condition Recd Extraction" in SAP S/4HANA. It reads from 2 data sources (I_SlsMatlDetnRecdAddlSubstit, I_SlsMatlDeterminationRecord) and exposes 56 fields with key fields ConditionRecord, SlsMatlDetnSequenceNumber, SlsMatlDetnSequenceNumber. Part of development package VDM_SD_MD_MATL_DETN.

SAP Help Documentation

Category	Sales Master Data

Purpose
This CDS view is app-independent, and is available for all external consumers who want to extract material determination condition records to SAP Business Warehouse (SAP BW) or other external systems. This view combines the data of the following CDS views: Material Determination Condition Record ( I_SlsMatlDeterminationRecord ) Additional Substitute for Material Determination ( I_SlsMatlDetnRecdAddlSubstit ) To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important Fields Important fields in this view include the following: Field Name Description ConditionRecord Condition record number ConditionApplication Application area in which a material determination condition is used The value is fixed to V ( Sales/Distribution ). ConditionType Condition type for material determination ConditionTable Condition table SalesOrganization Sales organization DistributionChannel Distribution channel Division Division OriginallyRequestedMaterial Material entered SlsMatlDetnSequenceNumber Sequence number for accessing a substitute material Note A condition record may contain multiple substitute materials. The sequence number is 001 for the first substitute material, and starts from 002 for additional substitute materials. SlsMatlDetnSubstituteMaterial Substitute material (that is, a material used as a substitute for the entered material in a sales document) SlsMatlDetnSubstitMaterialUoM UoM of a substitute material MaterialSubstitutionReason Substitution reason ConditionValidityStartDate Valid-from date of the condition record ConditionValidityEndDate Valid-to date of the condition record LastChangeDateTime Last change date (UTC time stamp) SDDocumentCategory SD document category SalesDocumentType Sales document type Customer Customer CustomerGroup Customer group SoldToParty Sold-to party ShipToParty Ship-to party PayerParty Payer SalesEmployee Sales employee ForwardingAgent Forwarding agent Product Material (that is, product) ProductType Material type (that is, product type) ProductGroup Material group (that is, product group) MaterialPricingGroup Material price group PricingReferenceMaterial Pricing reference material Plant Plant PlantCounty County of the delivering plant PlantRegion Region of the delivering plant PlantCity City of the delivering plant IncotermsClassification Incoterms (Part 1) IncotermsTransferLocation Incoterms (Part 2) County County DepartureCountry Departure country or region DestinationCountry Destination country or region Region Region CityCode City Batch Batch CompanyCode Company code PurchasingInfoRecord Purchasing information record

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	C1
Line of Business	Sales
Application Component	SD-MD-MM-DET-2CL
Capabilities	Data Source for Data Extraction
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Sales for SAP S/4HANA Cloud Public Edition
Description	This CDS view is app-independent, and is available for all external consumers who want to extract material determination condition records to SAP Business Warehouse (SAP BW) or other external systems. This view combines the data of the following CDS views:<ul> <li><p>Material Determination Condition Record (I_SlsMatlDeterminationRecord)</p></li> <li><p>Additional Substitute for Material Determination (I_SlsMatlDetnRecdAddlSubstit)</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (2)

Source	Alias	Join Type
I_SlsMatlDetnRecdAddlSubstit	additional	from
I_SlsMatlDeterminationRecord	substitute	union_all

Annotations (11)

Name	Value	Level
EndUserText.label	Material Detn Condition Recd Extraction	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.modelingPattern	#NONE	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.sapObjectNodeType.name	SlsMatlDetnRecdAddlSubstit	view

Fields (56)

Key	Field	Source Table	Source Field	Description
KEY	ConditionRecord	I_SlsMatlDetnRecdAddlSubstit	ConditionRecord	Number of Condition Record
KEY	SlsMatlDetnSequenceNumber	I_SlsMatlDetnRecdAddlSubstit	SlsMatlDetnSequenceNumber	Number
	ConditionApplication	I_SlsMatlDeterminationRecord	ConditionApplication	Application
	ConditionType	I_SlsMatlDeterminationRecord	ConditionType	Material Determination Type
	ConditionTable	I_SlsMatlDeterminationRecord	ConditionTable	Condition Table
	SalesOrganization	I_SlsMatlDeterminationRecord	SalesOrganization	Sales Organization
	DistributionChannel	I_SlsMatlDeterminationRecord	DistributionChannel	Distribution Channel
	Division	I_SlsMatlDeterminationRecord	Division	Internal Division ID
	SlsMatlDetnSubstituteMaterial	I_SlsMatlDetnRecdAddlSubstit	SlsMatlDetnSubstituteMaterial	Substitute Material
	SlsMatlDetnSubstitMaterialUoM	I_SlsMatlDetnRecdAddlSubstit	SlsMatlDetnSubstitMaterialUoM	Substitute Unit of Measure
	MaterialSubstitutionReason	I_SlsMatlDeterminationRecord	MaterialSubstitutionReason	Reason for material substitution
	ConditionValidityEndDate	I_SlsMatlDeterminationRecord	ConditionValidityEndDate	Validity end date of the condition record
	ConditionValidityStartDate	I_SlsMatlDeterminationRecord	ConditionValidityStartDate	Validity start date of the condition record
	LastChangeDateTime	I_SlsMatlDeterminationRecord	LastChangeDateTime	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
	SDDocumentCategory	I_SlsMatlDeterminationRecord	SDDocumentCategory	SD Document Category
	SalesDocumentType	I_SlsMatlDeterminationRecord	SalesDocumentType	Sales Document Type
	Customer	I_SlsMatlDeterminationRecord	Customer	Customer number
	CustomerGroup	I_SlsMatlDeterminationRecord	CustomerGroup	Customer Group
	SoldToParty	I_SlsMatlDeterminationRecord	SoldToParty	Sold-to Party
	ShipToParty	I_SlsMatlDeterminationRecord	ShipToParty	Ship-To Party (obsolete)
	PayerParty	I_SlsMatlDeterminationRecord	PayerParty	Payer
	SalesEmployee	I_SlsMatlDeterminationRecord	SalesEmployee	Sales Employee
	ForwardingAgent	I_SlsMatlDeterminationRecord	ForwardingAgent	Forwarding Agent
	Product	I_SlsMatlDeterminationRecord	Product	Product Sold
	ProductType	I_SlsMatlDeterminationRecord	ProductType	Product Type Group
	ProductGroup	I_SlsMatlDeterminationRecord	ProductGroup	Product Sold Group
	MaterialPricingGroup	I_SlsMatlDeterminationRecord	MaterialPricingGroup	Material Price Group
	OriginallyRequestedMaterial	I_SlsMatlDeterminationRecord	OriginallyRequestedMaterial	Material Entered
KEY	SlsMatlDetnSequenceNumber			Number
	ConditionApplication		ConditionApplication	Application
	ConditionType		ConditionType	Material Determination Type
	ConditionTable		ConditionTable	Condition Table
	SalesOrganization		SalesOrganization	Sales Organization
	DistributionChannel		DistributionChannel	Distribution Channel
	Division		Division	Internal Division ID
	SlsMatlDetnSubstituteMaterial		SlsMatlDetnSubstituteMaterial	Substitute Material
	SlsMatlDetnSubstitMaterialUoM		SlsMatlDetnSubstitMaterialUoM	Substitute Unit of Measure
	MaterialSubstitutionReason		MaterialSubstitutionReason	Reason for material substitution
	ConditionValidityEndDate		ConditionValidityEndDate	Validity end date of the condition record
	ConditionValidityStartDate		ConditionValidityStartDate	Validity start date of the condition record
	LastChangeDateTime		LastChangeDateTime	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
	SDDocumentCategory		SDDocumentCategory	SD Document Category
	SalesDocumentType		SalesDocumentType	Sales Document Type
	Customer		Customer	Customer number
	CustomerGroup		CustomerGroup	Customer Group
	SoldToParty		SoldToParty	Sold-to Party
	ShipToParty		ShipToParty	Ship-To Party (obsolete)
	PayerParty		PayerParty	Payer
	SalesEmployee		SalesEmployee	Sales Employee
	ForwardingAgent		ForwardingAgent	Forwarding Agent
	Product		Product	Product Sold
	ProductType		ProductType	Product Type Group
	ProductGroup		ProductGroup	Product Sold Group
	MaterialPricingGroup		MaterialPricingGroup	Material Price Group
	OriginallyRequestedMaterial		OriginallyRequestedMaterial	Material Entered
	PricingReferenceMaterial		PricingReferenceMaterial	Pricing Reference Material

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_SlsMatlDetnRecordDEX.
-- 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.

CREATE VIEW C_SlsMatlDetnRecordDEX AS
SELECT
  additional.ConditionRecord AS ConditionRecord,
  additional.SlsMatlDetnSequenceNumber AS SlsMatlDetnSequenceNumber,
  substitute.ConditionApplication AS ConditionApplication,
  substitute.ConditionType AS ConditionType,
  substitute.ConditionTable AS ConditionTable,
  substitute.SalesOrganization AS SalesOrganization,
  substitute.DistributionChannel AS DistributionChannel,
  substitute.Division AS Division,
  additional.SlsMatlDetnSubstituteMaterial AS SlsMatlDetnSubstituteMaterial,
  additional.SlsMatlDetnSubstitMaterialUoM AS SlsMatlDetnSubstitMaterialUoM,
  substitute.MaterialSubstitutionReason AS MaterialSubstitutionReason,
  substitute.ConditionValidityEndDate AS ConditionValidityEndDate,
  substitute.ConditionValidityStartDate AS ConditionValidityStartDate,
  substitute.LastChangeDateTime AS LastChangeDateTime,
  substitute.SDDocumentCategory AS SDDocumentCategory,
  substitute.SalesDocumentType AS SalesDocumentType,
  substitute.Customer AS Customer,
  substitute.CustomerGroup AS CustomerGroup,
  substitute.SoldToParty AS SoldToParty,
  substitute.ShipToParty AS ShipToParty,
  substitute.PayerParty AS PayerParty,
  substitute.SalesEmployee AS SalesEmployee,
  substitute.ForwardingAgent AS ForwardingAgent,
  substitute.Product AS Product,
  substitute.ProductType AS ProductType,
  substitute.ProductGroup AS ProductGroup,
  substitute.MaterialPricingGroup AS MaterialPricingGroup,
  substitute.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  PricingReferenceMaterial
FROM I_SlsMatlDetnRecdAddlSubstit AS additional
-- UNION ALL with additional select branch(es): I_SlsMatlDeterminationRecord
;

Depth:

C_SlsMatlDetnRecordDEX view_entity

I_SlsMatlDetnRecdAddlSubstit view_entity
I_SlsMatlDeterminationRecord view_entity