C_GRIROplAccountingDocItem

GR/IR Operational Accounting Doc Item | view: CFIGRIROPACDOCI | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: EKKO, EKPO, ACDOCA, BKPF, BSEG, T001, TKA02, FINSC_LEDGER, T001, T014, FINSC_ACTVE_APPL, FINSC_LEDGER_REP

🔑 Keys (5)
💰 Amounts (2)
∑ Quantities
📅 Dates (3)
☰ Categorical (2)
Other (10)
🔗 Relations (18)

Column Name	Description
CompanyCode FK	Company Code
AccountingDocument	Journal Entry
FiscalYear	Fiscal Year
LedgerFiscalYear	Ledger Fiscal Year
LedgerGLLineItem	Ledger Journal Entry Item

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency	Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency

Column Name	Description

Column Name	Description
AccountingDocumentCreationDate	Creation Date
DocumentDate	Journal Entry Date
PostingDate	Posting Date

Column Name	Description
FinancialAccountType	Account Type	Show values
IsGRIROpenItem	Is GR/IR Open Item	Show values

Column Name	Description	Domain name
AccountingDocumentItem	Journal Entry Posting View Item	BUZEI
AccountingDocumentHeaderText	Document Header Text	TEXT25
DocumentItemText	Item Text	TEXT50
OriginalReferenceDocument	Original Reference Document	AWKEY
FiscalPeriod	Fiscal Period	POPER
LastChangeDateTime	Change Time Stamp	TZNTSTMPL
CompanyCodeName	Company Code Name	TEXT25
AssignmentReference	Assignment Reference	ZUONR
TransactionTypeDetermination	Transaction Key	CHAR3
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`C_GRIROPLACCOUNTINGDOCITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T003.MANDT`
Business Transaction Type Business Transaction Type Client	`C_GRIROPLACCOUNTINGDOCITEM.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_GRIROPLACCOUNTINGDOCITEM.CHARTOFACCOUNTS == T004.KTOPL` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T004.MANDT`
Company Code Company Code Client	`C_GRIROPLACCOUNTINGDOCITEM.COMPANYCODE == T001.BUKRS` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T001.MANDT`
Company Code Currency Client Company Code Currency	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == TCURC.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.COMPANYCODECURRENCY == TCURC.WAERS`
Currency Key Client Currency Key	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == TCURC.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.DOCUMENTCURRENCY == TCURC.WAERS`
Fiscal Year Variant Fiscal Year Variant Client	`C_GRIROPLACCOUNTINGDOCITEM.FISCALYEARVARIANT == T009.PERIV` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T009.MANDT`
G/L Account G/L Account Company Code Client	`C_GRIROPLACCOUNTINGDOCITEM.GLACCOUNT == SKB1.SAKNR` `C_GRIROPLACCOUNTINGDOCITEM.COMPANYCODE == SKB1.BUKRS` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == SKB1.MANDT`
Payment Blocking Reason Payment Blocking Reason Client	`C_GRIROPLACCOUNTINGDOCITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T008.MANDT`
Plant Client Plant	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == T001W.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.PLANT == T001W.WERKS`
Posting Key Client Posting Key	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == TBSL.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.POSTINGKEY == TBSL.BSCHL`
Purchasing Group Purchasing Group Client	`C_GRIROPLACCOUNTINGDOCITEM.PURCHASINGGROUP == T024.EKGRP` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T024.MANDT`
Purchasing Organization Client Purchasing Organization	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == T024E.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.PURCHASINGORGANIZATION == T024E.EKORG`
Supplier Client Supplier	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == LFA1.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.SUPPLIER == LFA1.LIFNR`
Tax on Sales/Purchases Code ? Tax on Sales/Purchases Code Client	`C_GRIROPLACCOUNTINGDOCITEM.[column in domain "KALSM_D"] == T007A.KALSM` `C_GRIROPLACCOUNTINGDOCITEM.TAXCODE == T007A.MWSKZ` `C_GRIROPLACCOUNTINGDOCITEM.MANDT == T007A.MANDT`
Transaction Currency Client Transaction Currency	`C_GRIROPLACCOUNTINGDOCITEM.MANDT == TCURC.MANDT` `C_GRIROPLACCOUNTINGDOCITEM.TRANSACTIONCURRENCY == TCURC.WAERS`