- 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)
- 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_DIANStRpWhldgTaxItemQuery
Whldg Tax Items Query for Colombia DIAN
| view: CSRCOWHLDGTXITMQ
| Extraction:
Not supported
| Component: Withholding Tax Reporting
Tables used:
BKPF, BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, WITH_ITEM, BKPF, BSEG, ADCP, ADRC, ADR6, BUT000, T001, TKA02, FICODIANC_CNCPT, KNA1, CVI_CUST_LINK, T059Z, T059ZT, SKB1, LFA1, CVI_VEND_LINK, T001, T014, ADRCITY, ADRCITYT, SKAT, T004, T059P, FICODIANC_CNTRY, FICODIANC_DOCTYP, FICODIANC_WHLDG
| Column Name | Description | |
|---|---|---|
| CompanyCode FK | Company Code | |
| FiscalYear | Fiscal Year | |
| StatryRptgEntity FK | Reporting Entity | |
| StatryRptCategory FK | Report Category ID | |
| StatryRptRunID | Report Run ID | |
| CO_DIANConcatenatedKey | Concatenated string representing one item in the final XML | |
| CO_DIANReportFormat FK | DIAN Report Format | |
| CO_DIANReportItemType | Report Format Item Type | |
| AccountingDocument | Journal Entry | |
| WithholdingTaxType FK | Indicator for Withholding Tax Type | |
| TaxItem | Number of Tax Line Item | |
| ReportedTaxNumber | Reporting Tax Number |
| Column Name | Description | |
|---|---|---|
| 💲 Reporting Currency (ReportingCurrency): | ||
| WhldgTaxAmtInReportingCrcy | Withholding Tax Amount in Reporting Currency | |
| WhldgTaxBaseAmtInReportingCrcy | Withholding Tax Base Amount in Reporting Currency | |
| WhldgTaxBaseAmtInCoCodeCrcy | Withholding Tax Base Amount in Company Code Currency | |
| WhldgTaxAmtInCoCodeCrcy | Withholding Tax Amount in Company Code Currency | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PostingDate | Posting Date | |
| DocumentDate | Journal Entry Date | |
| ReportingDate | Posting Date |
| Column Name | Description | |
|---|---|---|
| FinancialAccountType | Account type | Show values |
| CO_DIANTaxNumberType | DIAN Type of Document | Show values |
| BusinessPartnerCategory | Business Partner Category | Show values |
| IsNaturalPerson | Business Partner Is a Natural Person Under the Tax Laws | Show values |
| CO_DIANCountry | DIAN Country/Region Code | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| WhldgTaxCodeName | Withholding Tax Code Description | TEXT40 | |
| GLAccountName | G/L Account Name | CHAR30 | |
| TaxNumberType | Tax Number Type | TEXT2 | |
| 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 | |
| BusinessPlace | Business Place | J_1BBRANCH | |
| 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 | |
| BusinessPartnerOrgLongName | Business Partner Organization Long 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 | |
| BusinessPartner | Business Partner Number | BU_PARTNER | |
| Customer | Customer Number | KUNNR | |
| BusinessPartnerCountry | Country/Region Key | LAND1 | |
| Region | Region (State, Province, County) | REGIO | |
| CityCode | City Code for DIAN Magnetic Media | CHAR3 | |
| CityName | City | TEXT40 | |
| StreetName | Street | TEXT60 |
| Master Data Relations | Join Conditions |
|---|---|
Journal Entry Type
| |
Company Code
| |
DIAN Report Format
|
|
General Ledger Account
| |
Reporting Entity
|
|
Withholding Tax Code
| |
Indicator for Withholding Tax Type
|