C_PH_NotAmortizedTaxItemQuery

Consumption View of Tax Item Not Exceding 1PM for PH VAT | view: CSRPHNAMTAXITEMQ | Extraction: Not supported | Component: Financials Philippines
Tables used: VBRK, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, BKPF, BSEG, VBPA, VBPA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, CFIN_AV_CI_ROOT, T005, KNA1, CVI_CUST_LINK, T685, T685A, LFA1, CVI_VEND_LINK, VGTAXBOX, VGTAXBOXT, VGTBS, VGTBST, T007A, ANKA, FAAC_ACLS0, ANKT, FAAC_ACLS0_T, T001, T014, ANLA, FAAT_MD, FAAT_MD_ROOT, T001, T007B, VGTBS, T007L_LU, T007K_LU, T007L_MY, T007K_MY, T007L, T007K, VGTAXGR, VGTGTB
Column Name Description
CompanyCode FK Company Code
AccountingDocumentType Document Type
AccountingDocument Document Number of an Accounting Document
TaxCode Tax on sales/purchases code
FiscalYear Fiscal Year
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
ValidFrom "Valid From" Date for Version
TaxBoxStructureType FK Tax Box Structure Type (Adv. Tax Return)
TaxGroup FK Tax Group
Column Name Description
💲 Transaction Currency (DocumentCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Document Currency
TaxAmount Tax Amount in Document Currency
Column Name Description
Column Name Description
ValidFrom "Valid From" Date for Version
PostingDate Posting Date in the Document
ReportingDate Reporting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
AssetValueDate Asset Value Date
Column Name Description
TaxType Tax Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
TaxJurisdiction Tax Jurisdiction TXJCD
GLAccount General Ledger Account SAKNR
TaxRate Tax Rate DEC3_2
TaxItemGroup Group Indicator for Tax Line Items NUM03
ReportingCountry Reporting Country/Region LAND1
BusinessPlace Business Place J_1BBRANCH
AssetClassName Short Text for Asset Class Name TEXT20
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.COMPANYCODE == T001.BUKRS
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.MANDT == T001.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax Box Structure Type (Adv. Tax Return)
  • Client
  • ?
  • Tax Box Structure Type (Adv. Tax Return)
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.MANDT == VGTBS_CT.MANDT
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "LAND1"] == VGTBS_CT.LAND1
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.TAXBOXSTRUCTURETYPE == VGTBS_CT.TBSTYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Group
  • "Valid From" Date for Version
  • ?
  • Tax Group
  • Client
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • ?
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.VALIDFROM == VGTAXGR.FDATE
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "TBSTYPE"] == VGTAXGR.TBSTYP
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.TAXGROUP == VGTAXGR.ACR_TG
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.MANDT == VGTAXGR.MANDT
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "BLART"] == VGTAXGR.BLART
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "SHKZG_UMSV"] == VGTAXGR.SHKZG_UMSV
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "KTOSL"] == VGTAXGR.KTOSL
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "KTOKK"] == VGTAXGR.KTOKK
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "MWSKZ"] == VGTAXGR.MWSKZ
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "UMSKZ"] == VGTAXGR.UMSKZ
  • C_PH_NOTAMORTIZEDTAXITEMQUERY.[column in domain "LAND1"] == VGTAXGR.LAND1