P_JP_invcsummaryhierarch

Invoice Summary Customer Hierarchy | view: PJPINVCSUMMARYHC | Extraction: Not supported | Component: Financials Japan
Tables used: ISJPHIERARCHY
Column Name Description
bukrs FK Company Code
kunnr FK Customer Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
invsumrole Invoice Summary Role Show values
holiduedate Consider JP Holidays In Due Date Calculation Show values
rulezterm Proposal of Payment Term Show values
Column Name Description Domain name
invsumrecip Invoice Summary Recipient ISJPINVSUMRECIP
invsumpayer Invoice Summary Payer ISJPINVSUMPAYER
headertax Calculate Tax at MI Header Level ISJPHEADERTAX
bankcharge Bank Charges Paid By Payee ISJPBANKCHARGE
speccaserel Relevant for Special Cases ISJPSPECCASEREL
Master Data Relations Join Conditions
Bank Keys
  • Bank Keys
  • Client
  • Country/Region Key of Bank
  • P_JP_INVCSUMMARYHIERARCH.BANKK == BNKA.BANKL
  • P_JP_INVCSUMMARYHIERARCH.MANDT == BNKA.MANDT
  • P_JP_INVCSUMMARYHIERARCH.BANKS == BNKA.BANKS
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • P_JP_INVCSUMMARYHIERARCH.MANDT == T005.MANDT
  • P_JP_INVCSUMMARYHIERARCH.BANKS == T005.LAND1
Company Code
  • Client
  • Company Code
  • Customer Number
  • P_JP_INVCSUMMARYHIERARCH.MANDT == KNB1.MANDT
  • P_JP_INVCSUMMARYHIERARCH.BUKRS == KNB1.BUKRS
  • P_JP_INVCSUMMARYHIERARCH.KUNNR == KNB1.KUNNR
Customer Number
  • Client
  • Company Code
  • Customer Number
  • P_JP_INVCSUMMARYHIERARCH.MANDT == KNB1.MANDT
  • P_JP_INVCSUMMARYHIERARCH.BUKRS == KNB1.BUKRS
  • P_JP_INVCSUMMARYHIERARCH.KUNNR == KNB1.KUNNR
Number range number for Monthly Invoice
  • ?
  • ?
  • Client
  • Number range number for Monthly Invoice
  • ?
  • P_JP_INVCSUMMARYHIERARCH.[column in domain "NRYEAR"] == NRIV.TOYEAR
  • P_JP_INVCSUMMARYHIERARCH.[column in domain "NROBJ"] == NRIV.OBJECT
  • P_JP_INVCSUMMARYHIERARCH.MANDT == NRIV.CLIENT
  • P_JP_INVCSUMMARYHIERARCH.MINRNR == NRIV.NRRANGENR
  • P_JP_INVCSUMMARYHIERARCH.[column in domain "NRSOBJ"] == NRIV.SUBOBJECT
Bank Charge Pattern ID
  • Client
  • Company Code
  • Bank Charge Pattern ID
Number range number for Payer Invoice
  • ?
  • ?
  • Number range number for Payer Invoice
  • Client
  • ?
  • P_JP_INVCSUMMARYHIERARCH.[column in domain "NRYEAR"] == NRIV.TOYEAR
  • P_JP_INVCSUMMARYHIERARCH.[column in domain "NROBJ"] == NRIV.OBJECT
  • P_JP_INVCSUMMARYHIERARCH.PINRNR == NRIV.NRRANGENR
  • P_JP_INVCSUMMARYHIERARCH.MANDT == NRIV.CLIENT
  • P_JP_INVCSUMMARYHIERARCH.[column in domain "NRSOBJ"] == NRIV.SUBOBJECT
Virtual Account Number
  • Bank Keys
  • Client
  • Virtual Account Number
  • Country/Region Key of Bank