I_NO_SAFTJOURNALITEM

CDS View
20 Fields 10 CDS Views

SAFT Norway Journal Items

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

CDS Views using this table (10)

ViewTypeJoinVDMDescription
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
P_NO_SAFTFOREIGNTAXCODES view_entity from COMPOSITE
P_NO_SAFTJournalCustSup view from COMPOSITE
P_NO_SAFTJournalCustSup view union COMPOSITE
P_NO_SAFTJournalCustSupMD view from COMPOSITE SAF-T Norway Journal Item BP Master Data
P_NO_SAFTJournalCustSupMD view union COMPOSITE SAF-T Norway Journal Item BP Master Data
P_NO_SAFTJournalItemTaxSum view from COMPOSITE
P_NO_SAFTTaxCodesInPeriod view_entity from COMPOSITE Tax codes in the selection period

Fields (20)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 7
KEY FiscalYear FiscalYear 4
KEY Ledger Ledger 4
KEY LedgerGLLineItem LedgerGLLineItem 3
KEY TaxCode TaxCode 5
KEY TaxCountry TaxCountry 4
_CompanyCode _CompanyCode 2
_FiscalYear _FiscalYear 2
_JournalEntry _JournalEntry 2
_Ledger _Ledger 2
CompanyCodeCurrency CompanyCodeCurrency 2
Customer Customer 2
DebitCreditCode DebitCreditCode 1
FinancialAccountType FinancialAccountType 1
GLAccount GLAccount 1
PostingDate PostingDate 4
Supplier Supplier 2
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