P_CO_DIANStRpBPTaxItem

Format 1005 & 1006 - BP Tax Item | view: PSRCOBPTAXITEM | Extraction: Not supported | Component: Financials Colombia
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Tax Line Item
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType FK Report Format Item Type
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
TaxRate Tax Rate
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
TaxBaseAmountInTransCrcy null
TaxAmountInTransCrcy null
TaxAmountInCountryCrcy null
TaxBaseAmountInCountryCrcy null
TaxBaseAmountInRptgCrcy Amount in Global Currency
TaxAmountInRptgCrcy Amount in Global Currency
Column Name Description
Column Name Description
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
DocumentDate Journal Entry Date
PostingDate Posting Date
Column Name Description
TaxType Tax Type Show values
TaxResultManualModification Tax Result Has Been Modified Manually Show values
TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount Show values
Column Name Description Domain name
AccountingDocumentItem null
TransactionTypeDetermination Transaction Key CHAR3
TaxReturnCountry Country/Region for Tax Report LAND1
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
PostingFiscalPeriod Fiscal period MONAT
DocumentReferenceID Document Reference ID XBLNR1
ReverseDocument Reverse Document BELNR
OriginalReferenceDocument Object key AWKEY
InvoiceReference null
InvoiceReferenceFiscalYear null
ReferenceDocument null
ReferenceDocumentContext null
Customer null
Supplier null
ReportingCountry Reporting Country/Region LAND1
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANSTRPBPTAXITEM.MANDT == T003.MANDT
  • P_CO_DIANSTRPBPTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_CO_DIANSTRPBPTAXITEM.MANDT == T001.MANDT
  • P_CO_DIANSTRPBPTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • P_CO_DIANSTRPBPTAXITEM.COMPANYCODECOUNTRY == T005.LAND1
  • P_CO_DIANSTRPBPTAXITEM.MANDT == T005.MANDT
Currency Key
  • Client
  • Reporting Currency
  • Currency Key
  • Currency Key
  • P_CO_DIANSTRPBPTAXITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPBPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
Reporting Currency
  • Client
  • Reporting Currency
  • Currency Key
  • Currency Key
  • P_CO_DIANSTRPBPTAXITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPBPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • ?
  • Client
  • Report Format Item Type
  • DIAN Report Format
Currency Key
  • Client
  • Reporting Currency
  • Currency Key
  • Currency Key
  • P_CO_DIANSTRPBPTAXITEM.MANDT == TCURC.MANDT
  • P_CO_DIANSTRPBPTAXITEM.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
General Ledger Account
  • Client
  • General Ledger Account
  • Company Code
  • P_CO_DIANSTRPBPTAXITEM.MANDT == SKB1.MANDT
  • P_CO_DIANSTRPBPTAXITEM.GLACCOUNT == SKB1.SAKNR
  • P_CO_DIANSTRPBPTAXITEM.COMPANYCODE == SKB1.BUKRS
Reporting Entity
  • Client
  • Reporting Entity
  • P_CO_DIANSTRPBPTAXITEM.MANDT == SRF_RPG_ENT.MANDT
  • P_CO_DIANSTRPBPTAXITEM.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CO_DIANSTRPBPTAXITEM.[column in domain "KVEWE"] == T683.KVEWE
  • P_CO_DIANSTRPBPTAXITEM.[column in domain "KAPPL"] == T683.KAPPL
  • P_CO_DIANSTRPBPTAXITEM.MANDT == T683.MANDT
  • P_CO_DIANSTRPBPTAXITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
Tax on sales/purchases code
  • Tax on sales/purchases code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CO_DIANSTRPBPTAXITEM.TAXCODE == T007A.MWSKZ
  • P_CO_DIANSTRPBPTAXITEM.MANDT == T007A.MANDT
  • P_CO_DIANSTRPBPTAXITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
Tax Jurisdiction
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax Jurisdiction
  • P_CO_DIANSTRPBPTAXITEM.MANDT == TTXJ.MANDT
  • P_CO_DIANSTRPBPTAXITEM.TAXCALCULATIONPROCEDURE == TTXJ.KALSM
  • P_CO_DIANSTRPBPTAXITEM.TAXJURISDICTION == TTXJ.TXJCD