/SMB/BC_VARIANT
BC-Set Definition Fields
/SMB/BC_VARIANT is an SAP database table in S/4HANA. BC-Set Definition Fields. It contains 27 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /cfg/cds_Solution | view | left_outer | CDS view for Solution with Parameters | |
| /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 |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bcset_id | SCPR_ID | BC Set | |||
| KEY | version | /SMB/VERSION | Version | |||
| KEY | bcset | SCPR_ID | BC Set | |||
| KEY | tablename | SCPR_TABL | Table/View Name | |||
| KEY | fieldname | SCPR_FLD | Field name | |||
| KEY | param | abap.char | ||||
| sel | abap.char | |||||
| recnumber | SCPR_RECNR | Record number | ||||
| dataelem | ROLLNAME | Data Element | ||||
| langu | LANGU | Language | ||||
| langiso | LAISO | Language Code | ||||
| langutext | SPTXT | Name | ||||
| fieldtext | SCPR_FTEXT | Field text | ||||
| outputlen | OUTPUTLEN | Output Length | ||||
| intlen | INTLEN | Internal Length | ||||
| vtype | SCPR_VTYPE | Data type | ||||
| datatype | DATATYPE_D | Data Type | ||||
| decimals | DECIMALS | Decimal Places | ||||
| convexit | CONVEXIT | Convers. Rout. | ||||
| sign | SIGNFLAG | Sign | ||||
| lowercase | LOWERCASE | Case-Sensitive | ||||
| value | SCPR_VALC | Table value | ||||
| oldvalue | SCPR_VALC | Table value | ||||
| variant_name | abap.char | |||||
| variant_num | abap.numc | |||||
| centraldata | /SMB/SBA1_ORG_DESC | Type Description |
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.
-- BC-Set Definition Fields
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SMB/BC_VARIANT (
MANDT, -- Client [MANDT]
BCSET_ID, -- BC Set [SCPR_ID]
VERSION, -- Version [/SMB/VERSION]
BCSET, -- BC Set [SCPR_ID]
TABLENAME, -- Table/View Name [SCPR_TABL]
FIELDNAME, -- Field name [SCPR_FLD]
PARAM, -- abap.char
SEL, -- abap.char
RECNUMBER, -- Record number [SCPR_RECNR]
DATAELEM, -- Data Element [ROLLNAME]
LANGU, -- Language [LANGU]
LANGISO, -- Language Code [LAISO]
LANGUTEXT, -- Name [SPTXT]
FIELDTEXT, -- Field text [SCPR_FTEXT]
OUTPUTLEN, -- Output Length [OUTPUTLEN]
INTLEN, -- Internal Length [INTLEN]
VTYPE, -- Data type [SCPR_VTYPE]
DATATYPE, -- Data Type [DATATYPE_D]
DECIMALS, -- Decimal Places [DECIMALS]
CONVEXIT, -- Convers. Rout. [CONVEXIT]
SIGN, -- Sign [SIGNFLAG]
LOWERCASE, -- Case-Sensitive [LOWERCASE]
VALUE, -- Table value [SCPR_VALC]
OLDVALUE, -- Table value [SCPR_VALC]
VARIANT_NAME, -- abap.char
VARIANT_NUM, -- abap.numc
CENTRALDATA, -- Type Description [/SMB/SBA1_ORG_DESC]
PRIMARY KEY (MANDT, BCSET_ID, VERSION, BCSET, TABLENAME, FIELDNAME, PARAM)
);
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