I_SlsMatlLstgOrExclsnRecord

Purpose
This CDS view retrieves the condition records (based on standard or custom condition tables) for material listing and exclusion. This CDS view provides the data to answer the following business questions: What condition records exist based on a particular condition type? What is the validity period of a condition record? Under what conditions does material listing or exclusion occur? 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 .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following business catalog: SAP_SD_BC_MD_MANAGE_MC ( Sales - Master Data ) In addition, to retrieve condition records that contain sales area-related fields (sales organization, distribution channel, or division), users must be granted read access to relevant organizational units. Example In your system, some condition records contain sales area 1010/10/00 and others contain sales area 1710/10/00. Users whose read access is restricted to sales area 1010/10/00 can only retrieve the conditions records containing sales area 1010/10/00 (not those containing sales area 1710/10/00). Users whose read access is restricted to sales organization 1000 cannot retrieve these condition records at all. Configuration The following configuration activities are relevant in your configuration environment: Maintain Condition Tables for Listing/Exclusion Maintain Access Sequences for Listing/Exclusion Maintain Listing/Exclusion Types For more information, see Configuration Environment of SAP S/4HANA Cloud Public Edition .

Fields
This CDS view contains the following fields: Field Name Description SlsMatlLstgOrExclsnRecordUUID Condition record number ConditionApplication Application area in which a condition is used The value is fixed to V ( Sales/Distribution ). ConditionType Condition type for material listing and exclusion ConditionTable Condition table SalesOrganization Sales organization DistributionChannel Distribution channel Division Division ConditionValidityEndDate Valid-to date of the condition record ConditionValidityStartDate Valid-from date of the condition record LastChangeDateTime Last change date (UTC time stamp) ProdUnivHierarchyNode Product hierarchy node This field always represents a product hierarchy subnode (that is, a text node for structuring purposes) in a condition record. CustomerHierarchyNodeType Customer hierarchy node type CustomerHierarchyNodeID Customer hierarchy node This field always represents a customer hierarchy subnode (that is, a text node or a business partner) in a condition record. CustomerHierarchyRootNode Root node of a customer hierarchy (that is, the customer hierarchy ID) SDDocumentCategory SD document category SalesDocumentType Sales document type Customer Customer CustomerGroup Customer group AdditionalCustomerGroup1 Customer group 1 AdditionalCustomerGroup2 Customer group 2 AdditionalCustomerGroup3 Customer group 3 AdditionalCustomerGroup4 Customer group 4 AdditionalCustomerGroup5 Customer group 5 CustomerConditionGroup1 Customer condition group 1 CustomerConditionGroup2 Customer condition group 2 CustomerConditionGroup3 Customer condition group 3 CustomerConditionGroup4 Customer condition group 4 CustomerConditionGroup5 Customer condition group 5 SoldToParty Sold-to party ShipToParty Ship-to party PayerParty Payer SalesEmployee Sales employee ForwardingAgent Forwarding agent Product Material (that is, product) ProductGroup Material group (that is, product group) AdditionalMaterialGroup1 Material group 1 AdditionalMaterialGroup2 Material group 2 AdditionalMaterialGroup3 Material group