I_SI_StRpRblsPyblsNonResidentC

DDL: I_SI_STRPRBLSPYBLSNONRESIDENTC Type: view_entity COMPOSITE Package: GLO_FIN_IS_SI_CBR_KRD
22 Fields 1 Data Sources

SI Receivables and Payables of Non-residents - Cube

I_SI_StRpRblsPyblsNonResidentC is a Composite CDS View (Cube) that provides data about "SI Receivables and Payables of Non-residents - Cube" in SAP S/4HANA. It reads from 1 data source (P_SI_CBRGLAcctLineItemPrprocg) and exposes 22 fields with key fields CompanyCode, Ledger, AccountingDocument, LedgerGLLineItem, FiscalYear. Part of development package GLO_FIN_IS_SI_CBR_KRD.

Data Sources (1)

SourceAliasJoin Type
P_SI_CBRGLAcctLineItemPrprocg AccountingDocument from

Annotations (11)

NameValueLevelField
EndUserText.label SI Receivables and Payables of Non-residents - Cube view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.internalName #LOCAL view
Analytics.technicalName ISRSIRBSPBSNRESC view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SI_CBRGLAcctLineItemPrprocg CompanyCode Receiver Company Code
KEY Ledger P_SI_CBRGLAcctLineItemPrprocg SourceLedger Source Ledger
KEY AccountingDocument P_SI_CBRGLAcctLineItemPrprocg AccountingDocument Journal Entry
KEY LedgerGLLineItem P_SI_CBRGLAcctLineItemPrprocg LedgerGLLineItem Journal Entry Item
KEY FiscalYear P_SI_CBRGLAcctLineItemPrprocg FiscalYear G/L Fiscal Year
KEY StatryRptCategory StRpLog StatryRptCategory Report ID
KEY StatryRptRunID StRpLog StatryRptRunID Report Run ID
KEY StatryRptgEntity StRpLog StatryRptgEntity Reporting Entity
Supplier P_SI_CBRGLAcctLineItemPrprocg Supplier Supplier
Customer P_SI_CBRGLAcctLineItemPrprocg Customer Sold-to Party
FinancialAccountType P_SI_CBRGLAcctLineItemPrprocg FinancialAccountType Fin. Account Type
ClearingDate P_SI_CBRGLAcctLineItemPrprocg ClearingDate Clearing Date
ClearingJournalEntry P_SI_CBRGLAcctLineItemPrprocg ClearingJournalEntry Clrng doc.
PostingDate P_SI_CBRGLAcctLineItemPrprocg PostingDate Posting Date for GR
DocumentDate P_SI_CBRGLAcctLineItemPrprocg DocumentDate Journal Entry Date
NetDueDate P_SI_CBRGLAcctLineItemPrprocg NetDueDate Net Due Date
DebitCreditCode P_SI_CBRGLAcctLineItemPrprocg DebitCreditCode Single-Character Flag
GLAccount P_SI_CBRGLAcctLineItemPrprocg GLAccount General Ledger
BalanceTransactionCurrency P_SI_CBRGLAcctLineItemPrprocg BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy P_SI_CBRGLAcctLineItemPrprocg AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
Country P_SI_CBRGLAcctLineItemPrprocg Country Venue: Ctry/Reg
SI_IncomeTypeendasSI_IncomeType

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_SI_StRpRblsPyblsNonResidentC.
-- 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.

CREATE VIEW I_SI_StRpRblsPyblsNonResidentC AS
SELECT
  AccountingDocument.CompanyCode AS CompanyCode,
  AccountingDocument.SourceLedger AS Ledger,
  AccountingDocument.AccountingDocument AS AccountingDocument,
  AccountingDocument.LedgerGLLineItem AS LedgerGLLineItem,
  AccountingDocument.FiscalYear AS FiscalYear,
  StRpLog.StatryRptCategory AS StatryRptCategory,
  StRpLog.StatryRptRunID AS StatryRptRunID,
  StRpLog.StatryRptgEntity AS StatryRptgEntity,
  AccountingDocument.Supplier AS Supplier,
  AccountingDocument.Customer AS Customer,
  AccountingDocument.FinancialAccountType AS FinancialAccountType,
  AccountingDocument.ClearingDate AS ClearingDate,
  AccountingDocument.ClearingJournalEntry AS ClearingJournalEntry,
  AccountingDocument.PostingDate AS PostingDate,
  AccountingDocument.DocumentDate AS DocumentDate,
  AccountingDocument.NetDueDate AS NetDueDate,
  AccountingDocument.DebitCreditCode AS DebitCreditCode,
  AccountingDocument.GLAccount AS GLAccount,
  AccountingDocument.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  AccountingDocument.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  AccountingDocument.Country AS Country,
  case when Log.SI_IncomeType is not initial and Log.SI_IncomeType is not null then Log.SI_IncomeType else GLCustomizing.SI_IncomeType end as SI_IncomeType AS SI_IncomeTypeendasSI_IncomeType
FROM P_SI_CBRGLAcctLineItemPrprocg AS AccountingDocument
;

Learn More