C_SalesDocItemDownPayt

DDL: C_SALESDOCITEMDOWNPAYT SQL: CSLSDOCITMDP Type: view CONSUMPTION
21 Fields 1 Data Sources 2 Associations

Sales Document Down payment item

C_SalesDocItemDownPayt is a Consumption CDS View that provides data about "Sales Document Down payment item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 21 fields with key fields SalesDocument, SalesDocumentItem, SubsequentDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItem I_SalesDocumentItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SalesDocItemPricingElement _PricingElement $projection.SalesDocument = _PricingElement.SalesDocument and $projection.SalesDocumentItem = _PricingElement.SalesDocumentItem and _PricingElement.ConditionApplication = 'V' and _PricingElement.ConditionClass = 'D' and _PricingElement.ConditionCategory = 'D' and _PricingElement.ConditionInactiveReason = '' and _PricingElement.ConditionIsForStatistics = ''
[1..*] I_SDDocumentMultiLevelProcFlow _SubsequentDoc $projection.SalesDocument = _SubsequentDoc.PrecedingDocument and $projection.SalesDocumentItem = _SubsequentDoc.PrecedingDocumentItem and $projection.SDDocumentCategory = _SubsequentDoc.PrecedingDocumentCategory and _SubsequentDoc.SubsequentDocumentCategory = 'M'

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CSLSDOCITMDP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Document Down payment item view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
KEY SubsequentDocument _SubsequentDocument SubsequentDocument
Material Material Vehicle Model
SDDocumentCategory SDDocumentCategory Document Cat.
SalesDocumentItemText SalesDocumentItemText Item Descr.
_MaterialText _MaterialText
ConditionRateValue _PricingElement ConditionRateValue Condition Rate Value
TaxCode _PricingElement TaxCode Tax Code
OrderQuantity OrderQuantity Quantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
NetAmount NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
TaxAmount TaxAmount Tax Amt in Rptg Crcy
ConditionAmount _PricingElement ConditionAmount Condition Value
ConditionType _PricingElement ConditionType Condition type
ConditionQuantity _PricingElement ConditionQuantity Pricing Unit
ConditionQuantityUnit _PricingElement ConditionQuantityUnit Unit of Measure
ConditionCurrency _PricingElement ConditionCurrency Currency
_SubsequentDoc _SubsequentDoc
_PricingElement _PricingElement

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_SalesDocItemDownPayt.
-- 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.
-- SQL view name: CSLSDOCITMDP

CREATE VIEW C_SalesDocItemDownPayt AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  _SubsequentDocument.SubsequentDocument AS SubsequentDocument,
  Material,
  SDDocumentCategory,
  SalesDocumentItemText,
  _PricingElement.ConditionRateValue AS ConditionRateValue,
  _PricingElement.TaxCode AS TaxCode,
  OrderQuantity,
  OrderQuantityUnit,
  NetAmount,
  TransactionCurrency,
  TaxAmount,
  _PricingElement.ConditionAmount AS ConditionAmount,
  _PricingElement.ConditionType AS ConditionType,
  _PricingElement.ConditionQuantity AS ConditionQuantity,
  _PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  _PricingElement.ConditionCurrency AS ConditionCurrency
FROM I_SalesDocumentItem
LEFT OUTER JOIN I_SalesDocItemPricingElement AS _PricingElement ON SalesDocument = _PricingElement.SalesDocument AND SalesDocumentItem = _PricingElement.SalesDocumentItem AND _PricingElement.ConditionApplication = 'V' AND _PricingElement.ConditionClass = 'D' AND _PricingElement.ConditionCategory = 'D' AND _PricingElement.ConditionInactiveReason = '' AND _PricingElement.ConditionIsForStatistics = ''  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentMultiLevelProcFlow AS _SubsequentDoc ON SalesDocument = _SubsequentDoc.PrecedingDocument AND SalesDocumentItem = _SubsequentDoc.PrecedingDocumentItem AND SDDocumentCategory = _SubsequentDoc.PrecedingDocumentCategory AND _SubsequentDoc.SubsequentDocumentCategory = 'M'  -- association [1..*]
;

Learn More