SAP Table FINT_BSP_SRU_SRULE
Settlement Rules
FINT_BSP_SRU_SRULE (Settlement Rules) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FINT_BSP_SRU_SRULE to other SAP tables.
FINT_BSP_SRU_SRULE table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECT_KEY | Object Key | CRMT_BSP_OBJECTKEY | CHAR | 100 | 0 | |||||||||||||||
BUREG | Distribution rule group | BRSGR | NUMC | 3 | 0 | |||||||||||||||
BURTX | Text of Distribution Rule Group | BURTX | CHAR | 40 | 0 | |||||||||||||||
BURCNT | Number of References to a Posting Rule | BURCNT | NUMC | 6 | 0 | |||||||||||||||
LFDNR | Sequence number of distribution rule | BR_LFDNR | NUMC | 3 | 0 | |||||||||||||||
KONTY | Account assignment category | KONTY | CHAR | 2 | 0 | |||||||||||||||
EMPGE | General settlement receiver | ABR_EMP | CHAR | 35 | 0 | |||||||||||||||
EMPTX | Text, 40 Characters Long | TEXT40 | CHAR | 40 | 0 | |||||||||||||||
PROZS | Settlement percentage rate | BRGPROZS | DEC | 5 | 2 | |||||||||||||||
AQZIF | Equivalence number for order settlement | AQZIF | DEC | 10 | 0 | |||||||||||||||
BETRR | Amount for amount rule | BETRR | CURR | 15 | 2 | |||||||||||||||
BWAER | Currency for the amount in the amount rule | BRGBWAER | TCURC | CUKY | 5 | 0 | ||||||||||||||
BRTYP | Amount rule type | BRTYP | CHAR | 2 | 0 |
Possible values
|
||||||||||||||
PERBZ | Settlement type | PERBZ_LD | CHAR | 3 | 0 |
Possible values
|
||||||||||||||
EXTNR | Distribution Rule Number | COBR_EXTNR | NUMC | 3 | 0 | |||||||||||||||
MRULE | Manipulation Rule | MANIPRULE | T8JL1 | CHAR | 4 | 0 | ||||||||||||||
SRSTRAT | Strategy for automatic generation of settlement rules | SR_STRAT | TKB10SA | CHAR | 3 | 0 | ||||||||||||||
GABJA | Valid-from year | GABJA | NUMC | 4 | 0 | |||||||||||||||
GABPE | Valid-from period | GABPE | NUMC | 3 | 0 | |||||||||||||||
GBISJ | Valid-to year | GBISJ | NUMC | 4 | 0 | |||||||||||||||
GBISP | Valid to | GBISP | NUMC | 3 | 0 | |||||||||||||||
USED_FROM | Used From | USED_FROM_D | NUMC | 7 | 0 | |||||||||||||||
USED_TO | Used To | USED_TO_D | NUMC | 7 | 0 | |||||||||||||||
BREST | Remaining Amount for Amount Settlement w. Amount Rule Cat. | AMOUNTREST | CURR | 15 | 2 | |||||||||||||||
RWAER | Currency Key | WAERS | CUKY | 5 | 0 | |||||||||||||||
MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | 0 | |||||||||||||||
ERNAM | Entered by | BRGERNAM | CHAR | 12 | 0 | |||||||||||||||
ERDAT | Created on | BRGERDAT | DATS | 8 | 0 | |||||||||||||||
AENAM | Last changed by | BRGAENAM | CHAR | 12 | 0 | |||||||||||||||
AEDAT | Changed on | BRGAEDAT | DATS | 8 | 0 | |||||||||||||||
KTEXT | Description of settlement rule | BRGKTEXT | CHAR | 40 | 0 | |||||||||||||||
ABSCH | Allocation Structure for Settlement/Assessment | BRGABSCH | TKB5A | CHAR | 2 | 0 | ||||||||||||||
KSTAR | Settlement cost element for receiver | ABRKSTAR | CSKA | CHAR | 10 | 0 | ||||||||||||||
URSCH | Source structure | URSCH | TSC0A | CHAR | 2 | 0 | ||||||||||||||
GMENG | Total quantity | BRGGMENG | QUAN | 15 | 3 | |||||||||||||||
GEINH | Unit of measure of total quantity | GEINH | T006 | UNIT | 3 | 0 | ||||||||||||||
ANALG | Identifier for "proportional settlement" | ANALG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
ERSAV | Identifier for "incorrect update" | ERSAV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
APROF | Settlement profile | APROF | TKB1A | CHAR | 6 | 0 | ||||||||||||||
ABRNR | Sequential settlement number | ABRNR | INT2 | 5 | 0 | |||||||||||||||
BZDAT | Asset value date | BZDAT | DATS | 8 | 0 | |||||||||||||||
ERSCH | PA transfer structure | ERSCH | TKB9A | CHAR | 2 | 0 | ||||||||||||||
HIENR | Hierarchy number for settlement | BRGHIENR | NUMC | 3 | 0 | |||||||||||||||
SORT | Settlement rule sort field | SETTLESORT | CHAR | 22 | 0 | |||||||||||||||
TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC | 16 | 0 | |||||||||||||||
LYOPR | Final Year with Old Plan Settlement Method | LYOPR | NUMC | 4 | 0 | |||||||||||||||
SRSLIST | Strategy sequences for automatic generation of SETC | SR_SLIST | TKB10SLA | CHAR | 6 | 0 | ||||||||||||||
URZUO | Source Assignment | URZUO | TSC0D | CHAR | 3 | 0 | ||||||||||||||
BMENG | Quantity for settlement | BRGMENGE | QUAN | 15 | 3 | |||||||||||||||
BEINH | Unit of measure | BRGMEINH | T006 | UNIT | 3 | 0 | ||||||||||||||
ERSJA | Year first used | ERSJA | NUMC | 4 | 0 | |||||||||||||||
ERSPE | Period of first use | ERSPE | NUMC | 3 | 0 | |||||||||||||||
LETJA | Year last used | LETJA | NUMC | 4 | 0 | |||||||||||||||
LETPE | Period of last use | LETPE | NUMC | 3 | 0 | |||||||||||||||
ZINCL | "Including overheads" - indicator | DZINCL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
DFREG | Default Rule | DFREG | TKB2A | CHAR | 3 | 0 | ||||||||||||||
AVORG | Settlement transaction | AVORG | TJ01 | CHAR | 4 | 0 | ||||||||||||||
VERSN | Version | VERSN | CHAR | 3 | 0 | |||||||||||||||
KOKRS | Controlling area of receiver | BRGKOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||||
WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||||||||
GSBER | Business Area | GSBER | CHAR | 4 | 0 | |||||||||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||
HKONT | G/L Account Number | SAKNR | SKA1 | CHAR | 10 | 0 | ||||||||||||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | 0 | |||||||||||||||
KOSTL | Receiver cost center | BRGKOSTL | CHAR | 10 | 0 | |||||||||||||||
AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | 0 | |||||||||||||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | 0 | |||||||||||||||
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | 0 | |||||||||||||||
MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||||||||
BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 0 | ||||||||||||||
NPLNR | Network Number for Account Assignment | NPLNR | AUFK | CHAR | 12 | 0 | ||||||||||||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | 0 | |||||||||||||||
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | 0 | |||||||||||||||
PASUBNR | Profitability segment changes (CO-PA) | RKESUBNR | NUMC | 4 | 0 | |||||||||||||||
KDAUF | Sales Order Number | KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||||
KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | 0 | |||||||||||||||
RECID | Recovery Indicator | JV_RECIND | T8JJ | CHAR | 2 | 0 | ||||||||||||||
RIFIND | Derivation Rule for Recovery Indicator in Settlement (JV) | JV_RIFIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
POSNR | Order Item Number | CO_POSNR | NUMC | 4 | 0 | |||||||||||||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | 0 | |||||||||||||||
PRZNR | Business Process | CO_PRZNR | CHAR | 12 | 0 | |||||||||||||||
REC_OBJNR1 | Object number for settlement receiver | SREC_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||||||
REC_OBJNR2 | Object number for settlement receiver | SREC_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||||||
STRAT | Method for Determining the Tracing Factor for Settlement | CO_STRAT | NUMC | 3 | 0 |
Possible values
|
||||||||||||||
ANBWA | Asset Transaction Type | ANBWA | TABW | CHAR | 3 | 0 | ||||||||||||||
UPDKZ | Update indicator | IM_UPDKZ | CHAR | 1 | 0 |
FINT_BSP_SRU_SRULE foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
FINT_BSP_SRU_SRULE | ABSCH | FINT_BSP_SRU_SRULE | MANDT | TKB5A | Allocation structure | MANDT |
FINT_BSP_SRU_SRULE | ABSCH | FINT_BSP_SRU_SRULE | ABSCH | TKB5A | Allocation structure | ABSCH |
FINT_BSP_SRU_SRULE | ANBWA | FINT_BSP_SRU_SRULE | MANDT | TABW | Asset transaction types | MANDT |
FINT_BSP_SRU_SRULE | ANBWA | FINT_BSP_SRU_SRULE | ANBWA | TABW | Asset transaction types | BWASL |
FINT_BSP_SRU_SRULE | APROF | FINT_BSP_SRU_SRULE | MANDT | TKB1A | Settlement Profile | MANDT |
FINT_BSP_SRU_SRULE | APROF | FINT_BSP_SRU_SRULE | APROF | TKB1A | Settlement Profile | APROF |
FINT_BSP_SRU_SRULE | AUFNR | FINT_BSP_SRU_SRULE | MANDT | AUFK | Order master data | MANDT |
FINT_BSP_SRU_SRULE | AUFNR | FINT_BSP_SRU_SRULE | AUFNR | AUFK | Order master data | AUFNR |
FINT_BSP_SRU_SRULE | AVORG | FINT_BSP_SRU_SRULE | AVORG | TJ01 | Business Transactions | VRGNG |
FINT_BSP_SRU_SRULE | BEINH | FINT_BSP_SRU_SRULE | MANDT | T006 | Units of Measurement | MANDT |
FINT_BSP_SRU_SRULE | BEINH | FINT_BSP_SRU_SRULE | BEINH | T006 | Units of Measurement | MSEHI |
FINT_BSP_SRU_SRULE | BUKRS | FINT_BSP_SRU_SRULE | BUKRS | T001 | Company Codes | BUKRS |
FINT_BSP_SRU_SRULE | BUKRS | FINT_BSP_SRU_SRULE | MANDT | T001 | Company Codes | MANDT |
FINT_BSP_SRU_SRULE | BWAER | FINT_BSP_SRU_SRULE | BWAER | TCURC | Currency Codes | WAERS |
FINT_BSP_SRU_SRULE | BWAER | FINT_BSP_SRU_SRULE | MANDT | TCURC | Currency Codes | MANDT |
FINT_BSP_SRU_SRULE | BWTAR | FINT_BSP_SRU_SRULE | MANDT | T149D | Global Valuation Types | MANDT |
FINT_BSP_SRU_SRULE | BWTAR | FINT_BSP_SRU_SRULE | BWTAR | T149D | Global Valuation Types | BWTAR |
FINT_BSP_SRU_SRULE | DFREG | FINT_BSP_SRU_SRULE | MANDT | TKB2A | Default Rules for Posting Rules | MANDT |
FINT_BSP_SRU_SRULE | DFREG | FINT_BSP_SRU_SRULE | DFREG | TKB2A | Default Rules for Posting Rules | DFREG |
FINT_BSP_SRU_SRULE | ERSCH | FINT_BSP_SRU_SRULE | MANDT | TKB9A | Assignment Structure for Settlement to Profitability Anysis | MANDT |
FINT_BSP_SRU_SRULE | ERSCH | FINT_BSP_SRU_SRULE | ERSCH | TKB9A | Assignment Structure for Settlement to Profitability Anysis | ERSCH |
FINT_BSP_SRU_SRULE | GEINH | FINT_BSP_SRU_SRULE | MANDT | T006 | Units of Measurement | MANDT |
FINT_BSP_SRU_SRULE | GEINH | FINT_BSP_SRU_SRULE | GEINH | T006 | Units of Measurement | MSEHI |
FINT_BSP_SRU_SRULE | HKONT | FINT_BSP_SRU_SRULE | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
FINT_BSP_SRU_SRULE | HKONT | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
FINT_BSP_SRU_SRULE | HKONT | FINT_BSP_SRU_SRULE | HKONT | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
FINT_BSP_SRU_SRULE | KDAUF | FINT_BSP_SRU_SRULE | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
FINT_BSP_SRU_SRULE | KDAUF | FINT_BSP_SRU_SRULE | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
FINT_BSP_SRU_SRULE | KOKRS | FINT_BSP_SRU_SRULE | MANDT | TKA01 | Controlling Areas | MANDT |
FINT_BSP_SRU_SRULE | KOKRS | FINT_BSP_SRU_SRULE | KOKRS | TKA01 | Controlling Areas | KOKRS |
FINT_BSP_SRU_SRULE | KSTAR | FINT_BSP_SRU_SRULE | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
FINT_BSP_SRU_SRULE | KSTAR | T001 | KTOPL | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL |
FINT_BSP_SRU_SRULE | KSTAR | FINT_BSP_SRU_SRULE | KSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
FINT_BSP_SRU_SRULE | MRULE | FINT_BSP_SRU_SRULE | KOKRS | T8JL1 | Joint Venture: Manipulation Rules for Recovery Indicator | KOKRS |
FINT_BSP_SRU_SRULE | MRULE | FINT_BSP_SRU_SRULE | MRULE | T8JL1 | Joint Venture: Manipulation Rules for Recovery Indicator | MRULE |
FINT_BSP_SRU_SRULE | MRULE | FINT_BSP_SRU_SRULE | MANDT | T8JL1 | Joint Venture: Manipulation Rules for Recovery Indicator | MANDT |
FINT_BSP_SRU_SRULE | NPLNR | FINT_BSP_SRU_SRULE | MANDT | AUFK | Order master data | MANDT |
FINT_BSP_SRU_SRULE | NPLNR | FINT_BSP_SRU_SRULE | NPLNR | AUFK | Order master data | AUFNR |
FINT_BSP_SRU_SRULE | RECID | FINT_BSP_SRU_SRULE | MANDT | T8JJ | Recovery Indicator | MANDT |
FINT_BSP_SRU_SRULE | RECID | FINT_BSP_SRU_SRULE | BUKRS | T8JJ | Recovery Indicator | BUKRS |
FINT_BSP_SRU_SRULE | RECID | FINT_BSP_SRU_SRULE | RECID | T8JJ | Recovery Indicator | RECID |
FINT_BSP_SRU_SRULE | REC_OBJNR1 | FINT_BSP_SRU_SRULE | MANDT | ONR00 | General Object Number | MANDT |
FINT_BSP_SRU_SRULE | REC_OBJNR1 | FINT_BSP_SRU_SRULE | REC_OBJNR1 | ONR00 | General Object Number | OBJNR |
FINT_BSP_SRU_SRULE | REC_OBJNR2 | FINT_BSP_SRU_SRULE | REC_OBJNR2 | ONR00 | General Object Number | OBJNR |
FINT_BSP_SRU_SRULE | REC_OBJNR2 | FINT_BSP_SRU_SRULE | MANDT | ONR00 | General Object Number | MANDT |
FINT_BSP_SRU_SRULE | SRSLIST | FINT_BSP_SRU_SRULE | MANDT | TKB10SLA | Strategy Sequences for Automatic Generation of SETC - Header | MANDT |
FINT_BSP_SRU_SRULE | SRSLIST | FINT_BSP_SRU_SRULE | SRSLIST | TKB10SLA | Strategy Sequences for Automatic Generation of SETC - Header | SLIST |
FINT_BSP_SRU_SRULE | SRSTRAT | FINT_BSP_SRU_SRULE | SRSTRAT | TKB10SA | Strategies for Automatic Generation of SETTC - Header | STRAT |
FINT_BSP_SRU_SRULE | URSCH | 'U' | TSC0A | Table of Structures | SCTYP | |
FINT_BSP_SRU_SRULE | URSCH | FINT_BSP_SRU_SRULE | URSCH | TSC0A | Table of Structures | SCNAM |
FINT_BSP_SRU_SRULE | URSCH | FINT_BSP_SRU_SRULE | MANDT | TSC0A | Table of Structures | MANDT |
FINT_BSP_SRU_SRULE | URZUO | FINT_BSP_SRU_SRULE | URZUO | TSC0D | Assignment Table | SCZUO |
FINT_BSP_SRU_SRULE | URZUO | FINT_BSP_SRU_SRULE | MANDT | TSC0D | Assignment Table | MANDT |
FINT_BSP_SRU_SRULE | URZUO | 'U' | TSC0D | Assignment Table | SCTYP | |
FINT_BSP_SRU_SRULE | URZUO | COBRA | URSCH | TSC0D | Assignment Table | SCNAM |