C_JP_TaxReallocation

JP Tax Reallocation | view: CJPTAXREALLOC | Extraction: Not supported | Component: Financials Japan
Tables used: VBAP, VBRK, VBRP, GLO_JP_TAXOFFSET, GLO_JP_TAXRESULT, GLO_JP_TAXREALOC, PRCD_ELEMENTS, VBKD, VEDA, VBAK, FPLA, FPLT, /CPD/D_PFP_PS, BKPF, BSET, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_ITEM, VBPA, CVI_CUST_CT_LINK, BUT000, T001, TKA02, T005, CVI_CUST_LINK, CVI_VEND_LINK, PRPS, PROJ
Column Name Description
CustomerProject Commercial Project ID
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
BillingPlan FK Billing plan number / invoicing plan number
BillingPlanItem Item for billing plan/invoice plan/payment cards
BillingDocument Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 Currency Key (TransactionCurrency):
BillingPlanAmount Value to be billed/calc. on date in billing/invoice plan
TotalNetAmount Net Value in Document Currency
TotalTaxAmount Tax Amount in Document Currency
BillDocItemTaxAmt Tax Amount in Document Currency
ItemNetAmount Net Value of Billing item in Document Currency
💲 Currency Key (DocumentCurrency):
TaxAmount Tax Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction 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
JP_TaxOffsetStatus Japan tax reallocation offset status Show values
JP_TaxReallocationStatus Japan tax reallocation status Show values
Column Name Description Domain name
JP_TaxReallocateUUID Tax Reallocation UUID UUID
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
TaxCode Tax on sales/purchases code MWSKZ
ConditionRateRatio Condition Ratio (in Percent or Per Mille) VFPRC_DEC_VALUE
WorkPackage Japan Tax Reallocation Work Package GLO_JP_TAXREALLOCWRKPKCG
BillingPlanRelatedBillgStsDesc Short Text for Fixed Values DDTEXT
OverallBillingStatusDesc Short Text for Fixed Values DDTEXT
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
DocumentReferenceID Reference Document Number XBLNR1
JP_TaxOffsetStatusDesc Short Text for Fixed Values DDTEXT
JP_TaxReallocationStatusDesc Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Customer - Document Customer
  • Bill-to Party
  • Client
  • C_JP_TAXREALLOCATION.BILLTOPARTY == KNA1.KUNNR
  • C_JP_TAXREALLOCATION.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • C_JP_TAXREALLOCATION.COMPANYCODE == T001.BUKRS
  • C_JP_TAXREALLOCATION.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_JP_TAXREALLOCATION.MANDT == TCURC.MANDT
  • C_JP_TAXREALLOCATION.DOCUMENTCURRENCY == TCURC.WAERS
  • C_JP_TAXREALLOCATION.TRANSACTIONCURRENCY == TCURC.WAERS
Material: order item
  • Client
  • Product Number
  • C_JP_TAXREALLOCATION.MANDT == MARA.MANDT
  • C_JP_TAXREALLOCATION.PRODUCT == MARA.MATNR
Sales organization in order header
  • Sales Organization
  • Client
  • C_JP_TAXREALLOCATION.SALESORGANIZATION == TVKO.VKORG
  • C_JP_TAXREALLOCATION.MANDT == TVKO.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_JP_TAXREALLOCATION.MANDT == TCURC.MANDT
  • C_JP_TAXREALLOCATION.DOCUMENTCURRENCY == TCURC.WAERS
  • C_JP_TAXREALLOCATION.TRANSACTIONCURRENCY == TCURC.WAERS