T000

Transparent Table Customizing Table
17 Fields 98 CDS Views

Clients

T000 is an SAP database table in S/4HANA. Clients. It contains 17 fields. 98 CDS views read from this table.

CDS Views using this table (98)

ViewTypeJoinVDMDescription
/SAPAPO/SYPP_Location_material view inner Synchronized Production Planning Location Material
/SSB/SAPCLIENT view from SAPCLient for Smart Business
ATOV_SETTINGS view from ATO Settings
ATOV_TENANT_INFO view from ATO: Tenant Info
CBC_STA_SRC_C view_entity from
DEMO_CDS_CLIENT_HANDLING view_entity from CDS View entity_client handling
demo_cds_cross_join view from
DEMO_CDS_CROSS_JOIN_VE view_entity from CDS view entity with a cross join
FCLM_BSEG_ACTIVE_LIST view inner Active Company Code List of FI
Fclm_Mm_Active_List view inner Active Company Code List of MM
Fclm_Sd_Active_List view inner Active Company Code List of SD
fco_abr_bel_04_a view inner Settlement actual costs
fco_abr_bel_12_a view inner Settlement down payments per ledger
fco_abr_bel_ld_a view inner Settlement actual costs per ledger
fco_abr_bel04_a view inner Settlement actual costs w. additional currencies
FCO_MIG_ACDOCA view inner CO Delta Entries - Aggregated ACDOCA Records
FCO_MIG_COEP view inner CO Delta Entries - Line Items after sFIN 1.0 (src. COEP)
FCO_MIG_COEP11 view inner CO Delta Entries - Statistical Line Items
fco_ovhd_cost_acdoca view_entity inner Overhead costs from acdoca
fco_ovhd_cost_co_values1 view_entity inner Overhead costs from acdoca to fields for CO-Version
fco_ovhd_cost_co_values1_l view_entity inner Overhead costs from acdoca to fields for CO-Version
Fins_acdoca_lines_base view inner Base view for number of document items
Fins_Rev_Rec_Acdoca_Balance view inner Acdoca balance for introducing a new accounting principle
Fins_Rev_Rec_Acdoca_View view inner View on ACDOCA
FINS_REV_REC_COS_ACT_DIST_REF view inner Distinct AWREF for data with CO objects
FINS_REV_REC_COS_ACT_VIEWA_BAS view inner Actuals for data with CO objects
FINS_REV_REC_COS_ACTUAL_VIEWMT view inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW_BAS view inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW1_BAS view inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW1A_BAS view inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW2_BAS view inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW3_BAS view inner Actuals for data with CO objects
FINS_REV_REC_COSACT_VIEW4_BAS view inner Actuals for data with CO objects
FINS_REV_REC_TOTAL_REVENUE view inner Total revenue
Fins_Rev_Rec_uprctr_View view inner pernr - origin prctr
fiscds_bukcurr view left_outer Currencies of Company Code
fiscds_ldcmpcurr view inner Currencies of Company Code and Ledger
FISVD_EXTERNALTAX_UNIONTID view left_outer TAX EXPOSTING MANAGE
I_BusSolnOrdNetworkGraphAttrib view from BASIC Solution Order Network Graph: Attribute
I_BusSolnOrdNetworkGraphGroup view from BASIC Solution Order Network Graph: Group
I_BusSolnOrdNetworkGraphLine view from BASIC Solution Order Network Graph: Line
I_BusSolnOrdNetworkGraphNode view from BASIC Solution Order Network Graph: Node
I_CnsldtnGlobalParameter view from BASIC Consolidation Global Parameter
I_Creditmanagement_Single_Vec view inner BASIC Credit Management Single Vector
I_SAPClient view from BASIC SAP Client
I_SCMBusinessSystemGroup view from BASIC Business system group and corresponding logical system
Kkag_Acdoca_View view inner Acdoca View
Kkag_Acdoca1_View view inner ACDOCA view cost element assignment only
Kkag_Cos_Item_View view inner Itemized view for RA relevant input data
KSR_I_XM_DUMMY_TENANT_R view from KSR: Cross Tenant Dummy
MDCV_E_T000MD view from Compatibility View T000MD
P_CC_DefaultGlobalParameter view from BASIC
P_FinancialStatementLeafItem view left_outer BASIC
P_FinancialStatementLeafItemT view left_outer BASIC
p_islm2_mdlctx view_entity cross Modeling Contexts (client-dep. & system)
P_Ldcmpcurr view inner BASIC
P_RTPCOrderActlCostForSttlLd view inner BASIC
P_RTPCOrderSettCostForRevLd view inner BASIC
RS_P_ANA_UMM2_MDLCTX view cross Modeling Contexts (client-dep. & system)
RSAU_GET_AR view inner Security Audit Log - Get Access Rule
SWF_SDM_STATE_HELPER_DUMMY view from SDM State in table SWF_SDM_STAT_HLP
SWF_SDM_SWWCUSTOM_DUMMY view from Workflow: SDM state for SWWCUSTOM dummy
UPOV_PR_RESZN_UOM view left_outer UOM: Reservoir Zone Identification
UPOV_PR_WCVD_UOM view left_outer UOM: Well Completion Variable Data UOM
UPOV_RESERVOIR_UOM view left_outer UOM: Reservoir
v_coepext_acdoca_view view inner Mapping from ACDOCA to COEP_EXT
V_Cosp_3_Ddl_Age_view view inner Cold Data: Primary Actuals from ACDOCA per period
v_cosp_3_view view inner CO Object: Cost Totals for External Postings (part 3)
V_Cosp_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (primary)
v_cosp_d2_coep_view view inner COSP Difference from Migration as COEP - BSTAT=C
V_COSP_KSII_1_VIEW view inner COSP for TA KSII, WRTTP=04 only - 1
V_COSP_LVP_1_VIEW view inner COSP totals: all currencies/valuations - 1
v_cosp_ori_4_view view inner CO Object: Cost Totals for External Postings (part 4)
v_cosp_ori_6_view view inner CO Object: Cost Totals for External Postings (part 6)
V_COSP_PER_1_VIEW view inner COSP totals: all currencies/valuations - 1
V_Cosp_R_3s_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part3s
V_Cosp_R_8_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part 8
v_cosp_wdv_1_view view inner COSP with delta versions (parallel valuation/COGM) - part 1
V_Coss_3_Ddl_Age_view view inner Cold Data: Actuals from ACDOCA per period
v_coss_3_view view inner CO Object: Cost Totals for Internal Postings (part 3)
V_Coss_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (secondary)
v_coss_d2_coep_view view inner COSS Difference from Migration as COEP - BSTAT=C
V_COSS_KSII_1_VIEW view inner COSS for TA KSII, WRTTP=04 only - 1
V_COSS_LVP_1_VIEW view inner COSS totals: all currencies/valuations - 1
v_coss_ori_4_view view inner CO Object: Cost Totals for Internal Postings (part 4)
v_coss_ori_6_view view inner CO Object: Cost Totals for Internal Postings (part 6)
V_COSS_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_Coss_R_3s_View view inner CO Object: Cost Totals for Internal Postings ("Rev.") Part3s
V_Coss_R_8_View view inner CO Object: Cost Totals for Internal Postings ("Rev.") Part 8
V_COSS_W11_1_VIEW view inner COSS for WRTTP=11 only - part 1
v_coss_wdv_1_view view inner COSS with delta versions (parallel valuation/COGM) - part 1
V_COSS_X_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_COSS4W09_1_VIEW view inner COSS for WRTTP=09 - part 1
V_COSX_ACDOCA_VIEW view inner COSP/COSS data on ACDOCA wo delta logic
V_COSX_LVP_1_VIEW view inner COSx totals: all currencies/valuations - 1
v_cosx_wof_1_view view inner calculation WOF value for COSP/COSS on ACDOCA basis - part 1
v_ukm_single_vector view inner Payment Behavior Summary
VDM_SAP_CLIENT view from SAPClient for VDM View Browser

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
mtext mtext_d Name
ort01 ort01 City
mwaer mwaer Currency
adrnr char10 Character Field with Length 10
cccategory cccategory Role
cccoractiv cccoractiv Transp. connection
ccnocliind ccnocliind No cross-client
cccopylock cccopylock Copy protection
ccnocascad ccnocascad No SAP upgrade
ccsoftlock ccsoftlock Lock Method
ccorigcont ccorigcont Create Switch BC Sets
ccimaildis ccimaildis CATT Allowed
cctemplock cctemplock Temporarily locked
changeuser as4user Last Changed By
changedate as4date Date
logsys logsys Logical system

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.

-- Clients
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T000 (
    MANDT,       -- Client [mandt]
    MTEXT,       -- Name [mtext_d]
    ORT01,       -- City [ort01]
    MWAER,       -- Currency [mwaer]
    ADRNR,       -- Character Field with Length 10 [char10]
    CCCATEGORY,  -- Role [cccategory]
    CCCORACTIV,  -- Transp. connection [cccoractiv]
    CCNOCLIIND,  -- No cross-client [ccnocliind]
    CCCOPYLOCK,  -- Copy protection [cccopylock]
    CCNOCASCAD,  -- No SAP upgrade [ccnocascad]
    CCSOFTLOCK,  -- Lock Method [ccsoftlock]
    CCORIGCONT,  -- Create Switch BC Sets [ccorigcont]
    CCIMAILDIS,  -- CATT Allowed [ccimaildis]
    CCTEMPLOCK,  -- Temporarily locked [cctemplock]
    CHANGEUSER,  -- Last Changed By [as4user]
    CHANGEDATE,  -- Date [as4date]
    LOGSYS,      -- Logical system [logsys]
    PRIMARY KEY (MANDT)
);

Learn More