P_CO_DIANStRpBPTaxItem3

Format 1005 & 1006 - BP Tax Item | view: PCOSRBPTXITM3 | Extraction: Not supported | Component: Financials Colombia
Tables used: BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, ACDOCA, BKPF, BSEG, BSET, ADCP, ADRC, BUT000, T001, TKA02, T005, KNA1, KNB1, KNB5, CVI_CUST_LINK, FINSC_LEDGER, LFA1, LFB1, CVI_VEND_LINK, T007A, T001, T014, FICODIANC_VAT, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
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
💲 Currency Key (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
💲 Reporting Currency (ReportingCurrency):
TaxBaseAmountInRptgCrcy Base Amount for Tax Calculation
TaxAmountInRptgCrcy DIAN BP Tax Amount
InptTxDebitAmtInCntryCurrency VAT Input: Debit Value
OutpTxDebitAmtInCntryCurrency VAT Output: Debit Value
OutpTxCrdtAmtInCntryCurrency VAT Output: Credit Value
InptTxCrdtAmtInCntryCurrency VAT Input: Credit Value
CnsmpnTxAmtInCountryCurrency DIAN BP Consumption Tax Amount
Column Name Description
Column Name Description
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
TaxType Tax Type Show values
Column Name Description Domain name
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 null
TransactionTypeDetermination Transaction Key CHAR3
Customer null
Supplier null
ReferenceDocument null
OriginalReferenceDocument Object key AWKEY
BusinessPartnerUUID Business Partner GUID SYSUUID
ReferenceDocumentContext null
TaxReturnCountry Country/Region for Tax Report LAND1
ReportingCountry Reporting Country/Region LAND1
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == T003.MANDT
  • P_CO_DIANSTRPBPTAXITEM3.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == T001.MANDT
  • P_CO_DIANSTRPBPTAXITEM3.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • P_CO_DIANSTRPBPTAXITEM3.COMPANYCODECOUNTRY == T005.LAND1
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == T005.MANDT
Currency Key
  • Reporting Currency
  • Currency Key
  • Client
  • P_CO_DIANSTRPBPTAXITEM3.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM3.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == TCURC.MANDT
Reporting Currency
  • Reporting Currency
  • Currency Key
  • Client
  • P_CO_DIANSTRPBPTAXITEM3.COUNTRYCURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM3.COMPANYCODECURRENCY == TCURC.WAERS
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == TCURC.MANDT
Amount Classification
  • Amount Classification
  • DIAN Report Format
  • Client
DIAN Report Format
  • DIAN Report Format
  • Client
Report Format Item Type
  • Report Format Item Type
  • DIAN Report Format
  • ?
  • Client
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • P_CO_DIANSTRPBPTAXITEM3.GLACCOUNT == SKB1.SAKNR
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == SKB1.MANDT
  • P_CO_DIANSTRPBPTAXITEM3.COMPANYCODE == SKB1.BUKRS
Reporting Entity
  • Client
  • Reporting Entity
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == SRF_RPG_ENT.MANDT
  • P_CO_DIANSTRPBPTAXITEM3.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • P_CO_DIANSTRPBPTAXITEM3.TAXCALCULATIONPROCEDURE == T683.KALSM
  • P_CO_DIANSTRPBPTAXITEM3.[column in domain "KVEWE"] == T683.KVEWE
  • P_CO_DIANSTRPBPTAXITEM3.[column in domain "KAPPL"] == T683.KAPPL
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == T683.MANDT
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax on sales/purchases code
  • P_CO_DIANSTRPBPTAXITEM3.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == T007A.MANDT
  • P_CO_DIANSTRPBPTAXITEM3.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax Jurisdiction
  • Client
  • P_CO_DIANSTRPBPTAXITEM3.TAXCALCULATIONPROCEDURE == TTXJ.KALSM
  • P_CO_DIANSTRPBPTAXITEM3.TAXJURISDICTION == TTXJ.TXJCD
  • P_CO_DIANSTRPBPTAXITEM3.MANDT == TTXJ.MANDT