I_BhvrlInsgtsWriteOff

DDL: I_BHVRLINSGTSWRITEOFF SQL: IBIWOFF Type: view_entity BASIC
16 Fields 2 Data Sources

Write Off Data

I_BhvrlInsgtsWriteOff is a Basic CDS View that provides data about "Write Off Data" in SAP S/4HANA. It reads from 2 data sources (dfkkop, dfkkwoh) and exposes 16 fields with key fields CAWriteOffDocumentNumber, CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (2)

SourceAliasJoin Type
dfkkop dfk inner
dfkkwoh dfkkwoh from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Write Off Data view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CAWriteOffDocumentNumber dfkkwoh abbel Write-OffDocNo.
KEY CADocumentNumber dfkkwoh opbel Reopen
KEY CARepetitionItemNumber dfkkwoh opupw Repetition Item
KEY CABPItemNumber dfkkwoh opupk Item
KEY CASubItemNumber dfkkwoh opupz Subitem
CustomerEventRecordID
CompanyCode dfkkwoh bukrs Value
BusinessPartner dfkkwoh gpart Tech. BPartner
ContractAccount dfkkwoh vkont Tech. CtrAcct
CAWriteOffDate dfkkwoh abdat Store Until
CAWriteOffReason dfkkwoh abgrd Write-Off Reas.
CAWriteOffIsReversed dfkkwoh xrvsd Reversed
CANetDueDate dfkkop faedn Net Due Date
TransactionCurrency dfkkop waers Transaction Currency
CAWriteOffAmountInTransCrcy
abdatendasCADaysToWriteOff

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_BhvrlInsgtsWriteOff.
-- 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: IBIWOFF

CREATE VIEW I_BhvrlInsgtsWriteOff AS
SELECT
  dfkkwoh.abbel AS CAWriteOffDocumentNumber,
  dfkkwoh.opbel AS CADocumentNumber,
  dfkkwoh.opupw AS CARepetitionItemNumber,
  dfkkwoh.opupk AS CABPItemNumber,
  dfkkwoh.opupz AS CASubItemNumber,
  cast(concat(dfkkwoh.abbel,concat(concat(dfkkwoh.opbel,dfkkwoh.opupw),concat(dfkkwoh.opupk,dfkkwoh.opupz))) as abap.char( 70 )) AS CustomerEventRecordID,
  dfkkwoh.bukrs AS CompanyCode,
  dfkkwoh.gpart AS BusinessPartner,
  dfkkwoh.vkont AS ContractAccount,
  dfkkwoh.abdat AS CAWriteOffDate,
  dfkkwoh.abgrd AS CAWriteOffReason,
  dfkkwoh.xrvsd AS CAWriteOffIsReversed,
  dfk.faedn AS CANetDueDate,
  dfk.waers AS TransactionCurrency,
  cast( dfkkwoh.betrw as abap.dec( 13,2 )) AS CAWriteOffAmountInTransCrcy,
  case when dfk.faedn > dfkkwoh.abdat then 0 else dats_days_between(dfk.faedn,dfkkwoh.abdat) end as CADaysToWriteOff AS abdatendasCADaysToWriteOff
FROM dfkkwoh
INNER JOIN dfkkop AS dfk ON /* join condition not captured in parsed metadata */
;

Learn More