TKB1A
Settlement Profile
TKB1A is an SAP database table in S/4HANA. Settlement Profile. 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.
-- Settlement Profile
-- 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