P_SI_LineItemsNonResident

DDL: P_SI_LINEITEMSNONRESIDENT Type: view_entity COMPOSITE
32 Fields 1 Data Sources

BST Line Items - SI Nonresidents

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

Data Sources (1)

SourceAliasJoin Type
P_SI_AddNonResidentDocument vfd from

Annotations (9)

NameValueLevelField
EndUserText.label BST Line Items - SI Nonresidents view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SI_AddNonResidentDocument CompanyCode Receiver Company Code
KEY AccountingDocument P_SI_AddNonResidentDocument AccountingDocument Journal Entry
KEY FiscalYear P_SI_AddNonResidentDocument FiscalYear G/L Fiscal Year
KEY Ledger GLAcntIItmRD SourceLedger Source Ledger
KEY LedgerGLLineItem GLAcntIItmRD LedgerGLLineItem Journal Entry Item
AccountingDocumentItem GLAcntIItmRD AccountingDocumentItem Posting View Item
GLAccount GLAcntIItmRD GLAccount General Ledger
Customer P_SI_AddNonResidentDocument Customer Sold-to Party
CustomerName customer CustomerName Name of Customer
Supplier P_SI_AddNonResidentDocument Supplier Supplier
SupplierName supplier SupplierName Supplier Name
AmountInCompanyCodeCurrency GLAcntIItmRD AmountInCompanyCodeCurrency Local Crcy Amt
AccountingDocumentItemType OperAccDocItm AccountingDocumentItemType Line Item ID
TaxCode OperAccDocItm TaxCode Tax Code
CompanyCodeCurrency GLAcntIItmRD CompanyCodeCurrency Local Currency
GlobalCurrency
PostingDate OperAccDocItm PostingDate Posting Date for GR
DocumentDate GLAcntIItmRD DocumentDate Journal Entry Date
FinancialAccountType GLAcntIItmRD FinancialAccountType Fin. Account Type
Product GLAcntIItmRD Product Product Sold
ProductName mak ProductName Description
ChartOfAccounts GLAcntIItmRD ChartOfAccounts Node Class
GLAccountName ska GLAccountName Short Text
DocumentItemText GLAcntIItmRD DocumentItemText Text
DebitCreditCode GLAcntIItmRD DebitCreditCode Single-Character Flag
AccountingDocumentHeaderText
CountryThreeDigitISOCodeendasCountry
LastChangedAtDateTime sif LastChangedAtDateTime Changed On
LocalLastChangedAtDateTime sif LocalLastChangedAtDateTime
AccountingDocumentType GLAcntIItmRD AccountingDocumentType Journal Entry Type
DocumentIsAdded P_SI_AddNonResidentDocument DocumentIsAdded
AmountInLocalCurrency

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 P_SI_LineItemsNonResident.
-- 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 P_SI_LineItemsNonResident AS
SELECT
  vfd.CompanyCode AS CompanyCode,
  vfd.AccountingDocument AS AccountingDocument,
  vfd.FiscalYear AS FiscalYear,
  GLAcntIItmRD.SourceLedger AS Ledger,
  GLAcntIItmRD.LedgerGLLineItem AS LedgerGLLineItem,
  GLAcntIItmRD.AccountingDocumentItem AS AccountingDocumentItem,
  GLAcntIItmRD.GLAccount AS GLAccount,
  vfd.Customer AS Customer,
  customer.CustomerName AS CustomerName,
  vfd.Supplier AS Supplier,
  supplier.SupplierName AS SupplierName,
  GLAcntIItmRD.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  OperAccDocItm.AccountingDocumentItemType AS AccountingDocumentItemType,
  OperAccDocItm.TaxCode AS TaxCode,
  GLAcntIItmRD.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( 'EUR' as fis_hwaer ) AS GlobalCurrency,
  OperAccDocItm.PostingDate AS PostingDate,
  GLAcntIItmRD.DocumentDate AS DocumentDate,
  GLAcntIItmRD.FinancialAccountType AS FinancialAccountType,
  GLAcntIItmRD.Product AS Product,
  mak.ProductName AS ProductName,
  GLAcntIItmRD.ChartOfAccounts AS ChartOfAccounts,
  ska.GLAccountName AS GLAccountName,
  GLAcntIItmRD.DocumentItemText AS DocumentItemText,
  GLAcntIItmRD.DebitCreditCode AS DebitCreditCode,
  GLAcntIItmRD._ClearingAccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  case when vfd.SI_IntlInstitutionCode is not initial then vfd.SI_IntlInstitutionCode when vfd.DocumentIsAdded is initial then intcn.CountryThreeDigitISOCode when vfd.DocumentIsAdded is not initial and sif.Country is not initial then sif.Country when vfd.DocumentIsAdded is not initial and sif_added.Country is not initial then sif_added.Country else intcn.CountryThreeDigitISOCode end as Country AS CountryThreeDigitISOCodeendasCountry,
  sif.LastChangedAtDateTime AS LastChangedAtDateTime,
  sif.LocalLastChangedAtDateTime AS LocalLastChangedAtDateTime,
  GLAcntIItmRD.AccountingDocumentType AS AccountingDocumentType,
  vfd.DocumentIsAdded AS DocumentIsAdded,
  currency_conversion( amount => GLAcntIItmRD.AmountInCompanyCodeCurrency, source_currency => GLAcntIItmRD.CompanyCodeCurrency, target_currency => GlobalCurrency, exchange_rate_date => GLAcntIItmRD.PostingDate ) AS AmountInLocalCurrency
FROM P_SI_AddNonResidentDocument AS vfd
;

Learn More