I_IL_CashRegisterIntraday

DDL: I_IL_CASHREGISTERINTRADAY Type: view_entity COMPOSITE Package: RAP_GLO_FIN_CASH_IL_BALANCEREP
40 Fields 1 Data Sources

Cash Register Balance

I_IL_CashRegisterIntraday 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 40 fields with key fields IL_IdentifierCashPaymentItem, EntryTimestamp, 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 (40)

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.
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
P_Date
P_IL_CashNumberKey
KEY EntryTimestamp EntryTimestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
IL_CashNumberKey IL_CashNumberKey Cash Number
IL_PaymentMethod IL_PaymentMethod Payment Method
PaymentMethod PaymentMethod Pymt Meth.
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy Value Amount
TransactionCurrency TransactionCurrency Transaction Currency
IL_PaymentStatus IL_PaymentStatus Workflow Status
Customer Sold-to Party
Supplier Supplier
AccountingDocument RefAccountingDocument Document Number
CompanyCode ReferenceCompanyCode Company Code
FiscalYear ReferenceFiscalYear Original FY
IL_CreditCardReference Reference Number
IL_ChequeNumber Cheque Number
IL_ChequeDueDate Cheque Duedate
BankNumber Bank Key
BankAccount Bank acct
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeByUser 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_CashRegisterIntraday.
-- 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_CashRegisterIntraday 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.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 P_Date,
  P_IL_CashNumberKey: $parameters.P_IL_CashNumberKey AS P_IL_CashNumberKey,
  IL_PaytItmAmountInDocCrcy,
  RefAccountingDocument AS AccountingDocument,
  ReferenceCompanyCode AS CompanyCode,
  ReferenceFiscalYear AS FiscalYear,
  LastChangeByUser
FROM I_IL_PaymentItemLog AS Item
;

Learn More