P_SI_LINEITEMSNONRESIDENT

CDS View
34 Fields 2 CDS Views

BST Line Items - SI Nonresidents

P_SI_LINEITEMSNONRESIDENT is a CDS View in S/4HANA. BST Line Items - SI Nonresidents. It contains 34 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SI_StRpLineItemNonResidentC view_entity from CONSUMPTION BST Line Items SI Nonresidents - Cube
R_SI_GLLineItemCstmzgTP view_entity from TRANSACTIONAL Slovenia G/L Account Line Items Customizing

Fields (34)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 2
AccountingDocumentHeaderText AccountingDocumentHeaderText 2
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentItemType AccountingDocumentItemType 2
AccountingDocumentType AccountingDocumentType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInLocalCurrency AmountInLocalCurrency 2
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency 2
Customer Customer 2
CustomerName CustomerName 2
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 2
DocumentIsAdded DocumentIsAdded 1
DocumentItemText DocumentItemText 2
FinancialAccountType FinancialAccountType 2
GLAccount GLAccount 1
GLAccountName GLAccountName 2
GlobalCurrency GlobalCurrency 2
izdatki IsOutgoingPayment 1
LastChangedAtDateTime LastChangedAtDateTime 1
LocalLastChangedAtDateTime LocalLastChangedAtDateTime 1
PostingDate PostingDate 2
prejemki PaymentIsIncoming 1
Product Product 2
ProductName ProductName 2
Supplier Supplier 2
SupplierName SupplierName 2
TaxCode TaxCode 2
TradeIdentificationCode TradeIdentificationCode 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- BST Line Items - SI Nonresidents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SI_LINEITEMSNONRESIDENT (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINLOCALCURRENCY,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CUSTOMER,
    CUSTOMERNAME,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DOCUMENTISADDED,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    GLACCOUNTNAME,
    GLOBALCURRENCY,
    IZDATKI,
    LASTCHANGEDATDATETIME,
    LOCALLASTCHANGEDATDATETIME,
    POSTINGDATE,
    PREJEMKI,
    PRODUCT,
    PRODUCTNAME,
    SUPPLIER,
    SUPPLIERNAME,
    TAXCODE,
    TRADEIDENTIFICATIONCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM)
);

Learn More