P_CO_DIANStRpWhldgTaxItem2

Withholding Tax Items 2 | view: PSRCOSRWHLDGITM2 | Extraction: Not supported | Component: Withholding Tax Reporting
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Tax Line Item
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
CO_DIANReportFormat FK DIAN Report Format
CO_DIANReportItemType Report Format Item Type
WithholdingTaxType FK Indicator for Withholding Tax Type
Column Name Description
💲 Reporting Currency (ReportingCurrency):
WhldgTaxBaseAmtInReportingCrcy Withholding Tax Base Amount in Reporting Currency
WhldgTaxAmtInReportingCrcy Withholding Tax Amount in Reporting Currency
💲 Company Code Currency (CompanyCodeCurrency):
WhldgTaxBaseAmtInCoCodeCrcy Withholding Tax Base Amount in Company Code Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Company Code Currency
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local 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
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
VATRegistration VAT Registration Number STCEG
ReportedTaxNumber Reporting Tax Number FICODIAN_TAX_NUMBER
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
StreetName Street TEXT60
CityName City TEXT40
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.COMPANYCODE == T001.BUKRS
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.COUNTRY == T005.LAND1
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == T005.MANDT
Amount Classification
  • Amount Classification
  • Client
  • DIAN Report Format
  • P_CO_DIANSTRPWHLDGTAXITEM2.CO_DIANAMOUNTCLASSIFICATION == FICODIANI_CLFN.CLF_CODE
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == FICODIANI_CLFN.MANDT
  • P_CO_DIANSTRPWHLDGTAXITEM2.CO_DIANREPORTFORMAT == FICODIANI_CLFN.RPT_FORMAT
DIAN Report Format
  • Client
  • DIAN Report Format
Customer Number
  • Customer Number
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.CUSTOMER == KNA1.KUNNR
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == KNA1.MANDT
General Ledger Account
  • General Ledger Account
  • ?
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.GLACCOUNT == SKA1.SAKNR
  • P_CO_DIANSTRPWHLDGTAXITEM2.[column in domain "KTOPL"] == SKA1.KTOPL
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == SKA1.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == SRF_RPG_ENT.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.SUPPLIER == LFA1.LIFNR
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == LFA1.MANDT
Withholding Tax Code
  • Country/Region Key
  • Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.COUNTRY == T059Z.LAND1
  • P_CO_DIANSTRPWHLDGTAXITEM2.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
  • P_CO_DIANSTRPWHLDGTAXITEM2.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == T059Z.MANDT
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • P_CO_DIANSTRPWHLDGTAXITEM2.COUNTRY == T059P.LAND1
  • P_CO_DIANSTRPWHLDGTAXITEM2.WITHHOLDINGTAXTYPE == T059P.WITHT
  • P_CO_DIANSTRPWHLDGTAXITEM2.MANDT == T059P.MANDT