view_o2c_fica_wl_crde

DDL: VIEW_FICA_WL_CRDE SQL: V_O2C_FICA_WLCD Type: view
12 Fields 3 Data Sources

CDS View Credits and Debits for Business Partner

view_o2c_fica_wl_crde is a CDS View that provides data about "CDS View Credits and Debits for Business Partner" in SAP S/4HANA. It reads from 3 data sources (dfkkop, dfkkop, dfkkopw) and exposes 12 fields with key fields opbel, opupk, opupw, opupz, opupk.

Data Sources (3)

SourceAliasJoin Type
dfkkop dfkkop from
dfkkop op union_all
dfkkopw opw inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_O2C_FICA_WLCD view
EndUserText.label CDS View Credits and Debits for Business Partner view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.buffering.type #NONE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY opbel opbel Reduction Amt
KEY opupk opupk Item
KEY opupw opupw Repetition Item
KEY opupz opupz Subitem
gpart gpart Tech. BPartner
waers waers Transaction Currency
opbel Reduction Amt
KEY opupk dfkkop opupk Item
KEY opupw dfkkopw opupw Repetition Item
KEY opupz dfkkop opupz Subitem
gpart dfkkop gpart Tech. BPartner
waers dfkkop waers Transaction Currency

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 view_o2c_fica_wl_crde.
-- 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_O2C_FICA_WLCD

CREATE VIEW view_o2c_fica_wl_crde AS
SELECT
  opbel,
  opupk,
  opupw,
  opupz,
  gpart,
  waers
FROM dfkkop
INNER JOIN dfkkopw AS opw ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): dfkkop
;

Learn More