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_DIANStRpSuplrCustOplVw2

1008 & 1009 - Supplier and Customer Operational View | view: PSRCOSUPCUSTOPV2 | 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
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
💲 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
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
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
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

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