Farvd_Cust_Bal_4

DDL: FARVD_CUST_BAL_4 SQL: FARV_CUST_BAL_4 Type: view
20 Fields 1 Data Sources

Customer Balance Intermediate View

Farvd_Cust_Bal_4 is a CDS View that provides data about "Customer Balance Intermediate View" in SAP S/4HANA. It reads from 1 data source (Farvd_Cust_Bal_5) and exposes 20 fields.

Data Sources (1)

SourceAliasJoin Type
Farvd_Cust_Bal_5 Farvd_Cust_Bal_5 from

Parameters (1)

NameTypeDefault
P_BaseCurrencyForDisplay farp_bal_base_curr_for_display

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FARV_CUST_BAL_4 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Customer Balance Intermediate View view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
kunnr kunnr Stock customer
bukrs bukrs Value
gjahr gjahr Settlement Year
umskz umskz Special G/L Ind
h_monat h_monat Period
xnegp xnegp Reversl Posting Type
shkzg shkzg Returns
xumsw xumsw Sales-Related
zfbdt zfbdt Payment date
augdt augdt Clearing
h_bldat h_bldat Document Date
h_budat h_budat Posting Date
augbl augbl Clrng doc.
netdt netdt Due On
koart koart Account type
rebzg rebzg Invoice Ref.
rebzt rebzt Follow-On Doc. Type
umsks umsks Transact.Type
h_bstat h_bstat Document Status

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 Farvd_Cust_Bal_4.
-- 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: FARV_CUST_BAL_4
-- Parameters: P_BaseCurrencyForDisplay : farp_bal_base_curr_for_display

CREATE VIEW Farvd_Cust_Bal_4 AS
SELECT
  mandt,
  kunnr,
  bukrs,
  gjahr,
  umskz,
  h_monat,
  xnegp,
  shkzg,
  xumsw,
  zfbdt,
  augdt,
  h_bldat,
  h_budat,
  augbl,
  netdt,
  koart,
  rebzg,
  rebzt,
  umsks,
  h_bstat
FROM Farvd_Cust_Bal_5
;

Learn More