P_ID_StRpTaxItemFromBilling

ID Tax Item from billing | view: PIDSTRPTAXITMFB | Extraction: Not supported | Component: Financials Indonesia
Tables used: BKPF, VBRK, VBRP, CFIN_AV_CI_PART, CFIN_AV_SO_PART, BSEC, VBPA3, PRCD_ELEMENTS, 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, T007A, T001, T014, T007B
Column Name Description
CompanyCode Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
TaxItem Number of Line Item Within Accounting Document
TaxCode Tax on sales/purchases code
TransactionTypeDetermination Transaction Key
TaxBox Tax Box (Adv. Tax Return)
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
TaxBoxStructureType Tax Box Structure Type (Adv. Tax Return)
TaxGroup Tax Group
BillingDocument Billing Document
BillingDocumentItem Billing Item
Column Name Description
EligibleAmountForCashDiscount null
NetAmount Net Value of Billing item in Document Currency
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy Tax Amount in Document Currency
TaxAmountInTransCrcy Tax Amount in Document Currency
Column Name Description
BillingQuantity Actual billed quantity
Column Name Description
TaxBoxStrucValidityStartDate Valid From Date for Tax Box Structure
TaxBoxStrucValidityEndDate Valid To Date for Tax Box Structure
PostingDate Posting Date in the Document
DocumentDate Journal Entry Date
TaxRateValidityStartDate Valid-From Date of the Tax Rate
TaxReportingDate Tax Reporting Date
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
Column Name Description Domain name
TaxRate TaxRate (Percentage)
LuxuryTaxRate TaxRate (Percentage)
Ledger Ledger FINS_LEDGER
BusinessPlace Business Place J_1BBRANCH
Customer Customer Number KUNNR
BillingDocumentItemText Short text for sales order item TEXT40
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • P_ID_STRPTAXITEMFROMBILLING.MANDT == TVFK.MANDT
  • P_ID_STRPTAXITEMFROMBILLING.BILLINGDOCUMENTTYPE == TVFK.FKART
Material Number
  • Client
  • Material Number
  • P_ID_STRPTAXITEMFROMBILLING.MANDT == MARA.MANDT
  • P_ID_STRPTAXITEMFROMBILLING.MATERIAL == MARA.MATNR
Sales Organization
  • Client
  • Sales Organization
  • P_ID_STRPTAXITEMFROMBILLING.MANDT == TVKO.MANDT
  • P_ID_STRPTAXITEMFROMBILLING.SALESORGANIZATION == TVKO.VKORG