/SMB/BBPR_I

Transparent Table System Table (SAP only)

Building Block Project Items

/SMB/BBPR_I is an SAP database table in S/4HANA. Building Block Project Items. It contains 26 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
/cfg/cds_Solution view left_outer CDS view for Solution with Parameters
/CFG/V_FILE_SOL_MIN_SEQ_VIEW view inner Determine the first scope item where BB occurs
/CFG/V_HASH_DAO view left_outer CDS View for Hashing DAO
/FTI/SI_TOP_SEQ view inner FineTuning UIs for custom services
/fti/v_All_Files_In_Solu_Tasks view left_outer Get all filenames of a specific solution according to task
/FTI/V_EXT_MAINT_SRV_VIEW view left_outer
/FTI/V_FILE_SOL_MIN_SEQ_VIEW view inner Determine first scope item where a building block occurs in solution
/FTI/V_FILE_SOLID_VIEW view left_outer
/smb/cds_analyze_sol view left_outer CDS view for Solution with Parameters
/SMB/CDS_CCF_SOLDATA view left_outer CDS view for ccf framework
/SMB/CDS_SOL_DATA view left_outer Get solution BBid,subobjectsa andactivities
/SMB/CDS_SOL_DT_S view left_outer Get solution BBid,subobjectsa andactivities
/smb/cds_Solution view left_outer CDS view for Solution with Parameters

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prjid /SMB/PRJID Scope Item
KEY bbidx /SMB/INDEX Index
KEY objidx /SMB/INDEX Index
bbid /SMB/BBID Building Block
seqnum /SMB/SEQNUM Sequential Number
objty /SMB/PRJ_OBJTY Prj. Obj. Type
objid /SMB/OBJID Object ID
objdesc /SMB/OBJDESCR Description
interact /SMB/BPIA_E_INTERACT Foregrnd Actvty
mandat /SMB/BPIA_E_MANDAT Mandatory Indicator
status /SMB/STATUS Activated Status
alt_status /SMB/STATUS Activated Status
rescmp CHAR1 Single-Character Flag
logid_a /SMB/INDEX Index
ecatt_log ETLOG_ID Procedure No.
parent /SMB/PARENT Parent
instruction_id DOKU_OBJ Object
doc_id /SMB/BP_EDT11 Filename
doc_popup /SMB/BPIA_E_DOC_POPUP Popup Doc
tcode /SMB/BP_EDT12 Tcode, IMG Activity, Report or Fiori
stop_pt /SMB/BPIA_E_STOP_PT Stop point
demo /SMB/BPIA_E_DEMO Demo data
order_number /SMB/DT_ORDER_NUMBER Order Number
abap_log /SMB/ABAP_LOG_ID Log Handle
img_expert_mode /SMB/DE_EXPERT_MODE Unchecked write

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Building Block Project Items
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SMB/BBPR_I (
    MANDT,            -- Client [MANDT]
    PRJID,            -- Scope Item [/SMB/PRJID]
    BBIDX,            -- Index [/SMB/INDEX]
    OBJIDX,           -- Index [/SMB/INDEX]
    BBID,             -- Building Block [/SMB/BBID]
    SEQNUM,           -- Sequential Number [/SMB/SEQNUM]
    OBJTY,            -- Prj. Obj. Type [/SMB/PRJ_OBJTY]
    OBJID,            -- Object ID [/SMB/OBJID]
    OBJDESC,          -- Description [/SMB/OBJDESCR]
    INTERACT,         -- Foregrnd Actvty [/SMB/BPIA_E_INTERACT]
    MANDAT,           -- Mandatory Indicator [/SMB/BPIA_E_MANDAT]
    STATUS,           -- Activated Status [/SMB/STATUS]
    ALT_STATUS,       -- Activated Status [/SMB/STATUS]
    RESCMP,           -- Single-Character Flag [CHAR1]
    LOGID_A,          -- Index [/SMB/INDEX]
    ECATT_LOG,        -- Procedure No. [ETLOG_ID]
    PARENT,           -- Parent [/SMB/PARENT]
    INSTRUCTION_ID,   -- Object [DOKU_OBJ]
    DOC_ID,           -- Filename [/SMB/BP_EDT11]
    DOC_POPUP,        -- Popup Doc [/SMB/BPIA_E_DOC_POPUP]
    TCODE,            -- Tcode, IMG Activity, Report or Fiori [/SMB/BP_EDT12]
    STOP_PT,          -- Stop point [/SMB/BPIA_E_STOP_PT]
    DEMO,             -- Demo data [/SMB/BPIA_E_DEMO]
    ORDER_NUMBER,     -- Order Number [/SMB/DT_ORDER_NUMBER]
    ABAP_LOG,         -- Log Handle [/SMB/ABAP_LOG_ID]
    IMG_EXPERT_MODE,  -- Unchecked write [/SMB/DE_EXPERT_MODE]
    PRIMARY KEY (MANDT, PRJID, BBIDX, OBJIDX)
);