TBPBWRET00 SAP table for – Transfer: BW Query FM

Here we would like to draw your attention to TBPBWRET00 table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). TBPBWRET00 is a SAP standard transp table used for storing Transfer: BW Query FM related data in SAP. It comes under the package BPREP_BWRET.

SAP TBPBWRET00 table

Table TBPBWRET00 technical data

TableTBPBWRET00
Data storingTransfer: BW Query FM
ModulePSM
Sub ModulePSM-FM
SAP PackageBPREP_BWRET
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-PS
Table CategoryTRANSP

SAP TBPBWRET00 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 TBPBWRET00 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • QUERY : BW Query
    Its a key field. Its data type is CHAR (Character String) with field length 72
  • BW_SYS : BW System
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • BCS : Is BCS Active?
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DERIVATION : Account Assignment Derivation for Plan Data Transfer
    Its data type is CHAR (Character String) with field length 2
  • CONVERSION_DATE : Conversion Date for Currency Field
    Its data type is CHAR (Character String) with field length 2
  • SIGN_CONVENTION : Attributes for BCS sign convention
    Its data type is CHAR (Character String) with field length 1