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_DIANStRpSuplrCustOplVw

1008 & 1009 - Supplier and Customer Operational View | view: PSRCOSUPCUSTOPVW | Extraction: Not supported | Component: Financials Colombia

Tables used: ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, FICODIANC_CNCPT, PROJ, PRPS, T001, T014, FICODIANC_GLA, FINSC_LEDGER_REP

🔑 Keys (11)
💰 Amounts (12)
∑ Quantities
📅 Dates (3)
☰ Categorical (6)
Other (8)
🔗 Relations (30)

Column Name	Description
StatryRptgEntity FK	Reporting Entity
StatryRptCategory FK	Report Category ID
StatryRptRunID	Report Run ID
Ledger FK	Ledger in General Ledger Accounting
SourceLedger FK	Source Ledger
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

Column Name	Description
💲 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
GLAccountType	Type of a General Ledger Account	Show values
FinancialAccountType	Account Type	Show values
DebitCreditCode	Debit/Credit Code	Show values
OffsettingAccountType	Offsetting Account Type	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
OffsettingAccount	Offsetting Account	GKONT
AccountingDocumentItem	Journal Entry Posting View Item	BUZEI
TransactionTypeDetermination	Transaction Key	CHAR3
FiscalPeriod	Fiscal Period	POPER
ReferenceDocument	Reference document number	AWREF
ReferenceDocumentItem	Reference Document Item	NUMC6

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