I_NO_SAFTJOURNALITEM

CDS View
20 Fields 9 CDS Views

SAFT Norway Journal Items

I_NO_SAFTJOURNALITEM is a CDS View in S/4HANA. SAFT Norway Journal Items. It contains 20 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_NO_SAFTJournalEntryTotCheck view from CONSUMPTION SAF-T Norway Journal Entry Total Check
C_NO_SAFTJournalItemTax view from CONSUMPTION SAF-T Norway Journal Item Tax
I_NO_SAFTTaxCodesInPeriod view_entity from COMPOSITE Tax codes in the selection period
P_NO_SAFTDocsSpecialGL view from COMPOSITE Documents with Special GL
P_NO_SAFTFOREIGNTAXCODES view from COMPOSITE SAF-T Norway Jornal Item Sum
P_NO_SAFTJournalCustSup view from COMPOSITE SAF-T Norway Customers and Suppliers
P_NO_SAFTJournalCustSup view union COMPOSITE SAF-T Norway Customers and Suppliers
P_NO_SAFTJournalItemTaxSum view from COMPOSITE SAF-T Norway Jornal Item Sum
P_NO_SAFTTaxCodesInPeriod view_entity from COMPOSITE Tax codes in the selection period

Fields (20)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY CompanyCode CompanyCode 6
KEY FiscalYear FiscalYear 3
KEY Ledger Ledger 3
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY TaxCode TaxCode 5
KEY TaxCountry TaxCountry 4
_CompanyCode _CompanyCode 1
_FiscalYear _FiscalYear 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
CompanyCodeCurrency CompanyCodeCurrency 2
Customer Customer 1
DebitCreditCode DebitCreditCode 1
FinancialAccountType FinancialAccountType 1
GLAccount GLAccount 1
PostingDate PostingDate 3
Supplier Supplier 1
TransactionCurrency TransactionCurrency 1
VATRegistration VATRegistration 1

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.

-- SAFT Norway Journal Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_NO_SAFTJOURNALITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    TAXCODE,
    TAXCOUNTRY,
    _COMPANYCODE,
    _FISCALYEAR,
    _JOURNALENTRY,
    _LEDGER,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DEBITCREDITCODE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    POSTINGDATE,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, TAXCODE, TAXCOUNTRY)
);

Learn More