CADE_GENERAL

Transparent Table Application Table
34 Fields 3 CDS Views

CADE General Master Table

CADE_GENERAL is an SAP database table in S/4HANA. CADE General Master Table. It contains 34 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CN_CADEGeneralInformation view from BASIC General Master Information for CADE
SHSM_CADE_V_COCODE view from
SHSM_CADE_V_WLCOCODE view left_outer

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY cade_natl_std_rel_ver CADE_NATL_STD_VER Release Version
cade_org_unit_desc CADE_ORG_UNIT_DESC Org. Unit Desc
cade_org_unit CADE_ORG_UNIT Org. Unit Co
cade_indstry_code CADE_INDSTRY_CODE Industry Code
cade_org_unit_cat CADE_ORG_UNIT_CAT Org. Unit Cat.
cade_sw_suplr CADE_SW_SUPLR Software Supplier
waers WAERS Currency
rldnr RLDNR Ledger
cade_sob_code CADE_SOB_CODE Set of Books Code
cade_sob_code_desc CADE_SOB_CODE_DESC Set of Books Desc
cade_report_union CADE_REPORT_UNION Rpt Compiling Unit
cade_report_status CADE_REPORT_STATUS Report Status
cade_depr_area AFABER Deprec. Area
cade_acct_num_rule CADE_ACCT_NUM_RULE G/L Acct Nmbr. Rule
cade_cashflow_num_rule CADE_CASHFLOW_NUM_RULE CashFlowItmNubr.Rule
cade_fxdast_num_rule CADE_FXDAST_NUM_RULE FixedAssetNmbrRule
cade_doc_creator CADE_DOC_CREATOR Jrnl Entr Creator
cade_doc_reviewer CADE_DOC_REVIEWER Jrnl Entr Reviewer
cade_doc_bookeeper CADE_DOC_BOOKEEPER Jrnl Entr Bookkeeper
cade_subsidiary_option CADE_SUBSIDIARY_OPTION Subs. Item Option
cade_config_creator SYUNAME User Name
cade_config_createtime TIMESTAMP Time Stamp
cade_config_updator SYUNAME User Name
cade_config_updatetime TIMESTAMP Time Stamp
cade_config_creator_desc AD_NAMTEXT Full Name
cade_config_updator_desc AD_NAMTEXT Full Name
cade_config_step CADE_CONFIG_STEP Configuration Step
cade_is_cashflow_rptstruc CADE_IS_CASHFLOW_RPTSTRUC Cash Flow Option
fclm_hier_name FCLM_HIER_NAME Hierarchy Name
cade_aa_usage ORDNR Number
cade_aa_bf_status FAA_CONFIG_REDESIGN_1 Config Redesign 1
acc_principle ACCOUNTING_PRINCIPLE Accounting Principle

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.

-- CADE General Master Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CADE_GENERAL (
    MANDT,                      -- Client [MANDT]
    BUKRS,                      -- Company Code [BUKRS]
    CADE_NATL_STD_REL_VER,      -- Release Version [CADE_NATL_STD_VER]
    CADE_ORG_UNIT_DESC,         -- Org. Unit Desc [CADE_ORG_UNIT_DESC]
    CADE_ORG_UNIT,              -- Org. Unit Co [CADE_ORG_UNIT]
    CADE_INDSTRY_CODE,          -- Industry Code [CADE_INDSTRY_CODE]
    CADE_ORG_UNIT_CAT,          -- Org. Unit Cat. [CADE_ORG_UNIT_CAT]
    CADE_SW_SUPLR,              -- Software Supplier [CADE_SW_SUPLR]
    WAERS,                      -- Currency [WAERS]
    RLDNR,                      -- Ledger [RLDNR]
    CADE_SOB_CODE,              -- Set of Books Code [CADE_SOB_CODE]
    CADE_SOB_CODE_DESC,         -- Set of Books Desc [CADE_SOB_CODE_DESC]
    CADE_REPORT_UNION,          -- Rpt Compiling Unit [CADE_REPORT_UNION]
    CADE_REPORT_STATUS,         -- Report Status [CADE_REPORT_STATUS]
    CADE_DEPR_AREA,             -- Deprec. Area [AFABER]
    CADE_ACCT_NUM_RULE,         -- G/L Acct Nmbr. Rule [CADE_ACCT_NUM_RULE]
    CADE_CASHFLOW_NUM_RULE,     -- CashFlowItmNubr.Rule [CADE_CASHFLOW_NUM_RULE]
    CADE_FXDAST_NUM_RULE,       -- FixedAssetNmbrRule [CADE_FXDAST_NUM_RULE]
    CADE_DOC_CREATOR,           -- Jrnl Entr Creator [CADE_DOC_CREATOR]
    CADE_DOC_REVIEWER,          -- Jrnl Entr Reviewer [CADE_DOC_REVIEWER]
    CADE_DOC_BOOKEEPER,         -- Jrnl Entr Bookkeeper [CADE_DOC_BOOKEEPER]
    CADE_SUBSIDIARY_OPTION,     -- Subs. Item Option [CADE_SUBSIDIARY_OPTION]
    CADE_CONFIG_CREATOR,        -- User Name [SYUNAME]
    CADE_CONFIG_CREATETIME,     -- Time Stamp [TIMESTAMP]
    CADE_CONFIG_UPDATOR,        -- User Name [SYUNAME]
    CADE_CONFIG_UPDATETIME,     -- Time Stamp [TIMESTAMP]
    CADE_CONFIG_CREATOR_DESC,   -- Full Name [AD_NAMTEXT]
    CADE_CONFIG_UPDATOR_DESC,   -- Full Name [AD_NAMTEXT]
    CADE_CONFIG_STEP,           -- Configuration Step [CADE_CONFIG_STEP]
    CADE_IS_CASHFLOW_RPTSTRUC,  -- Cash Flow Option [CADE_IS_CASHFLOW_RPTSTRUC]
    FCLM_HIER_NAME,             -- Hierarchy Name [FCLM_HIER_NAME]
    CADE_AA_USAGE,              -- Number [ORDNR]
    CADE_AA_BF_STATUS,          -- Config Redesign 1 [FAA_CONFIG_REDESIGN_1]
    ACC_PRINCIPLE,              -- Accounting Principle [ACCOUNTING_PRINCIPLE]
    PRIMARY KEY (MANDT, BUKRS, CADE_NATL_STD_REL_VER)
);

Learn More