Application Platform (AP)
Basis Components (BC)
Business Mobile (MOB)
Business Network Solutions (BNS)
Controlling (CO)
Cross-Application Components (CA)
Cross-Application Components (CA)
Customer Relationship Management (CRM)
Enterprise Contract Management (CM)
Enterprise Controlling (EC)
Enterprise information management solutions (EIM)
Environment, Health, and Safety / Product Compliance (EHS)
Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
  - ACR Activities (FI-LOC-VAT)
  - Audit Reporting (FI-LOC-AUR)
  - Cash Flow Localization (FI-LOC-CF)
  - Cash Management (FI-LOC-CM)
  - Contract Accounts Receivable and Payable (FI-LOC-CA)
  - Corporate Income Tax Framework (FI-LOC-CIT)
  - Globalization Service: Business Place (FI-LOC-BUP)
  - Golden Audit Interface (FI-LOC-GAI)
  - Localization Asset Accounting (FI-LOC-AA)
  - Localization E-Payment Integration (FI-LOC-EPI)
  - Localization Financials (FI-LOC-FI)
    - Financials Arabic Emirates (FI-LOC-FI-AE)
    - Financials Argentina (FI-LOC-FI-AR)
    - Financials Austria (FI-LOC-FI-AT)
    - Financials Belgium (FI-LOC-FI-BE)
    - Financials Brazil (FI-LOC-FI-BR)
    - Financials Chile (FI-LOC-FI-CL)
    - Financials China (FI-LOC-FI-CN)
    - Financials Colombia (FI-LOC-FI-CO)
    - Financials Czech Republic (FI-LOC-FI-CZ)
    - Financials Denmark (FI-LOC-FI-DK)
    - Financials Egypt (FI-LOC-FI-EG)
    - Financials France (FI-LOC-FI-FR)
    - Financials Germany (FI-LOC-FI-DE)
    - Financials Great Britain (FI-LOC-FI-GB)
    - Financials Hungary (FI-LOC-FI-HU)
    - Financials Indonesia (FI-LOC-FI-ID)
    - Financials Ireland (FI-LOC-FI-IE)
    - Financials Israel (FI-LOC-FI-IL)
    - Financials Italy (FI-LOC-FI-IT)
    - Financials Japan (FI-LOC-FI-JP)
    - Financials Kazakhastan (FI-LOC-FI-KZ)
    - Financials Luxembourg (FI-LOC-FI-LU)
    - Financials Malaysia (FI-LOC-FI-MY)
    - Financials Mexico (FI-LOC-FI-MX)
    - Financials Netherlands (FI-LOC-FI-NL)
    - Financials New Zealand (FI-LOC-FI-NZ)
    - Financials Norway (FI-LOC-FI-NO)
    - Financials Peru (FI-LOC-FI-PE)
    - Financials Philippines (FI-LOC-FI-PH)
    - Financials Poland (FI-LOC-FI-PL)
    - Financials Portugal (FI-LOC-FI-PT)
    - Financials Qatar (FI-LOC-FI-QA)
    - Financials Romania (FI-LOC-FI-RO)
    - Financials Russia (FI-LOC-FI-RU)
    - Financials Singapore (FI-LOC-FI-SG)
    - Financials Slovak republic (FI-LOC-FI-SK)
    - Financials Slovenia (FI-LOC-FI-SI)
    - Financials South Korea (FI-LOC-FI-KR)
    - Financials Spain (FI-LOC-FI-ES)
    - Financials Sweden (FI-LOC-FI-SE)
    - Financials Switzerland (FI-LOC-FI-CH)
    - Financials Taiwan (FI-LOC-FI-TW)
    - Financials Thailand (FI-LOC-FI-TH)
    - Financials Turkey (FI-LOC-FI-TR)
    - Financials USA (FI-LOC-FI-US)
    - Financials Ukraine (FI-LOC-FI-UA)
    - Financials Venezuela (FI-LOC-FI-VE)
  - Localization Financials (generic parts) (FI-LOC-GEN)
  - Localization Financials EC Sales List (FI-LOC-ECS)
  - Localization Financials Statements (FI-LOC-FS)
  - Localization Funds Management (FI-LOC-FM)
  - Localization Logistics (FI-LOC-LO)
  - Localization for Utilities Industry (FI-LOC-UT)
  - Payment Receipt (FI-LOC-PR)
  - SAF-T Reporting (Generic Part) (FI-LOC-SAF)
  - Statutory Reporting (FI-LOC-IS)
  - Statutory Reporting Framework (FI-LOC-SRF)
  - Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
Financial Services (FS)
Global Trade Services (SLL)
Investment Management (IM)
LOD Components (LOD)
Legal Content Management (LCM)
Logistics - General (LO)
Logistics Execution (LE)
Materials Management (MM)
Occasional Platform User (OPU)
Payroll (PY)
Personnel Management (PA)
Plant Maintenance (PM)
Portfolio and Project Management (PPM)
Product Lifecycle Management (PLM)
Production Planning and Control (PP)
Project System (PS)
Public Sector Management (PSM)
Purchasing SAP Cloud (PUR)
Quality Management (QM)
Real Estate Management (RE)
SAP Business Warehouse (BW)
SAP Supplier Lifecycle Management (SLC)
Sales and Distribution (SD)
Service (SV)
Supply Chain Management (SCM)
Sustainability management (SUS)
Transportation Management (TM)

C_CO_DIANStRpJournalEntryItemC

G/L Formats - Journal Entry Item Cube | view: CSRCODOCJRNLC | TRAN | Extraction: Not supported | Component: Financials Colombia

Tables used: BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, ADCP, ADRC, BUT000, T001, TKA02, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, PROJ, LFA1, CVI_VEND_LINK, PRPS, T001, T014, FICODIANC_GLA, FINSC_LEDGER_REP

🔑 Keys (11)
💰 Amounts (13)
∑ Quantities
📅 Dates (3)
☰ Categorical (7)
Other (30)
🔗 Relations (29)

Column Name	Description
StatryRptgEntity FK	Reporting Entity
StatryRptCategory FK	Report Category ID
StatryRptRunID	Report Run ID
Ledger FK	Ledger in General Ledger Accounting
CompanyCode FK	Company Code
FiscalYear	Fiscal Year
AccountingDocument	Journal Entry
LedgerGLLineItem	Ledger Journal Entry Item
CO_DIANReportFormat FK	DIAN Report Format
CO_DIANReportItemType FK	Report Format Item Type
SourceLedger FK	Source Ledger

Column Name	Description
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency	Amount in Global Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy	Amount in Balance Transaction Currency
💲 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

Column Name	Description
PostingDate	Posting Date
DocumentDate	Journal Entry Date
ClearingDate	Clearing Date

Column Name	Description
IsNaturalPerson	Natural Person	Show values
BusinessPartnerCategory	Business Partner Category	Show values
GLAccountType	Type of a General Ledger Account	Show values
FinancialAccountType	Account Type	Show values
DebitCreditCode	Debit/Credit Code	Show values
IsReversal	Indicator: Item is Reversing Another Item	Show values
IsReversed	Indicator: Item is Reversed	Show values

Column Name	Description	Domain name
Supplier	Account Number of Supplier	LIFNR
Customer	Customer Number	KUNNR
TaxNumber1	Tax Number 1	STCD1
TaxNumber2	Tax Number 2	STCD2
TaxNumber3	Tax Number 3	CHAR18
TaxNumber4	Tax Number 4	CHAR18
TaxNumber5	Tax Number 5	CHAR60
VATRegistration	VAT Registration Number	STCEG
ReportedTaxNumber	Reporting Tax Number	FICODIAN_TAX_NUMBER
TaxNumberType	Tax Number Type	TEXT2
BusinessPartner	Business Partner Number	BU_PARTNER
FirstName	First name of business partner (person)	BU_NAME
MiddleName	Middle name or second forename of a person	BU_NAME
LastName	Last name of business partner (person)	BU_NAME
AdditionalLastName	Other Last Name of a Person	BU_NAME
OrganizationBPName1	Name 1 of organization	BU_NAME
OrganizationBPName2	Name 2 of organization	BU_NAME
OrganizationBPName3	Name 3 of organization	BU_NAME
OrganizationBPName4	Name 4 of organization	BU_NAME
BusinessPartnerCountry	Country/Region Key	LAND1
Region	Region (State, Province, County)	REGIO
CityCode	City code for city/street file	CITY_CODE
CityName	City	TEXT40
StreetName	Street	TEXT60
AccountingDocumentItem	Journal Entry Posting View Item	BUZEI
ReferenceDocument	Reference document number	AWREF
ReferenceDocumentItem	Reference Document Item	NUMC6
TransactionTypeDetermination	Transaction Key	CHAR3
FiscalPeriod	Fiscal Period	POPER
CompanyCodeAddressID	Address	ADRNR

