ICA_MATCHINGJOURNALENTRYITEM

CDS View
99 Fields 2 CDS Views

Matching Journal Entry Item

ICA_MATCHINGJOURNALENTRYITEM is a CDS View in S/4HANA. Matching Journal Entry Item. It contains 99 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ICA_GENJOURNALENTRIES_C_3SL view_entity from Match Universal Journal Entry Line Items
ICA_GENJOURNALENTRIES_C2_3SL view_entity from Match Universal Journal Entry Line Items

Fields (99)

KeyField CDS FieldsUsed in Views
AccountingDocCreatedByUser usnam 2
AccountingDocument ref_belnr 2
AccountingDocumentCategory bstat 2
AccountingDocumentType blart 2
AmountInBalanceTransacCrcy tsl 1
AmountInCompanyCodeCurrency hsl 2
AmountInFunctionalCurrency fcsl 2
AmountInGlobalCurrency ksl 2
AmountInTransactionCurrency wsl 2
AssetClass anlkl 2
AssetDepreciationArea afabe 2
AssetTransactionType anbwa 2
AssignmentReference zuonr 2
BalanceTransactionCurrency rtcur 2
BaseUnit runit 2
BillingDocumentType fkart 2
BillToParty kunre 2
BusinessTransactionCategory bttype 2
ChartOfAccounts ktopl 2
ClearingDate augdt 2
ClearingJournalEntry augbl 2
ClearingJournalEntryFiscalYear auggj 2
Company rcomp 2
CompanyCode rbukrs 2
CompanyCodeCurrency rhcur 2
CostCenter rcntr 2
CreationDateTime timestamp 2
Customer kunnr 2
CustomerGroup kdgrp 2
CustomerSupplierCorporateGroup konzs 2
CustomerSupplierCountry land1 2
CustomerSupplierIndustry brsch 2
DebitCreditCode drcrk 2
DistributionChannel vtweg 2
DocumentDate bldat 2
DocumentItemText sgtxt 2
EliminationProfitCenter eprctr 2
FinancialAccountType koart 2
FinancialTransactionType rmvct 2
FiscalPeriod poper 2
FiscalYear gjahr 2
FiscalYearPeriod fiscyearper 2
FiscalYearVariant periv 1
FixedAsset anln2 2
FunctionalCurrency rfccur 2
GLAccount racct 2
GLAccountType glaccount_type 2
GlobalCurrency rkcur 2
GLRecordType rrcty 2
InvoiceItemReference rebzz 2
InvoiceReference rebzg 2
InvoiceReferenceFiscalYear rebzj 2
IsOpenItemManaged xopvw 2
IsReversal xreversing 2
IsReversed xreversed 2
IsTrueReversed xtruerev 2
JournalEntryItemCategory linetype 2
JrnlEntrAltvFYConsecutiveID docnr_ld 2
LedgerFiscalYear ryear 2
LedgerGLLineItem ref_docln 2
MasterFixedAsset anln1 2
MatchingMethodID method_id 2
OffsettingAccount gkont 2
OffsettingAccountType gkoar 2
OrganizationDivision spart 2
PartnerCompany rassc 2
PartnerCostCenter scntr 2
PartnerFixedAsset panl2 2
PartnerMasterFixedAsset panl1 2
PartnerProfitCenter pprctr 2
PartnerSegment psegment 2
Plant werks 2
PostingDate budat 2
PostingKey bschl 2
Product matnr 2
ProfitCenter prctr 2
PurchasingDocument ebeln 2
PurchasingDocumentItem ebelp 2
Quantity msl 2
ReferenceDocument awref 2
ReferenceDocumentContext aworg 2
ReferencePurchaseOrderCategory rbest 2
ReversalReferenceDocument awref_rev 2
ReversalReferenceDocumentCntxt aworg_rev 2
SalesDistrict bzirk 2
SalesDocument kdauf 2
SalesDocumentItem kdpos 2
SalesOrganization vkorg 2
Segment segment 2
ShipToParty kunwe 2
SoldProduct matnr_copa 2
SoldProductGroup matkl 2
SourceLedger rldnr 2
SpecialGLCode umskz 2
SubLedgerAcctLineItemType slalittype 2
Supplier lifnr 2
TaxCode mwskz 2
TransactionCurrency rwcur 2
TransactionTypeDetermination ktosl 2

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.

-- Matching Journal Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICA_MATCHINGJOURNALENTRYITEM (
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCLASS,
    ASSETDEPRECIATIONAREA,
    ASSETTRANSACTIONTYPE,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUSINESSTRANSACTIONCATEGORY,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANY,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    COSTCENTER,
    CREATIONDATETIME,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    ELIMINATIONPROFITCENTER,
    FINANCIALACCOUNTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDASSET,
    FUNCTIONALCURRENCY,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    ISTRUEREVERSED,
    JOURNALENTRYITEMCATEGORY,
    JRNLENTRALTVFYCONSECUTIVEID,
    LEDGERFISCALYEAR,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    MATCHINGMETHODID,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    ORGANIZATIONDIVISION,
    PARTNERCOMPANY,
    PARTNERCOSTCENTER,
    PARTNERFIXEDASSET,
    PARTNERMASTERFIXEDASSET,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PLANT,
    POSTINGDATE,
    POSTINGKEY,
    PRODUCT,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEPURCHASEORDERCATEGORY,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORGANIZATION,
    SEGMENT,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOURCELEDGER,
    SPECIALGLCODE,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TAXCODE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION
);

Learn More