Fapvd_Vendor_Bal_5

DDL: FAPVD_VENDOR_BAL_5 SQL: FAPV_VEND_BAL_5 Type: view Package: FINS_AP_CORE
23 Fields 1 Data Sources

Supplier Balance Intermediate View

Fapvd_Vendor_Bal_5 is a CDS View that provides data about "Supplier Balance Intermediate View" in SAP S/4HANA. It reads from 1 data source (bseg) and exposes 23 fields. Part of development package FINS_AP_CORE.

Data Sources (1)

SourceAliasJoin Type
bseg bseg from

Parameters (1)

NameTypeDefault
P_BaseCurrencyForDisplay farp_bal_base_curr_for_display

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAPV_VEND_BAL_5 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Supplier 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 (23)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
lifnr lifnr Vendor no.
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
dmbtr dmbtr Loc. amount
fcsl fcsl Amount in FunctCrcy
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
BaseCurrencyForDisplay

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 Fapvd_Vendor_Bal_5.
-- 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: FAPV_VEND_BAL_5
-- Parameters: P_BaseCurrencyForDisplay : farp_bal_base_curr_for_display

CREATE VIEW Fapvd_Vendor_Bal_5 AS
SELECT
  mandt,
  lifnr,
  bukrs,
  gjahr,
  umskz,
  h_monat,
  xnegp,
  shkzg,
  dmbtr,
  fcsl,
  xumsw,
  zfbdt,
  augdt,
  h_bldat,
  h_budat,
  augbl,
  netdt,
  koart,
  rebzg,
  rebzt,
  umsks,
  h_bstat,
  $parameters.P_BaseCurrencyForDisplay AS BaseCurrencyForDisplay
FROM bseg
;

Learn More