I_IL_CashRegisterOpenBalance

DDL: I_IL_CASHREGISTEROPENBALANCE Type: view_entity COMPOSITE Package: RAP_GLO_FIN_CASH_IL_BALANCEREP
20 Fields 1 Data Sources

Cash Register Balance

I_IL_CashRegisterOpenBalance is a Composite CDS View (Fact) that provides data about "Cash Register Balance" in SAP S/4HANA. It reads from 1 data source (I_IL_PaymentItemLog) and exposes 20 fields with key fields IL_IdentifierCashPaymentItem, EntryTimestamp. Part of development package RAP_GLO_FIN_CASH_IL_BALANCEREP.

Data Sources (1)

SourceAliasJoin Type
I_IL_PaymentItemLog Item from

Parameters (3)

NameTypeDefault
P_Date datum
P_IL_CashNumberKey gsfincsil_csnum
P_Currency waers

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cash Register Balance view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #FACT view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY IL_IdentifierCashPaymentItem I_IL_PaymentItemLog IL_IdentifierCashPaymentItem Payment ID
KEY EntryTimestamp I_IL_PaymentItemLog EntryTimestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
IL_CashNumberKey I_IL_PaymentItemLog IL_CashNumberKey Cash Number
IL_PaymentMethod I_IL_PaymentItemLog IL_PaymentMethod Payment Method
PaymentMethod I_IL_PaymentItemLog PaymentMethod Pymt Meth.
IL_PaytItmAmountInDocCrcy I_IL_PaymentItemLog IL_PaytItmAmountInDocCrcy Value Amount
TransactionCurrency I_IL_PaymentItemLog TransactionCurrency Transaction Currency
IL_PaymentStatus I_IL_PaymentItemLog IL_PaymentStatus Workflow Status
Customer I_IL_PaymentItemLog Customer Sold-to Party
Supplier I_IL_PaymentItemLog Supplier Supplier
ReferenceCompanyCodeendasCompanyCode
ReferenceFiscalYearendasFiscalYear
IL_CreditCardReference I_IL_PaymentItemLog IL_CreditCardReference Reference Number
IL_ChequeNumber I_IL_PaymentItemLog IL_ChequeNumber Cheque Number
IL_ChequeDueDate I_IL_PaymentItemLog IL_ChequeDueDate Cheque Duedate
BankNumber I_IL_PaymentItemLog BankNumber Bank Key
BankAccount I_IL_PaymentItemLog BankAccount Bank acct
LastChangeDate I_IL_PaymentItemLog LastChangeDate Time Stamp
LastChangeTime I_IL_PaymentItemLog LastChangeTime Time changed
LastChangeByUser I_IL_PaymentItemLog LastChangeByUser User Name

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_IL_CashRegisterOpenBalance.
-- 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: P_Date : datum, P_IL_CashNumberKey : gsfincsil_csnum, P_Currency : waers

CREATE VIEW I_IL_CashRegisterOpenBalance AS
SELECT
  Item.IL_IdentifierCashPaymentItem AS IL_IdentifierCashPaymentItem,
  Item.EntryTimestamp AS EntryTimestamp,
  Item.IL_CashNumberKey AS IL_CashNumberKey,
  Item.IL_PaymentMethod AS IL_PaymentMethod,
  Item.PaymentMethod AS PaymentMethod,
  Item.IL_PaytItmAmountInDocCrcy AS IL_PaytItmAmountInDocCrcy,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.IL_PaymentStatus AS IL_PaymentStatus,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  case when Item.RefAccountingDocument is null then Item.CompanyCode when Item.RefAccountingDocument = '' then Item.CompanyCode else Item.ReferenceCompanyCode end as CompanyCode AS ReferenceCompanyCodeendasCompanyCode,
  case when Item.RefAccountingDocument is null then Item.FiscalYear when Item.RefAccountingDocument = '' then Item.FiscalYear else Item.ReferenceFiscalYear end as FiscalYear AS ReferenceFiscalYearendasFiscalYear,
  Item.IL_CreditCardReference AS IL_CreditCardReference,
  Item.IL_ChequeNumber AS IL_ChequeNumber,
  Item.IL_ChequeDueDate AS IL_ChequeDueDate,
  Item.BankNumber AS BankNumber,
  Item.BankAccount AS BankAccount,
  Item.LastChangeDate AS LastChangeDate,
  Item.LastChangeTime AS LastChangeTime,
  Item.LastChangeByUser AS LastChangeByUser
FROM I_IL_PaymentItemLog AS Item
;

Learn More