IHC_DB_NEW_TRAPO

IHC: Customizing-Table for Posting Detail Report | #other | Component: FSCM In-House Cash
Column Name Description
MANDT FK Client
BUKRS FK Company Code
VBUND FK Company ID of Trading Partner
SHKONT FK General Ledger Account
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Foriegn key for company code
  • IHC_DB_NEW_TRAPO.MANDT == T001.MANDT
  • IHC_DB_NEW_TRAPO.BUKRS == T001.BUKRS
Foriegn Key for Posting Key for Credit posting
  • IHC_DB_NEW_TRAPO.MANDT == TBSL.MANDT
  • IHC_DB_NEW_TRAPO.HBSCHL_THKONT == TBSL.BSCHL
Foriegn key for Customer Account
  • IHC_DB_NEW_TRAPO.MANDT == KNA1.MANDT
  • IHC_DB_NEW_TRAPO.KUNNR == KNA1.KUNNR
Foriegn key for Vendor account
  • IHC_DB_NEW_TRAPO.MANDT == LFA1.MANDT
  • IHC_DB_NEW_TRAPO.LIFNR == LFA1.LIFNR
Foriegn key for Client IHC_DB_NEW_TRAPO.MANDT == T000.MANDT
Foriegn key for Posting key for Debit posting
  • IHC_DB_NEW_TRAPO.MANDT == TBSL.MANDT
  • IHC_DB_NEW_TRAPO.SBSCHL_THKONT == TBSL.BSCHL
Foriegn key for G/L Account
  • ?
  • Client
  • General Ledger Account
  • IHC_DB_NEW_TRAPO.[column in domain "KTOPL"] == SKA1.KTOPL
  • IHC_DB_NEW_TRAPO.MANDT == SKA1.MANDT
  • IHC_DB_NEW_TRAPO.SHKONT == SKA1.SAKNR
Foriegn key for G/L AP or AR account
  • ?
  • Client
  • General Ledger Account
  • IHC_DB_NEW_TRAPO.[column in domain "KTOPL"] == SKA1.KTOPL
  • IHC_DB_NEW_TRAPO.MANDT == SKA1.MANDT
  • IHC_DB_NEW_TRAPO.THKONT == SKA1.SAKNR
Foriegn key for Trading Partner
  • IHC_DB_NEW_TRAPO.MANDT == T880.MANDT
  • IHC_DB_NEW_TRAPO.VBUND == T880.RCOMP