SAP Table TBPBWRET00

Transfer: BW Query FM

TBPBWRET00 (Transfer: BW Query FM) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TBPBWRET00 to other SAP tables.

TBPBWRET00 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
QUERY BW Query FMBP_QUERY CHAR 72 0
BW_SYS BW System FMBP_RFCDEST RFCDES CHAR 32 0
BCS Is BCS Active? FMBP_BCS_ACTIVE CHAR 1 0
X Yes
NULL No
DERIVATION Account Assignment Derivation for Plan Data Transfer FMBP_KIND_OF_DERIVATION CHAR 2 0
00 No Derivation
01 Derivation (Commitment/Actual)
02 Derivation (Budget Planning)
CONVERSION_DATE Conversion Date for Currency Field FMBP_CONVERSION_DATE CHAR 2 0
00 No Conversion
01 Conversion on Document Date
02 Conversion on Posting Date
03 Conversion on First Day of Fiscal Year
SIGN_CONVENTION Attributes for BCS sign convention FMCU_SIGN_CONVENTION CHAR 1 0
NULL UI sign convention (user Interface)
D DB sign convention (DataBase)
N No conversion
I Invert sign

TBPBWRET00 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TBPBWRET00 BW_SYS TBPBWRET00 BW_SYS RFCDES Destination table for Remote Function Call RFCDEST
TBPBWRET00 MANDT TBPBWRET00 MANDT T000 Clients MANDT