C_PRASmmryTaxPyblQry

PRA Summary Taxes Payable Query | view: CPVSUMTAXPBLQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: T001TKA02/PRA/TP_BALANCE
Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
BalAmtInCompanyCodeCrcy Current Balance
StatusAmtInCompanyCodeCrcy Status Amount
WriteOffAmtInCoCodeCrcy Write Off Amount
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxPyblStatus Taxes Payable Status Show values
BalAmtAgeCode Taxes Payable Write-off Age Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
Country Country/Region Key LAND1
Product Full three char. product code (Major and Detail Products) OIU_FULL_PD_CD
JointVenture Joint venture JV_NAME
DivisionOfInterest Division of interest (DOI) OIU_DOI_NO
SeveranceTaxType Severance Tax Type OIU_SEVT_TAX_TY
GLAccount G/L Account Number SAKNR
UnitJointVenture Unit Venture JV_NAME
StatusLastChangedByUser Taxes Payable Status User
WriteOffResponsibleUser Taxes Payable Writeoff User
AgingPeriod Aging Accounting Period(YYYYMM01) CHAR8
TargetDate Fiscal Period OIU_VDM_FIS_PERIOD
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_PRASMMRYTAXPYBLQRY.MANDT == TCURC.MANDT
  • C_PRASMMRYTAXPYBLQRY.COMPANYCODECURRENCY == TCURC.WAERS
Primary geographical location (PRI geo. loc.)
  • Client
  • Primary geographical location (PRI geo. loc.)
  • ?
  • C_PRASMMRYTAXPYBLQRY.MANDT == OIU_CM_LXPGL.MANDT
  • C_PRASMMRYTAXPYBLQRY.PRIMARYGEOGRLLOCATION == OIU_CM_LXPGL.PRI_GEO_LOC
  • C_PRASMMRYTAXPYBLQRY.[column in domain "LAND1"] == OIU_CM_LXPGL.LAND1