I_JournalEntryItemBasic

Journal Entry Item Basic | view: IFIJRNLBASIC | TRAN | Extraction: Not supported | Component: Information System

Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE

🔑 Keys
💰 Amounts (3)
∑ Quantities
📅 Dates
☰ Categorical (1)
Other (46)
🔗 Relations (43)

Column Name	Description

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

Column Name	Description

Column Name	Description

Column Name	Description
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values

Column Name	Description	Domain name
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
LedgerName	Ledger Name	TEXT30
GLAccountName	G/L Account Name	CHAR30
CompanyCodeName	Company Code Name	TEXT25
CostCenterName	Cost Center Name	TEXT20
ProfitCenterName	Description of Profit Center	TEXT20
FunctionalAreaName	Functional Area Name	CHAR30
BusinessAreaName	Business Area Name	CHAR30
ControllingAreaName	Controlling Area Name	TEXT25
SegmentName	Segment Name	TEXT50
PartnerCostCenterName	Partner Cost Center Name	TEXT20
PartnerProfitCenterName	Partner Profit Center Name	CHAR50
PartnerFunctionalAreaName	Partner Functional Area Name	CHAR30
PartnerBusinessAreaName	Partner Business Area Name	CHAR30
PartnerCompanyName	Company Name	TEXT30
PartnerSegmentName	Partner Segment Name	CHAR50
FiscalPeriod	Fiscal Period	POPER
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
PlantName	Plant Name	TEXT30
CustomerName	Name of Customer	TEXT80
Project	Project	FIS_PROJECT
ProjectExternalID	Project External ID	FIS_PROJECTEXT_NO_CONV
ProjectDescription	Project Name	TEXT40
WBSElement	WBS Element	FIS_WBS
WBSElementExternalID	WBS Element External ID	FIS_WBSEXT_NO_CONV
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
WBSDescription	WBS Element Name	TEXT40
PartnerCompanyCodeName	Partner Company Code Name	TEXT25
CostCtrActivityTypeName	Activity Type Name	DDTEXT
PartnerCostCtrActivityTypeName	Partner Activity Type Name	DDTEXT
PartnerProject	Partner Project	FIS_PROJECT
PartnerProjectExternalID	Partner Project External ID	FIS_PROJECTEXT_NO_CONV
PartnerProjectDescription	Partner Project Description (1st text line)	TEXT40
PartnerWBSElement	Partner WBS Element	FIS_WBS
PartnerWBSElementExternalID	Partner WBS Element External ID	FIS_WBSEXT_NO_CONV
PartnerWBSElementInternalID	Partner WBS Element Internal ID	FIS_WBSINT_NO_CONV
PartnerWBSElementDescription	Partner WBS Element Description	TEXT40
SalesOrganizationName	Sales Organization Name	TEXT20
DistributionChannelName	Distribution Channel Name	TEXT20
DivisionName	Name of Division	TEXT30
SoldMaterialName	Sold Material Name	TEXT40
MaterialGroupName	Product Group Description	TEXT20
CustomerGroupName	Name of Customer Group	TEXT30
CustomerSupplierCountryName	Country/Region Name	TEXT50
CustomerSupplierIndustryName	Description of the Industry Key	TEXT20
SalesDistrictName	Name of the district	TEXT20

