I_CAWriteOffWorkflow

DDL: I_CAWRITEOFFWORKFLOW Type: view_entity BASIC
22 Fields 1 Data Sources

FICA Data for Write Off in Workflow

I_CAWriteOffWorkflow is a Basic CDS View that provides data about "FICA Data for Write Off in Workflow" in SAP S/4HANA. It reads from 1 data source (dfkkwrtoff_wf) and exposes 22 fields with key fields CAWriteOffWorkflowUUID, CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (1)

SourceAliasJoin Type
dfkkwrtoff_wf dfkkwrtoff_wf from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label FICA Data for Write Off in Workflow view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CAWriteOffWorkflowUUID guid UUID 22 char.
KEY CADocumentNumber opbel Reopen
KEY CARepetitionItemNumber opupw Repetition Item
KEY CABPItemNumber opupk Item
KEY CASubItemNumber opupz Subitem
CAClearingAmountInTransCrcy augbw TC Clearing Amt
CAReferenceDocument xblnr Reference
BusinessPartner gpart Tech. BPartner
ContractAccount vkont Tech. CtrAcct
CAContract vtref Contract
CAPostingDate budat Posting Date
DocumentDate bldat Journal Entry Date
CADocumentType blart Rep. rec. doc. type
CAReconciliationKey fikey Reconcil. Key
CAWriteOffReason abgrd Write-Off Reas.
CAWriteOffIsDoneWithoutChkRule xrule No Check Rules
CAIsSubmittedToCollAgency xcoll SubmCollectAgny
TransactionCurrency waers Transaction Currency
WriteOffResubmissionDate resdate Resubmission Date
CAContractIsFinallySettled ever_invoiced Invoiced
CASubApplication subap Subapplication
CACostAcctgAccountAssgmtKey cokey Correspond. Key

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_CAWriteOffWorkflow.
-- 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_CAWriteOffWorkflow AS
SELECT
  guid AS CAWriteOffWorkflowUUID,
  opbel AS CADocumentNumber,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  opupz AS CASubItemNumber,
  augbw AS CAClearingAmountInTransCrcy,
  xblnr AS CAReferenceDocument,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  vtref AS CAContract,
  budat AS CAPostingDate,
  bldat AS DocumentDate,
  blart AS CADocumentType,
  fikey AS CAReconciliationKey,
  abgrd AS CAWriteOffReason,
  xrule AS CAWriteOffIsDoneWithoutChkRule,
  xcoll AS CAIsSubmittedToCollAgency,
  waers AS TransactionCurrency,
  resdate AS WriteOffResubmissionDate,
  ever_invoiced AS CAContractIsFinallySettled,
  subap AS CASubApplication,
  cokey AS CACostAcctgAccountAssgmtKey
FROM dfkkwrtoff_wf
;

Learn More