| 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 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | J_OBJNR | Allow NULL? |
| 3 | BUREG | Distribution rule group | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BRSGR | Allow NULL? |
| 4 | LFDNR | Sequence number of distribution rule | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BR_LFDNR | Allow NULL? |
| 5 | PERBZ | Settlement type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PERBZ_LD | Allow NULL? |
| 6 | URZUO | Source Assignment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSC0D | URZUO | Allow NULL? |
| 7 | GABJA | Valid-from year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GABJA | Allow NULL? |
| 8 | GABPE | Valid-from period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | GABPE | Allow NULL? |
| 9 | GBISJ | Valid-to year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GBISJ | Allow NULL? |
| 10 | GBISP | Valid to | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | GBISP | Allow NULL? |
| 11 | PROZS | Settlement percentage rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | BRGPROZS | |
| 12 | AQZIF | Equivalence number for order settlement | decimal | 10 | 0 | DEC | ((0)) | Yes | | AQZIF | |
| 13 | BMENG | Quantity for settlement | decimal | 15 | 3 | QUAN | ((0)) | Yes | | BRGMENGE | |
| 14 | BEINH | Unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | BRGMEINH | Allow NULL? |
| 15 | BETRR | Amount for amount rule | decimal | 15 | 2 | CURR | ((0)) | Yes | | BETRR | |
| 16 | BWAER | Currency for the amount in the amount rule | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | BRGBWAER | Allow NULL? |
| 17 | BRTYP | Amount rule type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BRTYP | Allow NULL? |
| 18 | BREST | Remaining Amount for Amount Settlement w. Amount Rule Cat. | decimal | 15 | 2 | CURR | ((0)) | Yes | | AMOUNTREST | |
| 19 | ERSJA | Year first used | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ERSJA | Allow NULL? |
| 20 | ERSPE | Period of first use | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ERSPE | Allow NULL? |
| 21 | LETJA | Year last used | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LETJA | Allow NULL? |
| 22 | LETPE | Period of last use | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LETPE | Allow NULL? |
| 23 | ZINCL | "Including overheads" - indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | DZINCL | Allow NULL? |
| 24 | DFREG | Default Rule | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKB2A | DFREG | Allow NULL? |
| 25 | AVORG | Settlement transaction | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJ01 | AVORG | Allow NULL? |
| 26 | VERSN | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VERSN | Allow NULL? |
| 27 | KONTY | Account assignment category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KONTY | Allow NULL? |
| 28 | KOKRS | Controlling area of receiver | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TKA01 | BRGKOKRS | Allow NULL? |
| 29 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 30 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 31 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 32 | HKONT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | SAKNR | Allow NULL? |
| 33 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 34 | KOSTL | Receiver cost center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BRGKOSTL | Allow NULL? |
| 35 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | AUFNR | Allow NULL? |
| 36 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_PSP_PNR | Allow NULL? |
| 37 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 38 | ANLN2 | Asset Subnumber | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ANLN2 | Allow NULL? |
| 39 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 40 | BWTAR | Valuation Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T149D | BWTAR_D | Allow NULL? |
| 41 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | NPLNR | Allow NULL? |
| 42 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | CO_AUFPL | Allow NULL? |
| 43 | APLZL | Internal counter | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CIM_COUNT | Allow NULL? |
| 44 | PAOBJNR | Profitability Segment Number (CO-PA) | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | RKEOBJNR | Allow NULL? |
| 45 | PASUBNR | Profitability segment changes (CO-PA) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RKESUBNR | Allow NULL? |
| 46 | KDAUF | Sales Order Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | KDAUF | Allow NULL? |
| 47 | KDPOS | Item Number in Sales Order | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | KDPOS | Allow NULL? |
| 48 | RECID | Recovery Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_RECIND | Allow NULL? |
| 49 | RIFIND | Derivation Rule for Recovery Indicator in Settlement (JV) | char | 1 | 0 | CHAR | (N' ') | Yes | | JV_RIFIND | Allow NULL? |
| 50 | POSNR | Order Item Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CO_POSNR | Allow NULL? |
| 51 | KSTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 52 | PRZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | CO_PRZNR | Allow NULL? |
| 53 | REC_OBJNR1 | Object number for settlement receiver | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | SREC_OBJNR | Allow NULL? |
| 54 | REC_OBJNR2 | Object number for settlement receiver | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | SREC_OBJNR | Allow NULL? |
| 55 | MRULE | Manipulation Rule | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T8JL1 | MANIPRULE | Allow NULL? |
| 56 | EXTNR | Distribution Rule Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | COBR_EXTNR | Allow NULL? |
| 57 | STRAT | Method for Determining the Tracing Factor for Settlement | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_STRAT | Allow NULL? |
| 58 | ANBWA | Asset Transaction Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TABW | ANBWA | Allow NULL? |
| 59 | SRSTRAT | Strategy for automatic generation of settlement rules | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKB10SA | SR_STRAT | Allow NULL? |
