FACVD_GLCASHMC_WLI_03

DDL: FACVD_GLCASHMC_WLI_03 Type: view
13 Fields 3 Data Sources

Cash account clearing worklist item

FACVD_GLCASHMC_WLI_03 is a CDS View that provides data about "Cash account clearing worklist item" in SAP S/4HANA. It reads from 3 data sources (bkpf, bseg, skb1) and exposes 13 fields with key fields bukrs, hkont, h_hwaer, hbkid, hktid.

Data Sources (3)

SourceAliasJoin Type
bkpf bkpf left_outer
bseg bseg left_outer
skb1 skb1 from

Parameters (1)

NameTypeDefault
to_budat abap.dats

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FACV_CASH_WLI_03 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cash account clearing worklist item view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY bukrs skb1 bukrs Value
KEY hkont bseg hkont Transfer acct
KEY h_hwaer bseg h_hwaer Local Currency
KEY hbkid bseg hbkid House Bank
KEY hktid bseg hktid House Bank Account
ktopl t001 ktopl G/L Chart of Accounts
ktop2 t001 ktop2 Alternative COA
butxt t001 butxt Posting Text
items_count
h_blart bseg h_blart Document Type
begru skb1 begru AuthorizGroup
altkt skb1 altkt Group Account Number
AuthorizationGroup I_HouseBankAccount AuthorizationGroup AuthorizGroup

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 FACVD_GLCASHMC_WLI_03.
-- 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.
-- Parameters: to_budat : abap.dats

CREATE VIEW FACVD_GLCASHMC_WLI_03 AS
SELECT
  skb1.bukrs AS bukrs,
  bseg.hkont AS hkont,
  bseg.h_hwaer AS h_hwaer,
  bseg.hbkid AS hbkid,
  bseg.hktid AS hktid,
  t001.ktopl AS ktopl,
  t001.ktop2 AS ktop2,
  t001.butxt AS butxt,
  count (*) AS items_count,
  bseg.h_blart AS h_blart,
  skb1.begru AS begru,
  skb1.altkt AS altkt,
  I_HouseBankAccount.AuthorizationGroup AS AuthorizationGroup
FROM skb1
LEFT OUTER JOIN bseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bkpf ON /* join condition not captured in parsed metadata */
;

Learn More