| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | APROF | Settlement profile | nvarchar | 6 | 0 | CHAR | (N' ') | No | | APROF | Allow NULL? |
| 3 | PREIS | Identifier for "cost component structure" | char | 1 | 0 | CHAR | (N' ') | No | | ABRPREIS | Allow NULL? |
| 4 | EPUPD | "Proof of origin" - Indicator | char | 1 | 0 | CHAR | (N' ') | No | | ABREPUPD | Allow NULL? |
| 5 | HPROZ | Identifier for "100% validation" | char | 1 | 0 | CHAR | (N' ') | No | | HPROZ | Allow NULL? |
| 6 | MAXBR | Maximum number of distribution rules | nvarchar | 3 | 0 | NUMC | (N'000') | No | | ABRMAXBR | Allow NULL? |
| 7 | BETRA | Identifier "Settlement by amount" | char | 1 | 0 | CHAR | (N' ') | No | | ABRBETRA | Allow NULL? |
| 8 | MENGE | Identifier "settlement by quantity" | char | 1 | 0 | CHAR | (N' ') | No | | ABRMENGE | Allow NULL? |
| 9 | PROZE | Identifier for "percentage-rate settlement" | char | 1 | 0 | CHAR | (N' ') | No | | ABRPROZE | Allow NULL? |
| 10 | AQZIF | Identifier "settlement by equivalence number" | char | 1 | 0 | CHAR | (N' ') | No | | ABRAQZIF | Allow NULL? |
| 11 | ABSCH | Default value for allocation structure | nvarchar | 2 | 0 | CHAR | (N' ') | No | TKB5A | ABRABSCH | Allow NULL? |
| 12 | URSCH | Proposal for Source Structure | nvarchar | 2 | 0 | CHAR | (N' ') | No | | ABRURSCH | Allow NULL? |
| 13 | KOVOR | Default receiver object type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | ABRKOVOR | Allow NULL? |
| 14 | ABSAK | Settlement to G/L account | char | 1 | 0 | CHAR | (N' ') | No | | ABSAK | Allow NULL? |
| 15 | ABKST | Settlement to cost center | char | 1 | 0 | CHAR | (N' ') | No | | ABKST | Allow NULL? |
| 16 | ABAUF | Settlement to order | char | 1 | 0 | CHAR | (N' ') | No | | ABAUF | Allow NULL? |
| 17 | ABPRO | Settlement to a WBS element | char | 1 | 0 | CHAR | (N' ') | No | | ABPRO | Allow NULL? |
| 18 | ABANL | Settlement to fixed asset | char | 1 | 0 | CHAR | (N' ') | No | | ABANL | Allow NULL? |
| 19 | ABMAT | Settlement to material | char | 1 | 0 | CHAR | (N' ') | No | | ABMAT | Allow NULL? |
| 20 | ABNVG | Settlement to network | char | 1 | 0 | CHAR | (N' ') | No | | ABNVG | Allow NULL? |
| 21 | ABBOB | Settlement to a profitability segment | char | 1 | 0 | CHAR | (N' ') | No | | ABBOB | Allow NULL? |
| 22 | ABPRC | Settlement to sales order | char | 1 | 0 | CHAR | (N' ') | No | | ABPRC | Allow NULL? |
| 23 | ABIMM | Settlement to real estate object | char | 1 | 0 | CHAR | (N' ') | Yes | | ABIMM | Allow NULL? |
| 24 | BLART | Document type "Accounting document (FI) for CO settlement | nvarchar | 2 | 0 | CHAR | (N' ') | No | T003 | ABRBLART | Allow NULL? |
| 25 | RESAU | Residence time for settlement document in calendar months | nvarchar | 3 | 0 | NUMC | (N'000') | No | | RESAU | Allow NULL? |
| 26 | ERSCH | PA transfer structure | nvarchar | 2 | 0 | CHAR | (N' ') | No | TKB9A | ERSCH | Allow NULL? |
| 27 | RIFIND | Derivation Rule for Recovery Indicator in Settlement (JV) | char | 1 | 0 | CHAR | (N' ') | No | | JV_RIFIND | Allow NULL? |
| 28 | FM_DERIVE | Derive Fund and Functional Area as Receiver | char | 1 | 0 | CHAR | (N' ') | No | | PS_DERIVE | Allow NULL? |
| 29 | HBSCHL | Settlement: Credit posting key | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | ABRBSCHLHA | Allow NULL? |
| 30 | SBSCHL | Settlement: Debit posting key | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | ABRBSCHLSO | Allow NULL? |
| 31 | VARIA | Settle Variances | char | 1 | 0 | CHAR | (N' ') | No | | ABRVARIA | Allow NULL? |
| 32 | ABKTR | Settlement to cost objects | char | 1 | 0 | CHAR | (N' ') | No | | ABKTR | Allow NULL? |
| 33 | ABPRZ | Settlement to a business process | char | 1 | 0 | CHAR | (N' ') | Yes | | ABPRZ | Allow NULL? |
| 34 | ABAUP | Settlement to order item | char | 1 | 0 | CHAR | (N' ') | No | | ABAUP | Allow NULL? |
| 35 | ABRIST | Actual cost settlement/ cost of sales | char | 1 | 0 | CHAR | (N' ') | Yes | | ABRIST | Allow NULL? |
| 36 | FM_DERIVE_FONDS | Derive Funds from Recipient | char | 1 | 0 | CHAR | (N' ') | No | | PS_DERIVE_FONDS | Allow NULL? |
| 37 | FM_DERIVE_FKBER | Derive Functional Area from Recipient | char | 1 | 0 | CHAR | (N' ') | No | | PS_DERIVE_FKBER | Allow NULL? |
| 38 | FM_DERIVE_GRANT | Derive Grant from Recipient | char | 1 | 0 | CHAR | (N' ') | No | | PS_DERIVE_GRANT | Allow NULL? |
