I_PRAAcctgDocSmmryTaxPybl

PRA Acctg Document Summary Tax Pybl | view: IPVSMMRYTAXPYBL | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: T001TKA02/PRA/TP_BALANCE
Column Name Description
CompanyCode Company Code
Country Country/Region Key
PrimaryGeogrlLocation FK Primary geographical location (PRI geo. loc.)
SalesDate Sales Date / Month
Product Full three char. product code (Major and Detail Products)
JointVenture Joint venture
DivisionOfInterest Division of interest (DOI)
SeveranceTaxType Severance Tax Type
GLAccount G/L Account Number
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
GLAccountType Account Type Show values
Column Name Description Domain name
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
  • Currency Key
  • Client
  • I_PRAACCTGDOCSMMRYTAXPYBL.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PRAACCTGDOCSMMRYTAXPYBL.MANDT == TCURC.MANDT
Primary geographical location (PRI geo. loc.)
  • ?
  • Primary geographical location (PRI geo. loc.)
  • Client
  • I_PRAACCTGDOCSMMRYTAXPYBL.[column in domain "LAND1"] == OIU_CM_LXPGL.LAND1
  • I_PRAACCTGDOCSMMRYTAXPYBL.PRIMARYGEOGRLLOCATION == OIU_CM_LXPGL.PRI_GEO_LOC
  • I_PRAACCTGDOCSMMRYTAXPYBL.MANDT == OIU_CM_LXPGL.MANDT