I_LU_SAFTJOURNALENTRY

CDS View
33 Fields 9 CDS Views

SAFT LU General Ledger Documents

I_LU_SAFTJOURNALENTRY is a CDS View in S/4HANA. SAFT LU General Ledger Documents. It contains 33 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_LU_SAFTGenLedgerLine view from CONSUMPTION SAFT LU General Ledger Lines
I_LU_SAFTJournalItemBP view_entity from COMPOSITE SAFT LU Document Business Partner
P_LU_SAFTDPZeroTaxLine view from COMPOSITE SAFT LU Identify the Zero Line Tax
P_LU_SAFTGeneralLedgerTDT view from COMPOSITE SAFT LU General Ledger Time Dependent Tax
P_LU_SAFTJournalItemBP view from COMPOSITE SAFT LU Journal Item Business Partner
P_LU_SAFTJournalItemBP view union COMPOSITE SAFT LU Journal Item Business Partner
P_LU_SAFTJournalItemTaxAbs view from COMPOSITE SAFT LU Journal Tax Absolute
P_LU_SAFTTaxRatioCalculation view from COMPOSITE SAFT LU Tax Ratio Calculation
P_LU_SAFTZeroTaxLine view from COMPOSITE SAFT LU Identify the Zero Line Tax

Fields (33)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 8
KEY CompanyCode CompanyCode 8
KEY FiscalYear FiscalYear 8
KEY Ledger Ledger 8
KEY LedgerGLLineItem LedgerGLLineItem 7
_CompanyCode _CompanyCode 3
_CompanyCodeCurrency _CompanyCodeCurrency 3
_FiscalYear _FiscalYear 3
_Ledger _Ledger 3
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentItem AccountingDocumentItem 3
AccountingDocumentItemType AccountingDocumentItemType 5
AccountingDocumentType AccountingDocumentType 4
AlternativeGLAccount AlternativeGLAccount 4
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
ChartOfAccounts ChartOfAccounts 3
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 5
Customer Customer 1
DebitCreditCode DebitCreditCode 2
DelivOfGoodsDestCountry DelivOfGoodsDestCountry 1
DocumentItemText DocumentItemText 4
ExchangeRate ExchangeRate 2
FinancialAccountType FinancialAccountType 5
GLAccount GLAccount 3
IsReversal IsReversal 2
PostingDate PostingDate 8
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
TaxCalculationProcedure TaxCalculationProcedure 2
TaxCode TaxCode 4
TransactionCurrency TransactionCurrency 3
TransactionTypeDetermination TransactionTypeDetermination 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 LU General Ledger Documents
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LU_SAFTJOURNALENTRY (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _FISCALYEAR,
    _LEDGER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINCOMPANYCODECURRENCY,
    CHARTOFACCOUNTS,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CUSTOMER,
    DEBITCREDITCODE,
    DELIVOFGOODSDESTCOUNTRY,
    DOCUMENTITEMTEXT,
    EXCHANGERATE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    ISREVERSAL,
    POSTINGDATE,
    SPECIALGLCODE,
    SUPPLIER,
    TAXCALCULATIONPROCEDURE,
    TAXCODE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM)
);

Learn More