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_DIANStRpCustomerOpenItm

Priv. Cust. Balances for Colombia DIAN | view: PSRCOCUSTOPITM | 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, T004, T001, TKA02, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, SKA1, PROJ, LFA1, CVI_VEND_LINK, PRPS, T001, T014, ADRCITY, ADRCITYT, SKAT, T004, FICODIANC_CNTRY, FICODIANC_GLA, FICODIANC_EXMAMT, FICODIANC_MINAMT, FICODIANC_DOCTYP, FINSC_LEDGER_REP

🔑 Keys (9)
💰 Amounts (13)
∑ Quantities
📅 Dates (2)
☰ Categorical (7)
Other (28)
🔗 Relations (21)

Column Name	Description
StatryRptgEntity FK	Reporting Entity
StatryRptCategory FK	Report Category ID
StatryRptRunID	Report Run ID
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):
OpnItmAmountInCountryCurrency	Open Items Value
💲 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
ClearingDate	Clearing Date

Column Name	Description
BusinessPartnerCategory	Business Partner Category	Show values
IsBelowMinimumAmountThreshold	Below Minimum Amount	Show values
CO_DIANTaxNumberType	DIAN Type of Document	Show values
IsNaturalPerson	Natural Person	Show values
CO_DIANCountry	DIAN Country/Region Code	Show values
DebitCreditCode	Debit/Credit Code	Show values
FinancialAccountType	Account Type	Show values

Column Name	Description	Domain name
ReferenceDocument	Reference document number	AWREF
ReferenceDocumentItem	Reference Document Item	NUMC6
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
TaxNumberType	Tax Number Type	TEXT2
BusinessPartner	Business Partner Number	BU_PARTNER
ReportedTaxNumber	Reporting Tax Number	FICODIAN_TAX_NUMBER
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
StreetName	Street	TEXT60
CityName	City	TEXT40
GLAccountName	G/L Account Name	CHAR30
FiscalPeriod	Fiscal Period	POPER
AccountingDocumentItem	Journal Entry Posting View Item	BUZEI
Supplier	Account Number of Supplier	LIFNR
Customer	Customer Number	KUNNR

Master Data Relations	Join Conditions
Journal Entry Type Client Journal Entry Type	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == T003.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Alternative G/L Account Number In Company Code Client Alternative G/L Account Number In Company Code ?	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == SKA1.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR` `P_CO_DIANSTRPCUSTOMEROPENITM.[column in domain "KTOPL"] == SKA1.KTOPL`
Balance Transaction Currency Client Balance Transaction Currency	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS`
Company Code Company Code Client	`P_CO_DIANSTRPCUSTOMEROPENITM.COMPANYCODE == T001.BUKRS` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == T001.MANDT`
Company Code Currency Client Company Code Currency	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.COMPANYCODECURRENCY == TCURC.WAERS`
Amount Classification DIAN Report Format Amount Classification Client	`P_CO_DIANSTRPCUSTOMEROPENITM.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT` `P_CO_DIANSTRPCUSTOMEROPENITM.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == FICODIANI_CLFN.MANDT`
DIAN Report Format DIAN Report Format Client	`P_CO_DIANSTRPCUSTOMEROPENITM.CO_DIANREPORTFORMAT == FICODIANI_FORMAT.RPT_FORMAT` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == FICODIANI_FORMAT.MANDT`
Report Format Item Type Report Format Item Type DIAN Report Format ? Client	`P_CO_DIANSTRPCUSTOMEROPENITM.CO_DIANREPORTITEMTYPE == FICODIANC_CNCPT.CPT_CODE` `P_CO_DIANSTRPCUSTOMEROPENITM.CO_DIANREPORTFORMAT == FICODIANC_CNCPT.RPT_FORMAT` `P_CO_DIANSTRPCUSTOMEROPENITM.[column in domain "FICODIAN_VALID_FROM"] == FICODIANC_CNCPT.VALID_FROM` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == FICODIANC_CNCPT.MANDT`
Freely Defined Currency 1 Client Freely Defined Currency 1	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY1 == TCURC.WAERS`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY2 == TCURC.WAERS` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Client Freely Defined Currency 4	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY4 == TCURC.WAERS`
Freely Defined Currency 5 Client Freely Defined Currency 5	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY5 == TCURC.WAERS`
Freely Defined Currency 6 Client Freely Defined Currency 6	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY6 == TCURC.WAERS`
Freely Defined Currency 7 Client Freely Defined Currency 7	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Client Freely Defined Currency 8	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.FREEDEFINEDCURRENCY8 == TCURC.WAERS`
G/L Account Company Code Client G/L Account	`P_CO_DIANSTRPCUSTOMEROPENITM.COMPANYCODE == SKB1.BUKRS` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == SKB1.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.GLACCOUNT == SKB1.SAKNR`
Global Currency Client Global Currency	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.GLOBALCURRENCY == TCURC.WAERS`
Special G/L Indicator Account Type Client Special G/L Indicator	`P_CO_DIANSTRPCUSTOMEROPENITM.FINANCIALACCOUNTTYPE == T074U.KOART` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == T074U.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.SPECIALGLCODE == T074U.UMSKZ`
Reporting Entity Client Reporting Entity	`P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == SRF_RPG_ENT.MANDT` `P_CO_DIANSTRPCUSTOMEROPENITM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY`
Transaction Currency Transaction Currency Client	`P_CO_DIANSTRPCUSTOMEROPENITM.TRANSACTIONCURRENCY == TCURC.WAERS` `P_CO_DIANSTRPCUSTOMEROPENITM.MANDT == TCURC.MANDT`