/SMB/BB_LIB_I
Building Block Library Items
/SMB/BB_LIB_I is an SAP database table in S/4HANA. Building Block Library Items. It contains 24 fields. 22 CDS views read from this table.
CDS Views using this table (22)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /cfg/cds_Solution | view | left_outer | CDS view for Solution with Parameters | |
| /CFG/DDL_EMPTY_FILE_SOLN | view | inner | Empty file web GUIs | |
| /CFG/V_DDL_SOL_FIL_O | view | inner | Get the Files for Old Q2P Registry Details | |
| /CFG/V_DDL_SOL_FILE | view | inner | Get the Files from Registry Details | |
| /CFG/V_FILE_SOL_VIEW | view | inner | Get solution to file | |
| /CFG/V_HASH_DAO | view | left_outer | CDS View for Hashing DAO | |
| /FTI/DDL_EMPTY_FILE_SOLN | view | inner | Check Filename per Solution Id | |
| /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_BCO_PROP_DETAIL_VIEW | view | from | Details of BCO properties | |
| /FTI/V_EXT_MAINT_SRV_VIEW | view | inner | View for external service maintenance | |
| /FTI/V_FILE_SOL_VIEW | view | inner | All files per solution | |
| /FTI/V_FILE_SOLID_VIEW | view | left_outer | view used in /FTI/CL_FLEX_ORG_EXTEND | |
| /FTI/V_PROPERTY_SECONDARY_FILE | view | inner | Secondary files from BCO property | |
| /FTI/V_SOL_FILE_VIEW | view | inner | Check Filename per Solution Id | |
| /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 | |
| /SMB/V_BBID_TDC_DET | view_entity | inner | TDC Determination for BBID | |
| /SMB/V_FILE_DEF_ADMIN_DATA | view_entity | inner | File Definition Admin Data |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | bbid | /smb/bbid | Building Block | |||
| KEY | seqnum | /smb/seqnum | Sequential Number | |||
| objty | /smb/bb_objty | BB Object Type | ||||
| objid | /smb/objid | Object ID | ||||
| filename | /smb/bp_edt11 | Filename | ||||
| interact | /smb/bpia_e_interact | Foregrnd Actvty | ||||
| mandat | /smb/bpia_e_mandat | Mandatory Indicator | ||||
| longtx | flag | Indicator | ||||
| parent | /smb/parent | Parent | ||||
| instruction_id | doku_obj | Object | ||||
| doc_id | /smb/documentation_id | Document Name | ||||
| doc_popup | /smb/bpia_e_doc_popup | Popup Doc | ||||
| tcode | /smb/bp_edt12 | Tcode, IMG Activity, Report or Fiori | ||||
| sysdata | /smb/bp_edt05 | Target Sys | ||||
| testsystem | /smb/target_system | Target System | ||||
| ecat_var | /smb/bp_edt07 | Define ECATT's Variant - internal w/ or w/o default,external | ||||
| demo | /smb/bpia_e_demo | Demo data | ||||
| fieldname | /smb/de_task_id | Task ID | ||||
| altn_objty | char50 | c | ||||
| altn_objid | char70 | Char 70 | ||||
| order_number | /smb/dt_order_number | Order Number | ||||
| img_expert_mode | /smb/de_expert_mode | Unchecked write | ||||
| is_ricode_managed | /smb/de_is_ricode_managed |
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 Library Items
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SMB/BB_LIB_I (
MANDT, -- Client [mandt]
BBID, -- Building Block [/smb/bbid]
SEQNUM, -- Sequential Number [/smb/seqnum]
OBJTY, -- BB Object Type [/smb/bb_objty]
OBJID, -- Object ID [/smb/objid]
FILENAME, -- Filename [/smb/bp_edt11]
INTERACT, -- Foregrnd Actvty [/smb/bpia_e_interact]
MANDAT, -- Mandatory Indicator [/smb/bpia_e_mandat]
LONGTX, -- Indicator [flag]
PARENT, -- Parent [/smb/parent]
INSTRUCTION_ID, -- Object [doku_obj]
DOC_ID, -- Document Name [/smb/documentation_id]
DOC_POPUP, -- Popup Doc [/smb/bpia_e_doc_popup]
TCODE, -- Tcode, IMG Activity, Report or Fiori [/smb/bp_edt12]
SYSDATA, -- Target Sys [/smb/bp_edt05]
TESTSYSTEM, -- Target System [/smb/target_system]
ECAT_VAR, -- Define ECATT's Variant - internal w/ or w/o default,external [/smb/bp_edt07]
DEMO, -- Demo data [/smb/bpia_e_demo]
FIELDNAME, -- Task ID [/smb/de_task_id]
ALTN_OBJTY, -- c [char50]
ALTN_OBJID, -- Char 70 [char70]
ORDER_NUMBER, -- Order Number [/smb/dt_order_number]
IMG_EXPERT_MODE, -- Unchecked write [/smb/de_expert_mode]
IS_RICODE_MANAGED, -- /smb/de_is_ricode_managed
PRIMARY KEY (MANDT, BBID, SEQNUM)
);
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