CMS_SEC_ACC_BP SAP table for – Link between securities account and BuPa is stored here

Here we would like to draw your attention to CMS_SEC_ACC_BP table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_SEC_ACC_BP is a SAP standard transp table used for storing Link between securities account and BuPa is stored here related data in SAP. It comes under the package CMS_SEC.

SAP CMS_SEC_ACC_BP table

Table CMS_SEC_ACC_BP technical data

TableCMS_SEC_ACC_BP
Data storingLink between securities account and BuPa is stored here
ModuleFS
Sub ModuleFS-CMS-MD-SEC
SAP PackageCMS_SEC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_SEC_ACC_BP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_SEC_ACC_BP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary key for securities account business partner
    Its a key field.
  • SEC_ACC_BP_GUID : Account Business partner guid
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link structure for the securities account
  • SEC_ACC_GUID : GUID for securities account
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Semantic key for BuPa
  • BUPA_ID : Business Partner Identification Number
    Its data type is CHAR (Character String) with field length 32
  • BPF : Business Partner Function
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Structure for BuPa Ownership details
  • BUPA_SHARE_NR : Numerator in Business Partner Share of Securities Account
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BUPA_SHARE_DR : Denominator in Business Partner Share of Securities Account
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for BP Validity
  • BP_VALID_FROM : Date from which Real Estate Value stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BP_VALID_TO : Date unitl which Real Estate Value stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Structure for history
  • CREATED_BY : Securities Add-On User
    Its data type is CHAR (Character String) with field length 12
  • CREATED_DATE : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CREATED_TIME : Created At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LAST_CHG_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • LAST_CHG_DATE : Last Changed on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHG_TIME : Last Changed At
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6