C_SI_StRpLineItemNonResidentC

DDL: C_SI_STRPLINEITEMNONRESIDENTC Type: view_entity CONSUMPTION
34 Fields 1 Data Sources

BST Line Items SI Nonresidents - Cube

C_SI_StRpLineItemNonResidentC is a Consumption CDS View (Cube) that provides data about "BST Line Items SI Nonresidents - Cube" in SAP S/4HANA. It reads from 1 data source (P_SI_LineItemsNonResident) and exposes 34 fields with key fields CompanyCode, AccountingDocument, FiscalYear, Ledger, LedgerGLLineItem.

Data Sources (1)

SourceAliasJoin Type
P_SI_LineItemsNonResident LNIT from

Parameters (3)

NameTypeDefault
P_PurposeTradeIsGoods sifi_bst_goods_block
P_PurposeTradeIsService sifi_bst_services_block
P_PurposeTradeIsTransfer sifi_bst_transfers_block

Annotations (11)

NameValueLevelField
EndUserText.label BST Line Items SI Nonresidents - Cube view
VDM.viewType #CONSUMPTION 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 CSISTRPLNNRC view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SI_LineItemsNonResident CompanyCode Receiver Company Code
KEY AccountingDocument P_SI_LineItemsNonResident AccountingDocument Journal Entry
KEY FiscalYear P_SI_LineItemsNonResident FiscalYear G/L Fiscal Year
KEY Ledger P_SI_LineItemsNonResident Ledger Ledger
KEY LedgerGLLineItem P_SI_LineItemsNonResident LedgerGLLineItem Journal Entry Item
KEY StatryRptCategory Log StatryRptCategory Report ID
KEY StatryRptRunID Log StatryRptRunID Report Run ID
KEY StatryRptgEntity Log StatryRptgEntity Reporting Entity
GLAccount
AccountingDocumentItem P_SI_LineItemsNonResident AccountingDocumentItem Posting View Item
SupplierName P_SI_LineItemsNonResident SupplierName Supplier Name
Supplier P_SI_LineItemsNonResident Supplier Supplier
CustomerName P_SI_LineItemsNonResident CustomerName Name of Customer
Customer P_SI_LineItemsNonResident Customer Sold-to Party
Country
AmountInCompanyCodeCurrency P_SI_LineItemsNonResident AmountInCompanyCodeCurrency Local Crcy Amt
AccountingDocumentItemType P_SI_LineItemsNonResident AccountingDocumentItemType Line Item ID
TaxCode P_SI_LineItemsNonResident TaxCode Tax Code
CompanyCodeCurrency P_SI_LineItemsNonResident CompanyCodeCurrency Local Currency
GlobalCurrency P_SI_LineItemsNonResident GlobalCurrency GM Billing Element: Global Currency
PostingDate P_SI_LineItemsNonResident PostingDate Posting Date for GR
DocumentDate P_SI_LineItemsNonResident DocumentDate Journal Entry Date
FinancialAccountType P_SI_LineItemsNonResident FinancialAccountType Fin. Account Type
Product P_SI_LineItemsNonResident Product Product Sold
ProductName P_SI_LineItemsNonResident ProductName Description
ChartOfAccounts P_SI_LineItemsNonResident ChartOfAccounts Node Class
GLAccountName P_SI_LineItemsNonResident GLAccountName Short Text
DocumentItemText P_SI_LineItemsNonResident DocumentItemText Text
DebitCreditCode P_SI_LineItemsNonResident DebitCreditCode Single-Character Flag
AccountingDocumentHeaderText P_SI_LineItemsNonResident AccountingDocumentHeaderText Doc.Header Text
TradeIdentificationCode P_SI_LineItemsNonResident TradeIdentificationCode
TradeIdentificationName sif_des TradeIdentificationName
AmountInLocalCurrency P_SI_LineItemsNonResident AmountInLocalCurrency Local Crcy Amt
AccountingDocumentType P_SI_LineItemsNonResident AccountingDocumentType Journal Entry Type

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 C_SI_StRpLineItemNonResidentC.
-- 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_PurposeTradeIsGoods : sifi_bst_goods_block, P_PurposeTradeIsService : sifi_bst_services_block, P_PurposeTradeIsTransfer : sifi_bst_transfers_block

CREATE VIEW C_SI_StRpLineItemNonResidentC AS
SELECT
  LNIT.CompanyCode AS CompanyCode,
  LNIT.AccountingDocument AS AccountingDocument,
  LNIT.FiscalYear AS FiscalYear,
  LNIT.Ledger AS Ledger,
  LNIT.LedgerGLLineItem AS LedgerGLLineItem,
  Log.StatryRptCategory AS StatryRptCategory,
  Log.StatryRptRunID AS StatryRptRunID,
  Log.StatryRptgEntity AS StatryRptgEntity,
  ltrim(LNIT.GLAccount,'0') AS GLAccount,
  LNIT.AccountingDocumentItem AS AccountingDocumentItem,
  LNIT.SupplierName AS SupplierName,
  LNIT.Supplier AS Supplier,
  LNIT.CustomerName AS CustomerName,
  LNIT.Customer AS Customer,
  cast( LNIT.Country as glo_fin_si_iso_code ) AS Country,
  LNIT.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  LNIT.AccountingDocumentItemType AS AccountingDocumentItemType,
  LNIT.TaxCode AS TaxCode,
  LNIT.CompanyCodeCurrency AS CompanyCodeCurrency,
  LNIT.GlobalCurrency AS GlobalCurrency,
  LNIT.PostingDate AS PostingDate,
  LNIT.DocumentDate AS DocumentDate,
  LNIT.FinancialAccountType AS FinancialAccountType,
  LNIT.Product AS Product,
  LNIT.ProductName AS ProductName,
  LNIT.ChartOfAccounts AS ChartOfAccounts,
  LNIT.GLAccountName AS GLAccountName,
  LNIT.DocumentItemText AS DocumentItemText,
  LNIT.DebitCreditCode AS DebitCreditCode,
  LNIT.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  LNIT.TradeIdentificationCode AS TradeIdentificationCode,
  sif_des.TradeIdentificationName AS TradeIdentificationName,
  LNIT.AmountInLocalCurrency AS AmountInLocalCurrency,
  LNIT.AccountingDocumentType AS AccountingDocumentType
FROM P_SI_LineItemsNonResident AS LNIT
;

Learn More