I_AddlLedgerOplAcctgDocItem

Additional Ledger Journal Entry Item | view: IFIADDLDACDOCIT | ATTR | Extraction: Not supported | Component: Information System
Tables used: BKPF, BSEG_ADD, T001
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Six-figure number of line item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Additional Currency 1 (AdditionalCurrency1):
ValuationDiffAmtInAddlCrcy1 Valuation Difference Amount in Additional Currency 1
AmountInAdditionalCurrency1 Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
ValueDate Value date
DueCalculationBaseDate Due Calculation Base Date
SettlementReferenceDate Reference Date for Settlement
NetDueDate Due Date for Net Payment
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsAutomaticallyCreated Is Automatically Created Show values
IsBalanceSheetAccount Is Balance Sheet Account Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
TreasuryContractType Treasury Contract Type Show values
ClearingIsReversed Clearing Is Reversed Show values
OffsettingAccountType Offsetting Account Type Show values
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
ClearingAccountingDocument Clearing Journal Entry BELNR
BusinessArea Business Area GSBER
PartnerBusinessArea Partner Business Area GSBER
WithholdingTaxCode Withholding Tax Code QSSKZ
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CorporateGroupAccount Corporate Group Account SAKNR
CostCenter Cost Center KOSTL
Project Project definition PS_PSPID
AssetTransactionType Asset Transaction Type BWASL
ProfitLossAccountType Profit Loss Account Type CHAR2
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItem Commitment Item FIPOS
CommitmentItemShortID Commitment Item FIPOS
CostObject Cost Object KSTRG
ProjectNetwork Network Number for Account Assignment AUFNR
OrderInternalBillOfOperations Order Internal Bill of Operations ID AUFPL
OrderIntBillOfOperationsItem Order Internal Bill of Operations Item CO_APLZL
WBSElementInternalID WBS Element PS_POSNR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
PaymentMethodSupplement Payment Method Supplement UZAWE
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
FundsCenter Funds Management Center FISTL
Fund Fund BP_GEBER
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner CHAR12
FunctionalArea Functional Area FKBER
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Card Payment Settlement CCBTC
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
ClearingItem Clearing Item AGZEI
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
GrantID Grant GM_GRANT_NBR
FundedProgram Funded Program FM_MEASURE
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
CostElement Cost Element KSTAR
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Chart of Accounts KTOPL
PartnerFund Partner Fund BP_GEBER
PartnerGrant Partner Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
PartnerBudgetPeriod FM: Partner Budget Period FM_BUDGET_PERIOD
CashLedgerCompanyCode Cash Ledger: Company Code for Expense/Revenue BUKRS
CashLedgerAccount Cash Ledger: Expense or Revenue Account SAKNR
PubSecBudgetAccountCoCode Budget Account Company Code BUKRS
PubSecBudgetAccount Budget Account SAKNR
NumberOfItems Number of Items DEC12
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.BASEUNIT == T006.MSEHI
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T006.MANDT
Business Place
  • Business Place
  • Company Code
  • ?
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.BUSINESSPLACE == J_1BBRANCH.BRANCH
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == J_1BBRANCH.BUKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.[column in domain "GLO_BUPLA_TYPE_CODE"] == J_1BBRANCH.BUPLA_TYPE
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == J_1BBRANCH.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.CHARTOFACCOUNTS == T004.KTOPL
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == T001.BUKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == TKA01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T856.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.GLACCOUNT == SKA1.SAKNR
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == SKA1.KTOPL
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == SKA1.MANDT
Valuation Type
  • Valuation Type
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T149D.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.JOINTVENTURE == T8JV.VNAME
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == T8JV.BUKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T8JV.MANDT
Recovery Indicator
  • Recovery Indicator
  • Company Code
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == T8JJ.BUKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T8JJ.MANDT
Equity group
  • Joint venture
  • Equity group
  • Company Code
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.JOINTVENTURE == T8JF.VNAME
  • I_ADDLLEDGEROPLACCTGDOCITEM.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == T8JF.BUKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T8JF.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == MARA.MANDT
  • I_ADDLLEDGEROPLACCTGDOCITEM.PRODUCT == MARA.MATNR
  • I_ADDLLEDGEROPLACCTGDOCITEM.MATERIAL == MARA.MATNR
Order ID
  • Order ID
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.ORDERID == AUFK.AUFNR
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == AUFK.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.PARTNERCOMPANY == T880.RCOMP
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T880.MANDT
Partner Profit Center
  • Controlling Area
  • Partner Profit Center
  • ?
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.CONTROLLINGAREA == CEPC.KOKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_ADDLLEDGEROPLACCTGDOCITEM.[column in domain "DATBI"] == CEPC.DATBI
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == CEPC.MANDT
Plant
  • Plant
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.PLANT == T001W.WERKS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T001W.MANDT
Posting Key
  • Posting Key
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.POSTINGKEY == TBSL.BSCHL
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == TBSL.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == MARA.MANDT
  • I_ADDLLEDGEROPLACCTGDOCITEM.PRODUCT == MARA.MATNR
  • I_ADDLLEDGEROPLACCTGDOCITEM.MATERIAL == MARA.MATNR
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.CONTROLLINGAREA == CEPC.KOKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.PROFITCENTER == CEPC.PRCTR
  • I_ADDLLEDGEROPLACCTGDOCITEM.[column in domain "DATBI"] == CEPC.DATBI
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == CEPC.MANDT
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • I_ADDLLEDGEROPLACCTGDOCITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T007A.MANDT
  • I_ADDLLEDGEROPLACCTGDOCITEM.TAXCODE == T007A.MWSKZ
Tax Section
  • Tax Section
  • Company Code
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.TAXSECTION == SECCODE.SECCODE
  • I_ADDLLEDGEROPLACCTGDOCITEM.COMPANYCODE == SECCODE.BUKRS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == SECCODE.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • I_ADDLLEDGEROPLACCTGDOCITEM.VALUATIONAREA == T001K.BWKEY
  • I_ADDLLEDGEROPLACCTGDOCITEM.MANDT == T001K.MANDT