I_CN_CADEJRNLENTRYWTHADDLINFO

CDS View
49 Fields 2 CDS Views

CADE journal entry with subsidiary item

I_CN_CADEJRNLENTRYWTHADDLINFO is a CDS View in S/4HANA. CADE journal entry with subsidiary item. It contains 49 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CN_CADEJournalEntry view from COMPOSITE CADE Journal Entry
I_CN_CADEJournalEntryWithBal view left_outer COMPOSITE CADE - Journal Entry Item with Balance

Fields (49)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CN_CADENatlStdRelVersion CN_CADENatlStdRelVersion 2
KEY CompanyCode CompanyCode 1
KEY FiscalPeriod FiscalPeriod,FiscalYearPostingPeriod 2
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem AccountingDocumentItem,LedgerGLLineItem 2
KEY PostingDate PostingDate 2
BaseUnit BaseUnit 1
BillToParty BillToParty 1
BusinessArea BusinessArea 1
BusinessProcess BusinessProcess 1
ChartOfAccounts ChartOfAccounts 1
CN_CADEJournalEntryBookKeeper CN_CADEJournalEntryBookKeeper 1
CN_CADEJournalEntryReviewer CN_CADEJournalEntryReviewer 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 1
Customer Customer 1
CustomerGroup CustomerGroup 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 1
DebitCreditCode DebitCreditCode 1
DistributionChannel DistributionChannel 1
DocumentItemText DocumentItemText 1
FinancialAccountType FinancialAccountType 1
FunctionalArea FunctionalArea,FunctionalAreaIsUsed 1
Fund Fund 1
FundsCenter FundsCenter 1
GLAccount GLAccount 2
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InternalOrder InternalOrder 1
Material Material 1
MaterialGroup MaterialGroup 1
Plant Plant 1
ProfitCenter ProfitCenter 1
Project Project 1
ProjectNetwork ProjectNetwork 1
SalesDistrict SalesDistrict 1
SalesOrganization SalesOrganization 1
Segment Segment 1
ShipToParty ShipToParty 1
SoldMaterial SoldMaterial 1
Supplier Supplier 1
TransactionCurrency TransactionCurrency 1
WBSElement WBSElement 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.

-- CADE journal entry with subsidiary item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CN_CADEJRNLENTRYWTHADDLINFO (
    ACCOUNTINGDOCUMENT,
    CN_CADENATLSTDRELVERSION,
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    POSTINGDATE,
    BASEUNIT,
    BILLTOPARTY,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    CN_CADEJOURNALENTRYBOOKKEEPER,
    CN_CADEJOURNALENTRYREVIEWER,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    CUSTOMERGROUP,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERNALORDER,
    MATERIAL,
    MATERIALGROUP,
    PLANT,
    PROFITCENTER,
    PROJECT,
    PROJECTNETWORK,
    SALESDISTRICT,
    SALESORGANIZATION,
    SEGMENT,
    SHIPTOPARTY,
    SOLDMATERIAL,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    WBSELEMENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CN_CADENATLSTDRELVERSION, COMPANYCODE, FISCALPERIOD, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, POSTINGDATE)
);

Learn More