Master Data Relations	Join Conditions
Business Area Business Area Client	`I_JOURNALENTRYITEMBASIC.BUSINESSAREA == TGSB.GSBER` `I_JOURNALENTRYITEMBASIC.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`I_JOURNALENTRYITEMBASIC.CHARTOFACCOUNTS == T004.KTOPL` `I_JOURNALENTRYITEMBASIC.MANDT == T004.MANDT`
Company Code Company Code Client	`I_JOURNALENTRYITEMBASIC.COMPANYCODE == T001.BUKRS` `I_JOURNALENTRYITEMBASIC.MANDT == T001.MANDT`
Country/Region Key Customer or Supplier Country/Region Country/Region Key Client	`I_JOURNALENTRYITEMBASIC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `I_JOURNALENTRYITEMBASIC.COMPANYCODECOUNTRY == T005.LAND1` `I_JOURNALENTRYITEMBASIC.MANDT == T005.MANDT`
Company Code Currency Company Code Currency Client	`I_JOURNALENTRYITEMBASIC.COMPANYCODECURRENCY == TCURC.WAERS` `I_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Allocation of company code to company Company Client	`I_JOURNALENTRYITEMBASIC.COMPANYCODEPARTNERCOMPANY == T880.RCOMP` `I_JOURNALENTRYITEMBASIC.MANDT == T880.MANDT`
Controlling Area Controlling Area Client	`I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == TKA01.KOKRS` `I_JOURNALENTRYITEMBASIC.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`I_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS` `I_JOURNALENTRYITEMBASIC.COSTCENTER == CSKS.KOSTL` `I_JOURNALENTRYITEMBASIC.MANDT == CSKS.MANDT`
Activity Type ? Controlling Area Client Activity Type	`I_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS` `I_JOURNALENTRYITEMBASIC.MANDT == CSLA.MANDT` `I_JOURNALENTRYITEMBASIC.COSTCTRACTIVITYTYPE == CSLA.LSTAR`
Cost Source Unit Cost Source Unit Client	`I_JOURNALENTRYITEMBASIC.COSTSOURCEUNIT == T006.MSEHI` `I_JOURNALENTRYITEMBASIC.MANDT == T006.MANDT`
Customer Number Customer Number Client	`I_JOURNALENTRYITEMBASIC.CUSTOMER == KNA1.KUNNR` `I_JOURNALENTRYITEMBASIC.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`I_JOURNALENTRYITEMBASIC.CUSTOMERGROUP == T151.KDGRP` `I_JOURNALENTRYITEMBASIC.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Country/Region Key Client	`I_JOURNALENTRYITEMBASIC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `I_JOURNALENTRYITEMBASIC.COMPANYCODECOUNTRY == T005.LAND1` `I_JOURNALENTRYITEMBASIC.MANDT == T005.MANDT`
Customer Supplier Industry Client Customer Supplier Industry	`I_JOURNALENTRYITEMBASIC.MANDT == T016.MANDT` `I_JOURNALENTRYITEMBASIC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Client Distribution Channel	`I_JOURNALENTRYITEMBASIC.MANDT == TVTW.MANDT` `I_JOURNALENTRYITEMBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Fiscal Year Variant Fiscal Year Variant Client	`I_JOURNALENTRYITEMBASIC.FISCALYEARVARIANT == T009.PERIV` `I_JOURNALENTRYITEMBASIC.MANDT == T009.MANDT`
Functional Area Functional Area Client	`I_JOURNALENTRYITEMBASIC.FUNCTIONALAREA == TFKB.FKBER` `I_JOURNALENTRYITEMBASIC.MANDT == TFKB.MANDT`
G/L Account Company Code Client G/L Account	`I_JOURNALENTRYITEMBASIC.COMPANYCODE == SKB1.BUKRS` `I_JOURNALENTRYITEMBASIC.MANDT == SKB1.MANDT` `I_JOURNALENTRYITEMBASIC.GLACCOUNT == SKB1.SAKNR`
Global Currency Global Currency Client	`I_JOURNALENTRYITEMBASIC.GLOBALCURRENCY == TCURC.WAERS` `I_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Client	`I_JOURNALENTRYITEMBASIC.LEDGER == FINSC_LEDGER.RLDNR` `I_JOURNALENTRYITEMBASIC.MANDT == FINSC_LEDGER.MANDT`
Product Sold Group Product Sold Group Product Sold Group Client	`I_JOURNALENTRYITEMBASIC.MATERIALGROUP == T023.MATKL` `I_JOURNALENTRYITEMBASIC.SOLDPRODUCTGROUP == T023.MATKL` `I_JOURNALENTRYITEMBASIC.MANDT == T023.MANDT`
Order ID Order ID Client	`I_JOURNALENTRYITEMBASIC.ORDERID == AUFK.AUFNR` `I_JOURNALENTRYITEMBASIC.MANDT == AUFK.MANDT`
Division Division Client	`I_JOURNALENTRYITEMBASIC.ORGANIZATIONDIVISION == TSPA.SPART` `I_JOURNALENTRYITEMBASIC.MANDT == TSPA.MANDT`
Partner Business Area Client Partner Business Area	`I_JOURNALENTRYITEMBASIC.MANDT == TGSB.MANDT` `I_JOURNALENTRYITEMBASIC.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Client Company ID of Trading Partner	`I_JOURNALENTRYITEMBASIC.MANDT == T880.MANDT` `I_JOURNALENTRYITEMBASIC.PARTNERCOMPANY == T880.RCOMP`
Partner Company Code Partner Company Code Client	`I_JOURNALENTRYITEMBASIC.PARTNERCOMPANYCODE == T001.BUKRS` `I_JOURNALENTRYITEMBASIC.MANDT == T001.MANDT`
Partner Cost Center ? Controlling Area Client Partner Cost Center	`I_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS` `I_JOURNALENTRYITEMBASIC.MANDT == CSKS.MANDT` `I_JOURNALENTRYITEMBASIC.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Cost Center Activity Type ? Controlling Area Client Partner Cost Center Activity Type	`I_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS` `I_JOURNALENTRYITEMBASIC.MANDT == CSLA.MANDT` `I_JOURNALENTRYITEMBASIC.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR`
Partner Functional Area Client Partner Functional Area	`I_JOURNALENTRYITEMBASIC.MANDT == TFKB.MANDT` `I_JOURNALENTRYITEMBASIC.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Order Partner Order Client	`I_JOURNALENTRYITEMBASIC.PARTNERORDER == AUFK.AUFNR` `I_JOURNALENTRYITEMBASIC.MANDT == AUFK.MANDT`
Partner Profit Center ? Controlling Area Client Partner Profit Center	`I_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS` `I_JOURNALENTRYITEMBASIC.MANDT == CEPC.MANDT` `I_JOURNALENTRYITEMBASIC.PARTNERPROFITCENTER == CEPC.PRCTR`
Partner Project Internal ID Partner Project Internal ID Client	`I_JOURNALENTRYITEMBASIC.PARTNERPROJECTINTERNALID == PROJ.PSPNR` `I_JOURNALENTRYITEMBASIC.MANDT == PROJ.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`I_JOURNALENTRYITEMBASIC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `I_JOURNALENTRYITEMBASIC.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`I_JOURNALENTRYITEMBASIC.MANDT == T001W.MANDT` `I_JOURNALENTRYITEMBASIC.PLANT == T001W.WERKS`
Profit Center ? Controlling Area Profit Center Client	`I_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `I_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS` `I_JOURNALENTRYITEMBASIC.PROFITCENTER == CEPC.PRCTR` `I_JOURNALENTRYITEMBASIC.MANDT == CEPC.MANDT`
Project Internal ID Project Internal ID Client	`I_JOURNALENTRYITEMBASIC.PROJECTINTERNALID == PROJ.PSPNR` `I_JOURNALENTRYITEMBASIC.MANDT == PROJ.MANDT`
Sales District Sales District Client	`I_JOURNALENTRYITEMBASIC.SALESDISTRICT == T171.BZIRK` `I_JOURNALENTRYITEMBASIC.MANDT == T171.MANDT`
Sales Organization Sales Organization Client	`I_JOURNALENTRYITEMBASIC.SALESORGANIZATION == TVKO.VKORG` `I_JOURNALENTRYITEMBASIC.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`I_JOURNALENTRYITEMBASIC.SEGMENT == FAGL_SEGM.SEGMENT` `I_JOURNALENTRYITEMBASIC.MANDT == FAGL_SEGM.MANDT`
Sold Material Sold Material Product Sold Client	`I_JOURNALENTRYITEMBASIC.SOLDMATERIAL == MARA.MATNR` `I_JOURNALENTRYITEMBASIC.SOLDPRODUCT == MARA.MATNR` `I_JOURNALENTRYITEMBASIC.MANDT == MARA.MANDT`
Product Sold Sold Material Product Sold Client	`I_JOURNALENTRYITEMBASIC.SOLDMATERIAL == MARA.MATNR` `I_JOURNALENTRYITEMBASIC.SOLDPRODUCT == MARA.MATNR` `I_JOURNALENTRYITEMBASIC.MANDT == MARA.MANDT`
Product Sold Group Product Sold Group Product Sold Group Client	`I_JOURNALENTRYITEMBASIC.MATERIALGROUP == T023.MATKL` `I_JOURNALENTRYITEMBASIC.SOLDPRODUCTGROUP == T023.MATKL` `I_JOURNALENTRYITEMBASIC.MANDT == T023.MANDT`
Transaction Currency Client Transaction Currency	`I_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT` `I_JOURNALENTRYITEMBASIC.TRANSACTIONCURRENCY == TCURC.WAERS`