I_BillingDocItemDownPaytCndn

DDL: I_BILLINGDOCITEMDOWNPAYTCNDN Type: view_entity COMPOSITE
14 Fields 1 Data Sources

Billing Document Down Payment Item

I_BillingDocItemDownPaytCndn is a Composite CDS View that provides data about "Billing Document Down Payment Item" in SAP S/4HANA. It reads from 1 data source (I_BillingDocItemDownPayt) and exposes 14 fields with key fields BillingDocument, BillingDocumentItem, TaxCode.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocItemDownPayt I_BillingDocItemDownPayt from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Billing Document Down Payment Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem Item
KEY TaxCode TaxCode Tax Code
ConditionRateValue ConditionRateValue Condition Rate Value
NetAmount
TransactionCurrency TransactionCurrency Transaction Currency
ReturnItemProcessingType ReturnItemProcessingType Returns
TaxAmount
GrossAmount
ConditionApplication ConditionApplication Application
ConditionClass ConditionClass Condition Class
ConditionCategory ConditionCategory Condit.Category
ConditionInactiveReason ConditionInactiveReason Inactive
ConditionIsForStatistics ConditionIsForStatistics Statistical

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 I_BillingDocItemDownPaytCndn.
-- 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 I_BillingDocItemDownPaytCndn AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  TaxCode,
  ConditionRateValue,
  abs(NetAmount) AS NetAmount,
  TransactionCurrency,
  ReturnItemProcessingType,
  abs(TaxAmount) AS TaxAmount,
  NetAmount + TaxAmount AS GrossAmount,
  ConditionApplication,
  ConditionClass,
  ConditionCategory,
  ConditionInactiveReason,
  ConditionIsForStatistics
FROM I_BillingDocItemDownPayt
;

Learn More