view_o2c_fica_woh_bp

DDL: VIEW_FICA_WOH_BP SQL: V_O2C_FICA_WOHBP Type: view Package: ODATA_O2C_FICA_WRITEOFF
18 Fields 1 Data Sources

CDS View Writeoff History For Business Partner

view_o2c_fica_woh_bp is a CDS View that provides data about "CDS View Writeoff History For Business Partner" in SAP S/4HANA. It reads from 1 data source (dfkkwoh) and exposes 18 fields with key fields abbel, opbel, opupk, opupw, opupz. Part of development package ODATA_O2C_FICA_WRITEOFF.

Data Sources (1)

SourceAliasJoin Type
dfkkwoh wo from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName V_O2C_FICA_WOHBP view
EndUserText.label CDS View Writeoff History 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
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY abbel dfkkwoh abbel Write-OffDocNo.
KEY opbel dfkkwoh opbel Reopen
KEY opupk dfkkwoh opupk Item
KEY opupw dfkkwoh opupw Repetition Item
KEY opupz dfkkwoh opupz Subitem
vktyp ca vktyp Date type
bukrs dfkkwoh bukrs Value
abdat dfkkwoh abdat Store Until
waers dfkkwoh waers Transaction Currency
betrw dfkkwoh betrw Reduction Amt
gpart dfkkwoh gpart Tech. BPartner
name_first bp name_first First Name
name_last bp name_last Last Name
wonumber
pertype
pernumber
perfrom
perto

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_woh_bp.
-- 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_WOHBP

CREATE VIEW view_o2c_fica_woh_bp AS
SELECT
  wo.abbel AS abbel,
  wo.opbel AS opbel,
  wo.opupk AS opupk,
  wo.opupw AS opupw,
  wo.opupz AS opupz,
  ca.vktyp AS vktyp,
  wo.bukrs AS bukrs,
  wo.abdat AS abdat,
  wo.waers AS waers,
  wo.betrw AS betrw,
  wo.gpart AS gpart,
  bp.name_first AS name_first,
  bp.name_last AS name_last,
  cast(1 as abap.int4) AS wonumber,
  cast('' as abap.char(1)) AS pertype,
  cast(1 as abap.int2) AS pernumber,
  cast('' as abap.char(8)) AS perfrom,
  cast('' as abap.char(8)) AS perto
FROM dfkkwoh AS wo
;

Learn More