Master Data Relations	Join Conditions
Journal Entry Type Journal Entry Type Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.ACCOUNTINGDOCUMENTTYPE == T003.BLART` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T003.MANDT`
Alternative G/L Account Number In Company Code Alternative G/L Account Number In Company Code Alternative Chart of Accounts for Country/Region Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.ALTERNATIVEGLACCOUNT == SKA1.SAKNR` `C_CO_DIANSTRPJOURNALENTRYITEMC.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == SKA1.MANDT`
Balance Transaction Currency Balance Transaction Currency Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.BALANCETRANSACTIONCURRENCY == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Chart of Accounts Chart of Accounts Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.CHARTOFACCOUNTS == T004.KTOPL` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T004.MANDT`
Company Code Company Code Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODE == T001.BUKRS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T001.MANDT`
Country key Client Country/Region Key	`C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T005.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODECOUNTRY == T005.LAND1`
Company Code Currency Client Company Code Currency	`C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODECURRENCY == TCURC.WAERS`
Cost Center ? Cost Center ? Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "KOKRS"] == CSKS.KOKRS` `C_CO_DIANSTRPJOURNALENTRYITEMC.COSTCENTER == CSKS.KOSTL` `C_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "DATBI"] == CSKS.DATBI` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == CSKS.MANDT`
Alternative Chart of Accounts for Country/Region Alternative Chart of Accounts for Country/Region Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.COUNTRYCHARTOFACCOUNTS == T004.KTOPL` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T004.MANDT`
Amount Classification Amount Classification DIAN Report Format Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE` `C_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FICODIANI_CLFN.MANDT`
DIAN Report Format DIAN Report Format Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTFORMAT == FICODIANI_FORMAT.RPT_FORMAT` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FICODIANI_FORMAT.MANDT`
Report Format Item Type DIAN Report Format ? Client Report Format Item Type	`C_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT` `C_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FICODIANC_CNCPT.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY1 == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY2 == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Freely Defined Currency 5 Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY5 == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Freely Defined Currency 6 Freely Defined Currency 6 Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY6 == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Freely Defined Currency 7 Client Freely Defined Currency 7	`C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Client Freely Defined Currency 8	`C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.FREEDEFINEDCURRENCY8 == TCURC.WAERS`
G/L Account Company Code G/L Account Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.COMPANYCODE == SKB1.BUKRS` `C_CO_DIANSTRPJOURNALENTRYITEMC.GLACCOUNT == SKB1.SAKNR` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.GLOBALCURRENCY == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Source Ledger Ledger in General Ledger Accounting	`C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FINSC_LEDGER.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.SOURCELEDGER == FINSC_LEDGER.RLDNR` `C_CO_DIANSTRPJOURNALENTRYITEMC.LEDGER == FINSC_LEDGER.RLDNR`
Profit Center ? ? Profit Center Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "KOKRS"] == CEPC.KOKRS` `C_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "DATBI"] == CEPC.DATBI` `C_CO_DIANSTRPJOURNALENTRYITEMC.PROFITCENTER == CEPC.PRCTR` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == CEPC.MANDT`
Source Ledger Client Source Ledger Ledger in General Ledger Accounting	`C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == FINSC_LEDGER.MANDT` `C_CO_DIANSTRPJOURNALENTRYITEMC.SOURCELEDGER == FINSC_LEDGER.RLDNR` `C_CO_DIANSTRPJOURNALENTRYITEMC.LEDGER == FINSC_LEDGER.RLDNR`
Special G/L Indicator Special G/L Indicator Account Type Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.SPECIALGLCODE == T074U.UMSKZ` `C_CO_DIANSTRPJOURNALENTRYITEMC.FINANCIALACCOUNTTYPE == T074U.KOART` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T074U.MANDT`
Reporting Entity Reporting Entity Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == SRF_RPG_ENT.MANDT`
Tax on Sales/Purchases Code ? Tax on Sales/Purchases Code Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.[column in domain "KALSM_D"] == T007A.KALSM` `C_CO_DIANSTRPJOURNALENTRYITEMC.TAXCODE == T007A.MWSKZ` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == T007A.MANDT`
Transaction Currency Transaction Currency Client	`C_CO_DIANSTRPJOURNALENTRYITEMC.TRANSACTIONCURRENCY == TCURC.WAERS` `C_CO_DIANSTRPJOURNALENTRYITEMC.MANDT == TCURC.MANDT`