A_SlsMatlLstgOrExclsnRecord

DDL: A_SLSMATLLSTGOREXCLSNRECORD Type: view_entity CONSUMPTION Package: ODATA_SD_MD_LSTG_EXCLSN
67 Fields 1 Data Sources 1 OData Services

Condition Record

A_SlsMatlLstgOrExclsnRecord is a Consumption CDS View that provides data about "Condition Record" in SAP S/4HANA. It reads from 1 data source (R_SlsMatlLstgOrExclsnRecordTP) and exposes 67 fields with key field SlsMatlLstgOrExclsnRecordUUID. It is exposed through 1 OData service (API_SLSMATLLSTGOREXCLSNRECORD). Part of development package ODATA_SD_MD_LSTG_EXCLSN.

Data Sources (1)

SourceAliasJoin Type
R_SlsMatlLstgOrExclsnRecordTP R_SlsMatlLstgOrExclsnRecordTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Condition Record view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey SlsMatlLstgOrExclsnRecordUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name SlsMatlLstgOrExclsnRecord_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_SLSMATLLSTGOREXCLSNRECORD API_SLSMATLLSTGOREXCLSNRECORD V4 C2 C1

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY SlsMatlLstgOrExclsnRecordUUID SlsMatlLstgOrExclsnRecordUUID
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
ConditionTable ConditionTable Condition Table
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ConditionValidityEndDate ConditionValidityEndDate Valid To
ConditionValidityStartDate ConditionValidityStartDate Valid From
LastChangeDateTime LastChangeDateTime Timestamp
CustomerHierarchyNodeType CustomerHierarchyNodeType
CustomerHierarchyNodeID CustomerHierarchyNodeID
CustomerHierarchyRootNode CustomerHierarchyRootNode
SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentType SalesDocumentType Sales Doc. Type
Customer Customer Sold-to Party
CustomerGroup CustomerGroup Customer Group
CustomerConditionGroup1 CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 CustomerConditionGroup5 Condition grp 5
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
PayerParty PayerParty Payer
SalesEmployee SalesEmployee Sales Employee
ForwardingAgent ForwardingAgent
virtualProduct_Hrap_null_value_indicator
Product Product Product Sold
ProductType ProductType Product Type Group
ProductGroup ProductGroup Product Sold Group
UnitOfMeasure UnitOfMeasure Unit Protected Qty
MaterialPricingGroup MaterialPricingGroup
OriginallyRequestedMaterial OriginallyRequestedMaterial
PricingReferenceMaterial PricingReferenceMaterial Pr. Ref. Matl
ProdUnivHierarchyNode ProdUnivHierarchyNode
AdditionalMaterialGroup1 AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 AdditionalMaterialGroup5 MaterialGroup 5
SalesOffice SalesOffice Sales Office
virtualPlant_Hrap_null_value_indicator
Plant Plant Valuation Area
PlantCounty PlantCounty County-Dlv.Plnt
PlantRegion PlantRegion Region-Dlv.Plnt
PlantCity PlantCity City-Dlv.Plant
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
InternationalArticleNumber InternationalArticleNumber EAN/UPC
DepartureCountry DepartureCountry Departure Country / Region
DestinationCountry DestinationCountry Dest. Ctry/Reg
virtualRegion_Hrap_null_value_indicator
Region Region Venue Region
virtualBatch_Hrap_null_value_indicator
Batch Batch Lot No.
CompanyCode CompanyCode Receiver Company Code
PurchasingInfoRecord PurchasingInfoRecord Info Record
CountryOfOrigin CountryOfOrigin Country/Region of Origin
CustomerPriceGroup CustomerPriceGroup CustPrice Group
ShippingCondition ShippingCondition Shipping Conditions
ProductSalesStatus ProductSalesStatus Status

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 A_SlsMatlLstgOrExclsnRecord.
-- 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 A_SlsMatlLstgOrExclsnRecord AS
SELECT
  SlsMatlLstgOrExclsnRecordUUID,
  ConditionApplication,
  ConditionType,
  ConditionTable,
  SalesOrganization,
  DistributionChannel,
  Division,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  LastChangeDateTime,
  CustomerHierarchyNodeType,
  CustomerHierarchyNodeID,
  CustomerHierarchyRootNode,
  SDDocumentCategory,
  SalesDocumentType,
  Customer,
  CustomerGroup,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SoldToParty,
  ShipToParty,
  PayerParty,
  SalesEmployee,
  ForwardingAgent,
  virtual Product_H : rap_null_value_indicator AS virtualProduct_Hrap_null_value_indicator,
  Product,
  ProductType,
  ProductGroup,
  UnitOfMeasure,
  MaterialPricingGroup,
  OriginallyRequestedMaterial,
  PricingReferenceMaterial,
  ProdUnivHierarchyNode,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  SalesOffice,
  virtual Plant_H : rap_null_value_indicator AS virtualPlant_Hrap_null_value_indicator,
  Plant,
  PlantCounty,
  PlantRegion,
  PlantCity,
  IncotermsClassification,
  IncotermsTransferLocation,
  InternationalArticleNumber,
  DepartureCountry,
  DestinationCountry,
  virtual Region_H : rap_null_value_indicator AS virtualRegion_Hrap_null_value_indicator,
  Region,
  virtual Batch_H : rap_null_value_indicator AS virtualBatch_Hrap_null_value_indicator,
  Batch,
  CompanyCode,
  PurchasingInfoRecord,
  CountryOfOrigin,
  CustomerPriceGroup,
  ShippingCondition,
  ProductSalesStatus
FROM R_SlsMatlLstgOrExclsnRecordTP
;

Learn More