The COLLRLVLN_DRAFT table in SAP ERP or S/4HANA stores I_COLLECTIONSTRATEGYTP I_COLLRULEVALUETOCOLLSTRGYTP data. There are total 22 fields in COLLRLVLN_DRAFT table. The I_COLLECTIONSTRATEGYTP I_COLLRULEVALUETOCOLLSTRGYTP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of COLLRLVLN_DRAFT table. It is in OData Services – Manage Collection Strategies (ODATA_MANAGE_COLL_STRATEGIES) ABAP package and is part of the Fiori FXU Credit Management FIN-FIO-CCD (CA-GTF-FXU-FI-CCD) module.
SAP COLLRLVLN_DRAFT Table Fields
Following is the list of fields that are available in SAP COLLRLVLN_DRAFT table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| ROOTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| COLLECTIONSTRATEGY | Collection Strategy | UDM_COLL_STRATEGY | CHAR (10) | |
| COLLRULESQNCNMBRINSTRGY | Sequence Number of a Strategy | UDM_SEQUENCE_ID | INT4 (10) | |
| COLLSELOPTNCNTRINSTRGY | Sequence Number of a Strategy | UDM_SEQUENCE_ID | INT4 (10) | |
| COLLBASICRULESTRUC | Basic Rule Structure | UDM_BASIS_RULE_STRUCTURE | CHAR (30) | |
| COLLBASICRULEFIELDNAME | Field Name | FIELDNAME | CHAR (30) | |
| SETRANGESIGN | ABAP: ID: I/E (include/exclude values) | TVARV_SIGN | CHAR (1) | |
| SETRANGEOPTION | ABAP: Selection option (EQ/BT/CP/…) | TVARV_OPTI | CHAR (2) | |
| SETRANGEFROMVALUE | ABAP: Selection Value (LOW or HIGH Value, External Format) | TVARV_VAL | CHAR (45) | |
| SETRANGETOVALUE | ABAP: Selection Value (LOW or HIGH Value, External Format) | TVARV_VAL | CHAR (45) | |
| COLLSTRGYCURRENCY | Strategy Currency | UDM_COLL_STRATEGY_CURRENCY | CUKY (5) | |
| MINTARGETAMOUNT | Item Amount | UDM_BR_ITEM_AMOUNT | CURR (15) | |
| MAXTARGETAMOUNT | Item Amount | UDM_BR_ITEM_AMOUNT | CURR (15) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
