A_SlsMatlDeterminationRecord

DDL: A_SLSMATLDETERMINATIONRECORD Type: view_entity CONSUMPTION Package: ODATA_SD_MD_MATL_DETN
47 Fields 1 Data Sources 1 OData Services

Condition Record

A_SlsMatlDeterminationRecord is a Consumption CDS View that provides data about "Condition Record" in SAP S/4HANA. It reads from 1 data source (R_SlsMatlDeterminationRecordTP) and exposes 47 fields with key field ConditionRecord. It is exposed through 1 OData service (API_SLSMATLDETERMINATIONRECORD). Part of development package ODATA_SD_MD_MATL_DETN.

Data Sources (1)

SourceAliasJoin Type
R_SlsMatlDeterminationRecordTP R_SlsMatlDeterminationRecordTP projection

Annotations (11)

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

OData Services (1)

ServiceBindingVersionContractRelease
API_SLSMATLDETERMINATIONRECORD API_SLSMATLDETERMINATIONRECORD V4 C2 C1

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord ConditionRecord Cond.Record No.
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
SlsMatlDetnSubstituteMaterial SlsMatlDetnSubstituteMaterial
SlsMatlDetnSubstitMaterialUoM SlsMatlDetnSubstitMaterialUoM
MaterialSubstitutionReason MaterialSubstitutionReason
ConditionValidityEndDate ConditionValidityEndDate Valid To
ConditionValidityStartDate ConditionValidityStartDate Valid From
LastChangeDateTime LastChangeDateTime Timestamp
SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentType SalesDocumentType Sales Doc. Type
Customer Customer Sold-to Party
CustomerGroup CustomerGroup Customer Group
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
MaterialPricingGroup MaterialPricingGroup
OriginallyRequestedMaterial OriginallyRequestedMaterial
PricingReferenceMaterial PricingReferenceMaterial Pr. Ref. Matl
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
virtualCounty_Hrap_null_value_indicator
County County Wyoming County
DepartureCountry DepartureCountry Departure Country / Region
DestinationCountry DestinationCountry Dest. Ctry/Reg
virtualRegion_Hrap_null_value_indicator
Region Region Venue Region
CityCode CityCode IATA: City
virtualBatch_Hrap_null_value_indicator
Batch Batch Lot No.
CompanyCode CompanyCode Receiver Company Code
PurchasingInfoRecord PurchasingInfoRecord Info Record

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_SlsMatlDeterminationRecord.
-- 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_SlsMatlDeterminationRecord AS
SELECT
  ConditionRecord,
  ConditionApplication,
  ConditionType,
  ConditionTable,
  SalesOrganization,
  DistributionChannel,
  Division,
  SlsMatlDetnSubstituteMaterial,
  SlsMatlDetnSubstitMaterialUoM,
  MaterialSubstitutionReason,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  LastChangeDateTime,
  SDDocumentCategory,
  SalesDocumentType,
  Customer,
  CustomerGroup,
  SoldToParty,
  ShipToParty,
  PayerParty,
  SalesEmployee,
  ForwardingAgent,
  virtual Product_H : rap_null_value_indicator AS virtualProduct_Hrap_null_value_indicator,
  Product,
  ProductType,
  ProductGroup,
  MaterialPricingGroup,
  OriginallyRequestedMaterial,
  PricingReferenceMaterial,
  virtual Plant_H : rap_null_value_indicator AS virtualPlant_Hrap_null_value_indicator,
  Plant,
  PlantCounty,
  PlantRegion,
  PlantCity,
  IncotermsClassification,
  IncotermsTransferLocation,
  virtual County_H : rap_null_value_indicator AS virtualCounty_Hrap_null_value_indicator,
  County,
  DepartureCountry,
  DestinationCountry,
  virtual Region_H : rap_null_value_indicator AS virtualRegion_Hrap_null_value_indicator,
  Region,
  CityCode,
  virtual Batch_H : rap_null_value_indicator AS virtualBatch_Hrap_null_value_indicator,
  Batch,
  CompanyCode,
  PurchasingInfoRecord
FROM R_SlsMatlDeterminationRecordTP
;

Learn More