I_LU_SAFTJOURNALENTRY

CDS View
33 Fields 12 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. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_LU_SAFTGenLedgerLine view from CONSUMPTION SAFT LU General Ledger Lines
I_LU_SAFTJournalItemBP view from COMPOSITE SAFT LU Document Business Partner
I_LU_SAFTJournalItemBP view union COMPOSITE SAFT LU Document Business Partner
P_LU_SAFTDPZeroTaxLine view from COMPOSITE
P_LU_SAFTGeneralLedgerTDT view from COMPOSITE
P_LU_SAFTGLOneTimeBP view from COMPOSITE
P_LU_SAFTGLOneTimeBP view union COMPOSITE
P_LU_SAFTJournalItemBP view from COMPOSITE
P_LU_SAFTJournalItemBP view union COMPOSITE
P_LU_SAFTJournalItemTaxAbs view from COMPOSITE
P_LU_SAFTTaxRatioCalculation view from COMPOSITE
P_LU_SAFTZeroTaxLine view from COMPOSITE

Fields (33)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 9
KEY CompanyCode CompanyCode 9
KEY FiscalYear FiscalYear 9
KEY Ledger Ledger 9
KEY LedgerGLLineItem LedgerGLLineItem 7
_CompanyCode _CompanyCode 4
_CompanyCodeCurrency _CompanyCodeCurrency 3
_FiscalYear _FiscalYear 4
_Ledger _Ledger 4
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