TKB1A
Abrechnungsprofil
TKB1A is an SAP database table in S/4HANA. Abrechnungsprofil. It contains 44 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ControllingSettlementProfile | view_entity | from | BASIC | Controlling Settlement Profile |
| I_EAMSettlementProfile | view | from | BASIC | Settlement Profile |
Fields (44)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | aprof | aprof | Settlmt Profile | |||
| preis | abrpreis | CComponent Str. | ||||
| epupd | abrepupd | Origin | ||||
| hproz | hproz | 100%-Validation | ||||
| maxbr | abrmaxbr | Max.No.Dist.Rls | ||||
| betra | abrbetra | Amt Settlement | ||||
| menge | abrmenge | Qty Settlement | ||||
| proze | abrproze | %-Settlement | ||||
| aqzif | abraqzif | Eq.Numbers | ||||
| absch | abrabsch | Alloc.Structure | ||||
| ursch | abrursch | Source Struct. | ||||
| kovor | abrkovor | DefObject Type | ||||
| absak | absak | G/L Account | ||||
| abkst | abkst | Cost Center | ||||
| abauf | abauf | Order | ||||
| abpro | abpro | WBS Element | ||||
| abanl | abanl | Fixed Asset | ||||
| abmat | abmat | Material | ||||
| abnvg | abnvg | Network | ||||
| abbob | abbob | Profit. Segment | ||||
| abprc | abprc | Sales Order | ||||
| abimm | abimm | Real Est. Obj. | ||||
| blart | abrblart | Document Type | ||||
| resau | resau | Residence Time | ||||
| ersch | ersch | PA Trans. Str. | ||||
| rifind | jv_rifind | Der. Rec. Ind | ||||
| fm_derive | ps_derive | Der.Fund/FuncAr | ||||
| hbschl | abrbschlha | CR Posting Key | ||||
| sbschl | abrbschlso | DR Posting Key | ||||
| varia | abrvaria | Variances | ||||
| abktr | abktr | Cost Objects | ||||
| abprz | abprz | Business Proc. | ||||
| abaup | abaup | Order Item | ||||
| abrist | abrist | Actual Csts/COS | ||||
| abrdownpay | abrdownpay | Down Paymnts | ||||
| fm_derive_fonds | ps_derive_fonds | Derive Funds | ||||
| fm_derive_fkber | ps_derive_fkber | Derive Func.Ar | ||||
| fm_derive_grant | ps_derive_grant | Derive Grant | ||||
| addcurr | abr_addcurr | Currencies/Ldgs | ||||
| ledger_dist_rules | abr_ledger_dist_rules | Ldgr Rules | ||||
| no_src_ce | kepsl_no_source_costelement | Summ. Srce Cst Elmnt | ||||
| absvo | absvo | Service Order | ||||
| absvc | absvc | Service Contr. |
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.
-- Abrechnungsprofil
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TKB1A (
MANDT, -- Client [mandt]
APROF, -- Settlmt Profile [aprof]
PREIS, -- CComponent Str. [abrpreis]
EPUPD, -- Origin [abrepupd]
HPROZ, -- 100%-Validation [hproz]
MAXBR, -- Max.No.Dist.Rls [abrmaxbr]
BETRA, -- Amt Settlement [abrbetra]
MENGE, -- Qty Settlement [abrmenge]
PROZE, -- %-Settlement [abrproze]
AQZIF, -- Eq.Numbers [abraqzif]
ABSCH, -- Alloc.Structure [abrabsch]
URSCH, -- Source Struct. [abrursch]
KOVOR, -- DefObject Type [abrkovor]
ABSAK, -- G/L Account [absak]
ABKST, -- Cost Center [abkst]
ABAUF, -- Order [abauf]
ABPRO, -- WBS Element [abpro]
ABANL, -- Fixed Asset [abanl]
ABMAT, -- Material [abmat]
ABNVG, -- Network [abnvg]
ABBOB, -- Profit. Segment [abbob]
ABPRC, -- Sales Order [abprc]
ABIMM, -- Real Est. Obj. [abimm]
BLART, -- Document Type [abrblart]
RESAU, -- Residence Time [resau]
ERSCH, -- PA Trans. Str. [ersch]
RIFIND, -- Der. Rec. Ind [jv_rifind]
FM_DERIVE, -- Der.Fund/FuncAr [ps_derive]
HBSCHL, -- CR Posting Key [abrbschlha]
SBSCHL, -- DR Posting Key [abrbschlso]
VARIA, -- Variances [abrvaria]
ABKTR, -- Cost Objects [abktr]
ABPRZ, -- Business Proc. [abprz]
ABAUP, -- Order Item [abaup]
ABRIST, -- Actual Csts/COS [abrist]
ABRDOWNPAY, -- Down Paymnts [abrdownpay]
FM_DERIVE_FONDS, -- Derive Funds [ps_derive_fonds]
FM_DERIVE_FKBER, -- Derive Func.Ar [ps_derive_fkber]
FM_DERIVE_GRANT, -- Derive Grant [ps_derive_grant]
ADDCURR, -- Currencies/Ldgs [abr_addcurr]
LEDGER_DIST_RULES, -- Ldgr Rules [abr_ledger_dist_rules]
NO_SRC_CE, -- Summ. Srce Cst Elmnt [kepsl_no_source_costelement]
ABSVO, -- Service Order [absvo]
ABSVC, -- Service Contr. [absvc]
PRIMARY KEY (MANDT, APROF)
);
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