/SMB/BBPR_I
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA