V_DOC_CURR

DDL: V_DOC_CURR SQL: V_DOC_CURR_CDS Type: view
30 Fields 1 Data Sources

Document Currency

V_DOC_CURR is a CDS View that provides data about "Document Currency" in SAP S/4HANA. It reads from 1 data source (vbak) and exposes 30 fields.

Data Sources (1)

SourceAliasJoin Type
vbak vbak inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_DOC_CURR_CDS view
EndUserText.label Document Currency view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
vbeln vbeln SD Sched. Agmt
dbtable
knumv knumv Doc. Condition
waerk waerk Doc. Currency
dbtable
knumv knumv Doc. Condition
waerk waerk Doc. Currency
dbtable
knumv knumv Doc. Condition
waerk waerk Doc. Currency
dbtable
knumv knumv Doc. Condition
waerk waers Doc. Currency
dbtable
knumv knumv Doc. Condition
waerk waers Doc. Currency
dbtable
knumv knumv Doc. Condition
waerk waers Doc. Currency
dbtable
knumv knumve Doc. Condition
waerk waers Doc. Currency
dbtable
knumv knumv Doc. Condition
waerk waers Doc. Currency
vbelnasvbeln
dbtable
knumv vpkhead knumv Doc. Condition
waerk vbak waerk Doc. Currency
erdat

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 V_DOC_CURR.
-- 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: V_DOC_CURR_CDS

CREATE VIEW V_DOC_CURR AS
SELECT
  vbeln,
  'VBAK' AS dbtable,
  knumv,
  waerk,
  '20111111' as erdat AS vbelnasvbeln,
  '20111111' AS erdat
INNER JOIN vbak ON /* join condition not captured in parsed metadata */
;

Learn More