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)

P_CO_DIANFrmt1001JrnlEntrOplV4

Format 1001 - JE Operational View | view: PSRCO1001JEOPLV4 | Extraction: Not supported | Component: Financials Colombia

Tables used: BKPF, MATDOC, BSEC, EKKO, EKBE, EKPO, EKBEH, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, WITH_ITEM, ACDOCA, BKPF, BSEG, EKKO, ADCP, ADRC, ADR6, BUT000, T001, TKA02, MBEW, T005, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, T059Z, PROJ, LFA1, CVI_VEND_LINK, T030, PRPS, T001, T014, T001K, T007B, T059P, FICODIANC_GLA, FICODIANC_VAT, FICODIANC_WHLDG, FINSC_LEDGER_REP

🔑 Keys (10)
💰 Amounts (3)
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (7)
🔗 Relations (17)

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

Column Name	Description
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency	Amount in Global Currency
TaxBaseAmount	Tax Base Amount in Document Currency
TaxAmount	Tax Amount

Column Name	Description

Column Name	Description
PostingDate	Posting Date

Column Name	Description
FinancialAccountType	Account Type	Show values
OffsettingAccountType	Offsetting Account Type	Show values

Column Name	Description	Domain name
TransactionTypeDetermination	Transaction Key	CHAR3
GLAccount	G/L Account Number	SAKNR
AccountAssignmentNumber	Account Assignment Number	NUM02
OffsettingAccount	Offsetting Account	GKONT
Reference1IDByBusinessPartner	ID of Reference 1 by Business Partner	CHAR12
Reference3IDByBusinessPartner	ID of Reference 3 by Business Partner	CHAR20
CO_DIANAmountClassfctnWhldg	Amount Classification	FICODIAN_CLSFCTN_ID

Master Data Relations	Join Conditions
Journal Entry Type Client Journal Entry Type	`P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == T003.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Alternative G/L Account Number In Company Code Alternative Chart of Accounts for Country/Region Alternative G/L Account Number In Company Code Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL` `P_CO_DIANFRMT1001JRNLENTROPLV4.ALTERNATIVEGLACCOUNT == SKA1.SAKNR` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == SKA1.MANDT`
Chart of Accounts Client Chart of Accounts	`P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == T004.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.CHARTOFACCOUNTS == T004.KTOPL`
Company Code Client Company Code	`P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == T001.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.COMPANYCODE == T001.BUKRS`
Country/Region Key Country/Region Key Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.COMPANYCODECOUNTRY == T005.LAND1` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == T005.MANDT`
Alternative Chart of Accounts for Country/Region Alternative Chart of Accounts for Country/Region Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.COUNTRYCHARTOFACCOUNTS == T004.KTOPL` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == T004.MANDT`
Amount Classification DIAN Report Format Amount Classification Amount Classification Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT` `P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANAMOUNTCLASSIFICATIONGL == FICODIANI_CLFN.CLF_CODE` `P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANAMOUNTCLASSIFICATIONVAT == FICODIANI_CLFN.CLF_CODE` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == FICODIANI_CLFN.MANDT`
Amount Classification DIAN Report Format Amount Classification Amount Classification Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT` `P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANAMOUNTCLASSIFICATIONGL == FICODIANI_CLFN.CLF_CODE` `P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANAMOUNTCLASSIFICATIONVAT == FICODIANI_CLFN.CLF_CODE` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == FICODIANI_CLFN.MANDT`
DIAN Report Format DIAN Report Format Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANREPORTFORMAT == FICODIANI_FORMAT.RPT_FORMAT` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == FICODIANI_FORMAT.MANDT`
Report Format Item Type ? Report Format Item Type DIAN Report Format Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM` `P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE` `P_CO_DIANFRMT1001JRNLENTROPLV4.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == FICODIANC_CNCPT.MANDT`
Customer Number Client Customer Number	`P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == KNA1.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.CUSTOMER == KNA1.KUNNR`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Client	`P_CO_DIANFRMT1001JRNLENTROPLV4.LEDGER == FINSC_LEDGER.RLDNR` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == FINSC_LEDGER.MANDT`
Reporting Entity Client Reporting Entity	`P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == SRF_RPG_ENT.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY`
Supplier Client Supplier	`P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == LFA1.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.SUPPLIER == LFA1.LIFNR`
Tax on Sales/Purchases Code Tax on Sales/Purchases Code Client ?	`P_CO_DIANFRMT1001JRNLENTROPLV4.TAXCODE == T007A.MWSKZ` `P_CO_DIANFRMT1001JRNLENTROPLV4.MANDT == T007A.MANDT` `P_CO_DIANFRMT1001JRNLENTROPLV4.[column in domain "KALSM_D"] == T007A.KALSM`