TKKAZ
Zuordungstabelle für die Auftragsabgrenzung
TKKAZ is an SAP database table in S/4HANA. Zuordungstabelle für die Auftragsabgrenzung. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| kkag_tkkaz0 | view | left_outer | TKKAZ Step 0 |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | kokrs | kokrs | CO Area | |||
| KEY | versa | versn_abgr | RA Version | |||
| KEY | abgsl | abgr_schl | RA Key | |||
| KEY | koamk | kstar_mask | Cost Element | |||
| KEY | krkmk | kokrs_mask | Material Origin | |||
| KEY | kstmk | kostl_mask | Cost Center | |||
| KEY | larmk | lstar_mask | Activity Type | |||
| KEY | przmk | prznr_mask | BusinessProcess | |||
| KEY | bekmk | beknz_mask | Debit/CreditInd | |||
| KEY | vfkmk | va_fi_mask | Vble/Fixed Ind. | |||
| KEY | kyrs1 | kka_costyp | Apport. Reason | |||
| KEY | kyrs2 | reserv_flg | Reserved | |||
| KEY | kyrs3 | reserv_flg | Reserved | |||
| KEY | bemmk | kka_bemot | AcctIndicator | |||
| KEY | zglab | kkaper_inv | Valid-From Per. | |||
| zidap | dzlnid_ap | LID Reqmnt to Cap. | ||||
| zidaw | dzlnid_aw | LID Option to Cap. | ||||
| zidnf | dzlnid_naf | LID Prohib. to Cap. | ||||
| awrpz | aw_prz | Opt. to Cap. % | ||||
| nafpz | naf_prz | PC % |
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.
-- Zuordungstabelle für die Auftragsabgrenzung
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TKKAZ (
MANDT, -- Client [mandt]
KOKRS, -- CO Area [kokrs]
VERSA, -- RA Version [versn_abgr]
ABGSL, -- RA Key [abgr_schl]
KOAMK, -- Cost Element [kstar_mask]
KRKMK, -- Material Origin [kokrs_mask]
KSTMK, -- Cost Center [kostl_mask]
LARMK, -- Activity Type [lstar_mask]
PRZMK, -- BusinessProcess [prznr_mask]
BEKMK, -- Debit/CreditInd [beknz_mask]
VFKMK, -- Vble/Fixed Ind. [va_fi_mask]
KYRS1, -- Apport. Reason [kka_costyp]
KYRS2, -- Reserved [reserv_flg]
KYRS3, -- Reserved [reserv_flg]
BEMMK, -- AcctIndicator [kka_bemot]
ZGLAB, -- Valid-From Per. [kkaper_inv]
ZIDAP, -- LID Reqmnt to Cap. [dzlnid_ap]
ZIDAW, -- LID Option to Cap. [dzlnid_aw]
ZIDNF, -- LID Prohib. to Cap. [dzlnid_naf]
AWRPZ, -- Opt. to Cap. % [aw_prz]
NAFPZ, -- PC % [naf_prz]
PRIMARY KEY (MANDT, KOKRS, VERSA, ABGSL, KOAMK, KRKMK, KSTMK, LARMK, PRZMK, BEKMK, VFKMK, KYRS1, KYRS2, KYRS3, BEMMK, ZGLAB)
);
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