CMS_AST_BP SAP table for – Asset -Business Partner Relationship

Here we would like to draw your attention to CMS_AST_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_AST_BP is a SAP standard transp table used for storing Asset -Business Partner Relationship related data in SAP. It comes under the package CMS_CORE.

SAP CMS_AST_BP table

Table CMS_AST_BP technical data

TableCMS_AST_BP
Data storingAsset -Business Partner Relationship
ModuleFS
Sub ModuleFS-CMS-MD
SAP PackageCMS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_AST_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_AST_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 CMS_AST_BP
    Its a key field.
  • AST_BP_GUID : GUID for Table CMS_AST_BP
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Link to CMS_AST Table
  • AST_GUID : GUID for Table CMS_AST
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Structure for Asset business partner detail
  • BU_PARTNERID : 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
  • AST_SHARE_NR : Numerator in Business Partner Share of Asset
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • AST_SHARE_DN : Denominator in the Business Partner Share of Asset
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • VALD_FRM : Valid from Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALD_TLL : Valid to Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32