P_CO_DIANStRpBPTaxItem2

Format 1005 & 1006 - BP Tax Item | view: PCOSRBPTXITM2 | 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
Supplier null
Customer null
Reference1IDByBusinessPartner null
Reference3IDByBusinessPartner null
ReportingCountry Reporting Country/Region LAND1
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.COMPANYCODE == T001.BUKRS
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.COMPANYCODECOUNTRY == T005.LAND1
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == T005.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.DOCUMENTCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == TCURC.MANDT
Reporting Currency
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.DOCUMENTCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == TCURC.MANDT
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
DIAN Report Format
  • Client
  • DIAN Report Format
Report Format Item Type
  • ?
  • Report Format Item Type
  • Client
  • DIAN Report Format
Currency Key
  • Currency Key
  • Currency Key
  • Reporting Currency
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.DOCUMENTCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == TCURC.MANDT
General Ledger Account
  • Company Code
  • General Ledger Account
  • Client
  • P_CO_DIANSTRPBPTAXITEM2.COMPANYCODE == SKB1.BUKRS
  • P_CO_DIANSTRPBPTAXITEM2.GLACCOUNT == SKB1.SAKNR
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == SKB1.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == SRF_RPG_ENT.MANDT
  • P_CO_DIANSTRPBPTAXITEM2.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CO_DIANSTRPBPTAXITEM2.[column in domain "KVEWE"] == T683.KVEWE
  • P_CO_DIANSTRPBPTAXITEM2.[column in domain "KAPPL"] == T683.KAPPL
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == T683.MANDT
  • P_CO_DIANSTRPBPTAXITEM2.TAXCALCULATIONPROCEDURE == T683.KALSM
Tax on sales/purchases code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on sales/purchases code
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == T007A.MANDT
  • P_CO_DIANSTRPBPTAXITEM2.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • P_CO_DIANSTRPBPTAXITEM2.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_CO_DIANSTRPBPTAXITEM2.MANDT == TTXJ.MANDT
  • P_CO_DIANSTRPBPTAXITEM2.TAXJURISDICTION == TTXJ.TXJCD
  • P_CO_DIANSTRPBPTAXITEM2.TAXCALCULATIONPROCEDURE == TTXJ.KALSM