P_CASHPOOLASSIGNMENTHIERARCHY

Cash Pool Assignment Hierarchy | view: P_CPLASSGMTHIER | Extraction: Not supported | Component: SAP Cash Management
Column Name Description
CshPoolAssgmtHierNode Cash Pool Assignment ID
Column Name Description
Column Name Description
Column Name Description
CashPoolAssgmtValdtyStrtDte Validity Start Date
CashPoolAssgmtValdtyEndDte Validity End Date
Column Name Description
CashPoolAssgmtIsHeadBkAcct Is Bank Account Assigned as Header Account Show values
CashPoolAssgmtIsDeleted Marked for Deletion Show values
ParCshPoolAssgmtIsHeadBkAcct Is Bank Account Assigned as Header Account Show values
Column Name Description Domain name
CashPool Cash Pool Name FCLM_CPL_NAME
CashPoolAssignment Cash Pool Assignment ID FCLM_CPL_ASSGN_ID
CashPoolAssignmentText Text of Cash Pool Assignment TEXT60
BankAccountInternalID Bank Account Technical ID NUM10
CashPoolCreatedByUser Cash Pool Created By XUBNAME
CashPoolLastChangedByUser Cash Pool Changed By XUBNAME
CashPoolCreationDateTime Cash Pool Created At TZNTSTMPL
CashPoolLastChangeDateTime Cash Pool Changed At TZNTSTMPL
BankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
BankAccountDescription Account Description TEXT60
CshPoolAssgmtHierParNode null
CshPoolAssgmtHierNodeTxt Text of Cash Pool Assignment TEXT60
CrsCshPoolSubAcctHierNode Cash Pool Assignment ID FCLM_CPL_ASSGN_ID
CrsCshPoolHdrAcctHierNode Cash Pool Assignment ID FCLM_CPL_ASSGN_ID
IdenticalCshPoolParNode Cash Pool Assignment ID FCLM_CPL_ASSGN_ID
IdenticalCshPoolGrandParNode Cash Pool Assignment ID FCLM_CPL_ASSGN_ID
ParentCashPool Cash Pool Name FCLM_CPL_NAME
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_CASHPOOLASSIGNMENTHIERARCHY.MANDT == TCURC.MANDT
  • P_CASHPOOLASSIGNMENTHIERARCHY.BANKACCOUNTCURRENCY == TCURC.WAERS
Bank Country/Region Key
  • Client
  • Bank Country/Region Key
  • P_CASHPOOLASSIGNMENTHIERARCHY.MANDT == T005.MANDT
  • P_CASHPOOLASSIGNMENTHIERARCHY.BANKCOUNTRY == T005.LAND1
Company Code
  • Client
  • Company Code
  • P_CASHPOOLASSIGNMENTHIERARCHY.MANDT == T001.MANDT
  • P_CASHPOOLASSIGNMENTHIERARCHY.COMPANYCODE == T001.BUKRS