I_JP_TaxReallocationDetail

Japan Tax Reallocation Detail | view: IJPTAXDETAIL | Extraction: Not supported | Component: Financials Japan
Column Name Description
CustomerProject Commercial Project ID
BillingPlan FK Billing plan number / invoicing plan number
BillingPlanItem Item for billing plan/invoice plan/payment cards
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
BillingDocument Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 Currency Key (TransactionCurrency):
BillingPlanAmount Value to be billed/calc. on date in billing/invoice plan
ItemNetAmount Net Value of Billing item in Document Currency
BillDocItemTaxAmt Tax Amount in Document Currency
TotalNetAmount Net Value in Document Currency
TotalTaxAmount Tax Amount in Document Currency
Column Name Description
Column Name Description
BillingPlanBillingDate Billing Date
BillingPlanServiceStartDate Settlement date for deadline
BillingPlanServiceEndDate Settlement date for deadline
BillingDocumentDate Billing Date
Column Name Description
BillingPlanRelatedBillgStatus Billing status for the billing plan/invoice plan date Show values
OverallBillingStatus SD Billing Status Show values
BillingDocumentIsCancelled Billing document is canceled Show values
JP_TaxOffsetStatus Japan tax reallocation offset status Show values
JP_TaxReallocationStatus Japan tax reallocation status Show values
Column Name Description Domain name
TaxCode Tax on sales/purchases code MWSKZ
ConditionRateRatio Condition Ratio (in Percent or Per Mille) VFPRC_DEC_VALUE
CancelledBillingDocument Number of canceled billing document VBELN
DocumentReferenceID Reference Document Number XBLNR1
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Customer - Document Customer
  • Bill-to Party
  • Client
  • I_JP_TAXREALLOCATIONDETAIL.BILLTOPARTY == KNA1.KUNNR
  • I_JP_TAXREALLOCATIONDETAIL.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • I_JP_TAXREALLOCATIONDETAIL.COMPANYCODE == T001.BUKRS
  • I_JP_TAXREALLOCATIONDETAIL.MANDT == T001.MANDT
Material: order item
  • Client
  • Product Number
  • I_JP_TAXREALLOCATIONDETAIL.MANDT == MARA.MANDT
  • I_JP_TAXREALLOCATIONDETAIL.PRODUCT == MARA.MATNR
Sales document item category
  • Client
  • Sales document item category
  • I_JP_TAXREALLOCATIONDETAIL.MANDT == TVPT.MANDT
  • I_JP_TAXREALLOCATIONDETAIL.SALESORDERITEMCATEGORY == TVPT.PSTYV
Sales organization in order header
  • Client
  • Sales Organization
  • I_JP_TAXREALLOCATIONDETAIL.MANDT == TVKO.MANDT
  • I_JP_TAXREALLOCATIONDETAIL.SALESORGANIZATION == TVKO.VKORG
Currency Key
  • Client
  • Currency Key
  • I_JP_TAXREALLOCATIONDETAIL.MANDT == TCURC.MANDT
  • I_JP_TAXREALLOCATIONDETAIL.TRANSACTIONCURRENCY == TCURC.WAERS