/SMB/BB_LIB_H
Building Block Library Header
/SMB/BB_LIB_H is an SAP database table in S/4HANA. Building Block Library Header. It contains 24 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SMB/I_BB_BAC_ELEMENT | view_entity | inner | BB BAC Element Assignment | |
| /SMB/I_BBV_W_SEQUENCE | view_entity | from | Building Block Version with Sequence | |
| /SMB/V_BBID_TDC_DET | view_entity | from | TDC Determination for BBID | |
| /SMB/V_BBID_TDC_DET | view_entity | union | TDC Determination for BBID | |
| /SMB/V_FILE_DEF_ADMIN_DATA | view_entity | from | File Definition Admin Data | |
| /SMB/V_FILE_DEF_ADMIN_DATA | view_entity | union | File Definition Admin Data |
Fields (24)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bbid | /SMB/BBID | Building Block | |||
| cnam | CNAM | Created By | ||||
| cdat | /SMB/CDATE | Activated Date | ||||
| unam | UNAME | User Name | ||||
| udat | /SMB/UDATE | Updated Date | ||||
| minrelease | SAPRELEASE | SAP Release | ||||
| maxrelease | SAPRELEASE | SAP Release | ||||
| doc_id | /SMB/DOCUMENTATION_ID | Document Name | ||||
| acts | /SMB/BPIA_E_ACT | BB Act | ||||
| sysdata | /SMB/BP_EDT05 | Target Sys | ||||
| testsystem | /SMB/BP_EDT06 | Target System | ||||
| version | /SMB/ARC_VERSION | BB version | ||||
| sir_integrated | /SMB/DE_SIR_INTEGRATION_STATUS | Integrated | ||||
| sir_bb_id | /SMB/DE_SIR_BB_ID | Building Block (SIR) | ||||
| sir_bb_country | /SMB/DE_SIR_COUNTRY | Country/Region | ||||
| sir_bb_prod_vers | /SMB/DE_SIR_PROD_VERS | SAP product version | ||||
| sir_bb_prod_v_ob | /SMB/DE_SIR_PPMS_OBJ_NUMBER | Object number | ||||
| sir_prod_alias | /SMB/DE_SIR_PROD_ALIAS | Product alias | ||||
| sir_prod_vers_al | /SMB/DE_SIR_PROD_VERS_ALIAS | Prod versn alias | ||||
| solman_id | GUID_22 | GUID 22 | ||||
| application_component | UFPS_POSID | Applic. Component | ||||
| feature_toggle | FTG_ID | Feature Toggle ID | ||||
| deploy_with | /SMB/DE_BB_DEPLOY_WITH | Deploy with |
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 Header
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SMB/BB_LIB_H (
MANDT, -- Client [MANDT]
BBID, -- Building Block [/SMB/BBID]
CNAM, -- Created By [CNAM]
CDAT, -- Activated Date [/SMB/CDATE]
UNAM, -- User Name [UNAME]
UDAT, -- Updated Date [/SMB/UDATE]
MINRELEASE, -- SAP Release [SAPRELEASE]
MAXRELEASE, -- SAP Release [SAPRELEASE]
DOC_ID, -- Document Name [/SMB/DOCUMENTATION_ID]
ACTS, -- BB Act [/SMB/BPIA_E_ACT]
SYSDATA, -- Target Sys [/SMB/BP_EDT05]
TESTSYSTEM, -- Target System [/SMB/BP_EDT06]
VERSION, -- BB version [/SMB/ARC_VERSION]
SIR_INTEGRATED, -- Integrated [/SMB/DE_SIR_INTEGRATION_STATUS]
SIR_BB_ID, -- Building Block (SIR) [/SMB/DE_SIR_BB_ID]
SIR_BB_COUNTRY, -- Country/Region [/SMB/DE_SIR_COUNTRY]
SIR_BB_PROD_VERS, -- SAP product version [/SMB/DE_SIR_PROD_VERS]
SIR_BB_PROD_V_OB, -- Object number [/SMB/DE_SIR_PPMS_OBJ_NUMBER]
SIR_PROD_ALIAS, -- Product alias [/SMB/DE_SIR_PROD_ALIAS]
SIR_PROD_VERS_AL, -- Prod versn alias [/SMB/DE_SIR_PROD_VERS_ALIAS]
SOLMAN_ID, -- GUID 22 [GUID_22]
APPLICATION_COMPONENT, -- Applic. Component [UFPS_POSID]
FEATURE_TOGGLE, -- Feature Toggle ID [FTG_ID]
DEPLOY_WITH, -- Deploy with [/SMB/DE_BB_DEPLOY_WITH]
PRIMARY KEY (MANDT, BBID)
);
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