T093C

Transparent Table Customizing Table
32 Fields 21 CDS Views

Company codes in Asset Accounting

T093C is an SAP database table in S/4HANA. Company codes in Asset Accounting. It contains 32 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
FAA_MIG_ANEP view inner Join ANEP with ANEK plus add. Field AWKEY
FAA_MIG_ANLC view inner Get ANLC for migration in ACDOCA and FAAT_DOC_IT
faa_mig_anlp view union_all ANLP with parallel currency areas
faa_mig_anlp_main view from Test ANLP
Faa_Rc1_Anep view from Parallel areas without leading area
Faa_Rc1_Anlc_Base view from Subtract planed values against posted values (Base View)
Faa_Rc1_Anlc_Base view union_all Subtract planed values against posted values (Base View)
FAA_RC5_ANLC_NB view from Reconciliation ANLC Non Posting Areas (Base View) RC5
FAA_RC5_ANLC_NB view union_all Reconciliation ANLC Non Posting Areas (Base View) RC5
FAA_REC_ANLC_BASE view inner Reconciliation ANLC (Base View)
FAA_REC_ANLC_BRC5 view union_all Reconciliation ANLC (Base View) RC5
FAA_REC_ANLC_BRC5 view from Reconciliation ANLC (Base View) RC5
Faa_Rec_Anlp_Base view from Reconciliation ANLP (Base View)
Faa_Rec_Anlp_Base view union_all Reconciliation ANLP (Base View)
Faa_Rec_Anlp1_Sum view inner Reconciliation ANLP vs ANLC (Result Set)
Faa_Sil_Anla_Relevant view inner Relevante Anlagen für Rücksetzen selektieren
faa_sil_Anlb_Deakt view inner Erwartetes Deaktivierungsdatum des Zielber. beim Rücksetzen
Faa_Sil_Doc view inner Belege, die über FI-AA nachgebucht werden
P_AssetCompanyCode view from BASIC
P_AssetYearOpngValnAttrib view inner BASIC
P_ChartOfDeprForAcctgPrinciple view from BASIC

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
bukrsn BUKRSN Company Code
periv PERIV FY Variant
monmit MONMIT Start 2nd Half Month
xrumpf XRUMPF Shortened FYear
datum DATE_T093C Transfer Date
afapl AFAPL Chart of Depr.
vrmafb VRMAFB Net Worth Tax
bkrakt BKRAKT Across Co.Codes
xrebuw XREBUW Enter Net BkVal
xanueb XANUEB Status Co.Code
lgjahr LGJAHR Highest F.Year
afblrt AFBLRT DocTyp DepPost
xvrsku XVRSKU Calc.insur.value
mwskzva MWSKZVA Input Tax Exempt
mwskzaa MWSKZAA Output Tax Code - Tax-Exempt
kzrbwb KZRBWB Ind. Post NBV
aprof AM_APROF Settlmt Profile
ttech TTECH Retent.per.
tkund TKUND Retent.per.
xanle IM_XANLE Origin of orig.LI
varbzd VARBZDAT Var. for Val.Date
j_1aaoffcl J_1AAOFFCL Off.Doc.Class
xzorg XZORG Time-Indep.Org.Units
aperblrt APERBLRT DocTyp APC Post
xnoskonto XNOSKONTO No Discount
xdfyv XDFYV Diff. FY Variant
revdmeth REVDMETH Revenue Dist.
ldtblrt LDTBLRT Document Type
ldt_wo_afa LDT_WO_AFAR No Deprec. Calcul.
xlocked FAA_XLOCKED Comp. Code Locked

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.

-- Company codes in Asset Accounting
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T093C (
    MANDT,       -- Client [MANDT]
    BUKRS,       -- Company Code [BUKRS]
    BUKRSN,      -- Company Code [BUKRSN]
    PERIV,       -- FY Variant [PERIV]
    MONMIT,      -- Start 2nd Half Month [MONMIT]
    XRUMPF,      -- Shortened FYear [XRUMPF]
    DATUM,       -- Transfer Date [DATE_T093C]
    AFAPL,       -- Chart of Depr. [AFAPL]
    VRMAFB,      -- Net Worth Tax [VRMAFB]
    BKRAKT,      -- Across Co.Codes [BKRAKT]
    XREBUW,      -- Enter Net BkVal [XREBUW]
    XANUEB,      -- Status Co.Code [XANUEB]
    LGJAHR,      -- Highest F.Year [LGJAHR]
    AFBLRT,      -- DocTyp DepPost [AFBLRT]
    XVRSKU,      -- Calc.insur.value [XVRSKU]
    MWSKZVA,     -- Input Tax Exempt [MWSKZVA]
    MWSKZAA,     -- Output Tax Code - Tax-Exempt [MWSKZAA]
    KZRBWB,      -- Ind. Post NBV [KZRBWB]
    APROF,       -- Settlmt Profile [AM_APROF]
    TTECH,       -- Retent.per. [TTECH]
    TKUND,       -- Retent.per. [TKUND]
    XANLE,       -- Origin of orig.LI [IM_XANLE]
    VARBZD,      -- Var. for Val.Date [VARBZDAT]
    J_1AAOFFCL,  -- Off.Doc.Class [J_1AAOFFCL]
    XZORG,       -- Time-Indep.Org.Units [XZORG]
    APERBLRT,    -- DocTyp APC Post [APERBLRT]
    XNOSKONTO,   -- No Discount [XNOSKONTO]
    XDFYV,       -- Diff. FY Variant [XDFYV]
    REVDMETH,    -- Revenue Dist. [REVDMETH]
    LDTBLRT,     -- Document Type [LDTBLRT]
    LDT_WO_AFA,  -- No Deprec. Calcul. [LDT_WO_AFAR]
    XLOCKED,     -- Comp. Code Locked [FAA_XLOCKED]
    PRIMARY KEY (MANDT, BUKRS)
);

Learn More