FARMLVD_BSITM_CLRTYP

DDL: FARMLVD_BSITM_CLRTYP SQL: FMVBSITMCLRTYP Type: view
13 Fields 2 Data Sources

Cleared Bank Statement Type

FARMLVD_BSITM_CLRTYP is a CDS View that provides data about "Cleared Bank Statement Type" in SAP S/4HANA. It reads from 2 data sources (I_Arbankstatementitem, FARMLVD_COMPANY) and exposes 13 fields.

Data Sources (2)

SourceAliasJoin Type
I_Arbankstatementitem BankStmtItm from
FARMLVD_COMPANY CompanyCtryKey left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FMVBSITMCLRTYP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Cleared Bank Statement Type view

Fields (13)

KeyFieldSource TableSource FieldDescription
CompanyCode I_Arbankstatementitem CompanyCode Receiver Company Code
CountryKey FARMLVD_COMPANY CountryKey Country/Reg.
BankStatementShortID I_Arbankstatementitem BankStatementShortID Statement Short Key
BankStatementItem I_Arbankstatementitem BankStatementItem Memo Record No.
BankLedgerDocument I_Arbankstatementitem BankLedgerDocument
SubledgerDocument I_Arbankstatementitem SubledgerDocument
SubledgerOnAccountDocument I_Arbankstatementitem SubledgerOnAccountDocument
BankLedgerOnAccountDocument I_Arbankstatementitem BankLedgerOnAccountDocument
FiscalYear I_Arbankstatementitem FiscalYear G/L Fiscal Year
PostingDate I_Arbankstatementitem PostingDate Posting Date for GR
AmountInOriginalCurrency I_Arbankstatementitem AmountInOriginalCurrency
AmountInTransactionCurrency I_Arbankstatementitem AmountInTransactionCurrency Pt Crcy Amt
DebitCreditCode I_Arbankstatementitem DebitCreditCode Single-Character Flag

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 FARMLVD_BSITM_CLRTYP.
-- 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: FMVBSITMCLRTYP

CREATE VIEW FARMLVD_BSITM_CLRTYP AS
SELECT
  BankStmtItm.CompanyCode AS CompanyCode,
  CompanyCtryKey.CountryKey AS CountryKey,
  BankStmtItm.BankStatementShortID AS BankStatementShortID,
  BankStmtItm.BankStatementItem AS BankStatementItem,
  BankStmtItm.BankLedgerDocument AS BankLedgerDocument,
  BankStmtItm.SubledgerDocument AS SubledgerDocument,
  BankStmtItm.SubledgerOnAccountDocument AS SubledgerOnAccountDocument,
  BankStmtItm.BankLedgerOnAccountDocument AS BankLedgerOnAccountDocument,
  BankStmtItm.FiscalYear AS FiscalYear,
  BankStmtItm.PostingDate AS PostingDate,
  BankStmtItm.AmountInOriginalCurrency AS AmountInOriginalCurrency,
  BankStmtItm.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BankStmtItm.DebitCreditCode AS DebitCreditCode
FROM I_Arbankstatementitem AS BankStmtItm
LEFT OUTER JOIN FARMLVD_COMPANY AS CompanyCtryKey ON /* join condition not captured in parsed metadata */
;

Learn More