A_JournalEntryItemBasic

API Journal Entry Item Basic | view: AFIJRNLBASIC | Extraction: Not supported | Component: Information System

Tables used: SCAL_TT_DATE, PRTE, 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, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE

🔑 Keys
💰 Amounts (11)
∑ Quantities (5)
📅 Dates
☰ Categorical (1)
Other (40)
🔗 Relations (49)

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
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8

Column Name	Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity	Valuation Quantity
📏 Base Unit of Measure (BaseUnit):
Quantity	Quantity
📏 Additional Quantity 1 Unit (AdditionalQuantity1Unit):
AdditionalQuantity1	Additional Quantity 1
📏 Additional Quantity 2 Unit (AdditionalQuantity2Unit):
AdditionalQuantity2	Additional Quantity 2
📏 Additional Quantity 3 Unit (AdditionalQuantity3Unit):
AdditionalQuantity3	Additional Quantity 3

Column Name	Description

Column Name	Description
ControllingDebitCreditCode	Controlling Debit Credit Code	Show values

Column Name	Description	Domain name
LedgerName	Ledger Name	TEXT30
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
ControllingAreaName	Controlling Area Name	TEXT25
CompanyCodeName	Company Code Name	TEXT25
GLAccountName	G/L Account Name	CHAR30
CostCenterName	Cost Center Name	TEXT20
ProfitCenterName	Description of Profit Center	TEXT20
FunctionalAreaName	Functional Area Name	CHAR30
BusinessAreaName	Business Area Name	CHAR30
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_C
PlantName	Plant Name	TEXT30
CustomerName	Name of Customer	TEXT80
Project	Project	FIS_PROJECT
ProjectDescription	Project Description	TEXT40
WBSElement	WBS Element	FIS_WBS
WBSElementDescription	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
PartnerProjectDescription	Partner Project Description (1st text line)	TEXT40
PartnerWBSElement	Partner WBS Element	FIS_WBS
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
Additional Quantity 1 Unit Additional Quantity 1 Unit Client	`A_JOURNALENTRYITEMBASIC.ADDITIONALQUANTITY1UNIT == T006.MSEHI` `A_JOURNALENTRYITEMBASIC.MANDT == T006.MANDT`
Additional Quantity 2 Unit Additional Quantity 2 Unit Client	`A_JOURNALENTRYITEMBASIC.ADDITIONALQUANTITY2UNIT == T006.MSEHI` `A_JOURNALENTRYITEMBASIC.MANDT == T006.MANDT`
Additional Quantity 3 Unit Additional Quantity 3 Unit Client	`A_JOURNALENTRYITEMBASIC.ADDITIONALQUANTITY3UNIT == T006.MSEHI` `A_JOURNALENTRYITEMBASIC.MANDT == T006.MANDT`
Base Unit of Measure Client Base Unit of Measure	`A_JOURNALENTRYITEMBASIC.MANDT == T006.MANDT` `A_JOURNALENTRYITEMBASIC.BASEUNIT == T006.MSEHI`
Business Area Business Area Client	`A_JOURNALENTRYITEMBASIC.BUSINESSAREA == TGSB.GSBER` `A_JOURNALENTRYITEMBASIC.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`A_JOURNALENTRYITEMBASIC.CHARTOFACCOUNTS == T004.KTOPL` `A_JOURNALENTRYITEMBASIC.MANDT == T004.MANDT`
Company Code Company Code Client	`A_JOURNALENTRYITEMBASIC.COMPANYCODE == T001.BUKRS` `A_JOURNALENTRYITEMBASIC.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`A_JOURNALENTRYITEMBASIC.COMPANYCODECURRENCY == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == TKA01.KOKRS` `A_JOURNALENTRYITEMBASIC.MANDT == TKA01.MANDT`
Cost Center ? Cost Center Controlling Area Client	`A_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `A_JOURNALENTRYITEMBASIC.COSTCENTER == CSKS.KOSTL` `A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS` `A_JOURNALENTRYITEMBASIC.MANDT == CSKS.MANDT`
Activity Type ? Activity Type Controlling Area Client	`A_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `A_JOURNALENTRYITEMBASIC.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS` `A_JOURNALENTRYITEMBASIC.MANDT == CSLA.MANDT`
Cost Source Unit Client Cost Source Unit	`A_JOURNALENTRYITEMBASIC.MANDT == T006.MANDT` `A_JOURNALENTRYITEMBASIC.COSTSOURCEUNIT == T006.MSEHI`
Customer Number Customer Number Client	`A_JOURNALENTRYITEMBASIC.CUSTOMER == KNA1.KUNNR` `A_JOURNALENTRYITEMBASIC.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`A_JOURNALENTRYITEMBASIC.CUSTOMERGROUP == T151.KDGRP` `A_JOURNALENTRYITEMBASIC.MANDT == T151.MANDT`
Customer or Supplier Country/Region Customer or Supplier Country/Region Client	`A_JOURNALENTRYITEMBASIC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `A_JOURNALENTRYITEMBASIC.MANDT == T005.MANDT`
Customer Supplier Industry Customer Supplier Industry Client	`A_JOURNALENTRYITEMBASIC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `A_JOURNALENTRYITEMBASIC.MANDT == T016.MANDT`
Distribution Channel Client Distribution Channel	`A_JOURNALENTRYITEMBASIC.MANDT == TVTW.MANDT` `A_JOURNALENTRYITEMBASIC.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Fiscal Year Variant Fiscal Year Variant Client	`A_JOURNALENTRYITEMBASIC.FISCALYEARVARIANT == T009.PERIV` `A_JOURNALENTRYITEMBASIC.MANDT == T009.MANDT`
Freely Defined Currency 1 Client Freely Defined Currency 1	`A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT` `A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY1 == TCURC.WAERS`
Freely Defined Currency 2 Client Freely Defined Currency 2	`A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT` `A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY2 == TCURC.WAERS`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Freely Defined Currency 5 Client	`A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY5 == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY6 == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Freely Defined Currency 7 Client Freely Defined Currency 7	`A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT` `A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Freely Defined Currency 8 Client	`A_JOURNALENTRYITEMBASIC.FREEDEFINEDCURRENCY8 == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`
Functional Area Functional Area Client	`A_JOURNALENTRYITEMBASIC.FUNCTIONALAREA == TFKB.FKBER` `A_JOURNALENTRYITEMBASIC.MANDT == TFKB.MANDT`
G/L Account G/L Account Company Code Client	`A_JOURNALENTRYITEMBASIC.GLACCOUNT == SKB1.SAKNR` `A_JOURNALENTRYITEMBASIC.COMPANYCODE == SKB1.BUKRS` `A_JOURNALENTRYITEMBASIC.MANDT == SKB1.MANDT`
Global Currency Client Global Currency	`A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT` `A_JOURNALENTRYITEMBASIC.GLOBALCURRENCY == TCURC.WAERS`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`A_JOURNALENTRYITEMBASIC.MANDT == FINSC_LEDGER.MANDT` `A_JOURNALENTRYITEMBASIC.LEDGER == FINSC_LEDGER.RLDNR`
Product Sold Group Product Sold Group Client	`A_JOURNALENTRYITEMBASIC.MATERIALGROUP == T023.MATKL` `A_JOURNALENTRYITEMBASIC.MANDT == T023.MANDT`
Order ID Order ID Client	`A_JOURNALENTRYITEMBASIC.ORDERID == AUFK.AUFNR` `A_JOURNALENTRYITEMBASIC.MANDT == AUFK.MANDT`
Division Division Client	`A_JOURNALENTRYITEMBASIC.ORGANIZATIONDIVISION == TSPA.SPART` `A_JOURNALENTRYITEMBASIC.MANDT == TSPA.MANDT`
Partner Business Area Client Partner Business Area	`A_JOURNALENTRYITEMBASIC.MANDT == TGSB.MANDT` `A_JOURNALENTRYITEMBASIC.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Company ID of Trading Partner Client	`A_JOURNALENTRYITEMBASIC.PARTNERCOMPANY == T880.RCOMP` `A_JOURNALENTRYITEMBASIC.MANDT == T880.MANDT`
Partner Company Code Partner Company Code Client	`A_JOURNALENTRYITEMBASIC.PARTNERCOMPANYCODE == T001.BUKRS` `A_JOURNALENTRYITEMBASIC.MANDT == T001.MANDT`
Partner Cost Center ? Partner Cost Center Controlling Area Client	`A_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSKS.DATBI` `A_JOURNALENTRYITEMBASIC.PARTNERCOSTCENTER == CSKS.KOSTL` `A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSKS.KOKRS` `A_JOURNALENTRYITEMBASIC.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type Partner Cost Center Activity Type ? Controlling Area Client	`A_JOURNALENTRYITEMBASIC.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `A_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CSLA.DATBI` `A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CSLA.KOKRS` `A_JOURNALENTRYITEMBASIC.MANDT == CSLA.MANDT`
Partner Functional Area Client Partner Functional Area	`A_JOURNALENTRYITEMBASIC.MANDT == TFKB.MANDT` `A_JOURNALENTRYITEMBASIC.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Order Partner Order Client	`A_JOURNALENTRYITEMBASIC.PARTNERORDER == AUFK.AUFNR` `A_JOURNALENTRYITEMBASIC.MANDT == AUFK.MANDT`
Partner Profit Center ? Controlling Area Partner Profit Center Client	`A_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS` `A_JOURNALENTRYITEMBASIC.PARTNERPROFITCENTER == CEPC.PRCTR` `A_JOURNALENTRYITEMBASIC.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`A_JOURNALENTRYITEMBASIC.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `A_JOURNALENTRYITEMBASIC.MANDT == FAGL_SEGM.MANDT`
Plant Plant Client	`A_JOURNALENTRYITEMBASIC.PLANT == T001W.WERKS` `A_JOURNALENTRYITEMBASIC.MANDT == T001W.MANDT`
Profit Center ? Controlling Area Profit Center Client	`A_JOURNALENTRYITEMBASIC.[column in domain "DATBI"] == CEPC.DATBI` `A_JOURNALENTRYITEMBASIC.CONTROLLINGAREA == CEPC.KOKRS` `A_JOURNALENTRYITEMBASIC.PROFITCENTER == CEPC.PRCTR` `A_JOURNALENTRYITEMBASIC.MANDT == CEPC.MANDT`
Sales District Sales District Client	`A_JOURNALENTRYITEMBASIC.SALESDISTRICT == T171.BZIRK` `A_JOURNALENTRYITEMBASIC.MANDT == T171.MANDT`
Sales Organization Sales Organization Client	`A_JOURNALENTRYITEMBASIC.SALESORGANIZATION == TVKO.VKORG` `A_JOURNALENTRYITEMBASIC.MANDT == TVKO.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`A_JOURNALENTRYITEMBASIC.SEGMENT == FAGL_SEGM.SEGMENT` `A_JOURNALENTRYITEMBASIC.MANDT == FAGL_SEGM.MANDT`
Sold Material Sold Material Client	`A_JOURNALENTRYITEMBASIC.SOLDMATERIAL == MARA.MATNR` `A_JOURNALENTRYITEMBASIC.MANDT == MARA.MANDT`
Transaction Currency Transaction Currency Client	`A_JOURNALENTRYITEMBASIC.TRANSACTIONCURRENCY == TCURC.WAERS` `A_JOURNALENTRYITEMBASIC.MANDT == TCURC.MANDT`