The COLLSTRGY_DRAFT table in SAP ERP or S/4HANA stores I_COLLECTIONSTRATEGYTP I_COLLECTIONSTRATEGYTP data. There are total 33 fields in COLLSTRGY_DRAFT table. The I_COLLECTIONSTRATEGYTP I_COLLECTIONSTRATEGYTP 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 COLLSTRGY_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 COLLSTRGY_DRAFT Table Fields
Following is the list of fields that are available in SAP COLLSTRGY_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) | |
| COLLECTIONSTRATEGY | Collection Strategy | UDM_COLL_STRATEGY | CHAR (10) | |
| COLLECTIONSTRATEGYFOREDIT | Collection Strategy | UDM_COLL_STRATEGY | CHAR (10) | |
| COLLSTRGYNAME | Name of Collection Strategy | FIN_MNG_COLSTR_STRATEGY_TEXT | CHAR (60) | |
| COLLSTRGYCURRENCY | Strategy Currency | UDM_COLL_STRATEGY_CURRENCY | CUKY (5) | |
| COLLSTRGYMAXVALUATION | Maximum Valuation | UDM_MAX_VALUATION | INT4 (10) | |
| COLLSTRGYAUTOVALUATION | Collection Strategy Automatic Valuation | FIN_MNG_COLSTR_AUTO_VALUATION | CHAR (1) | |
| COLLSTRGYISACTIVE | Collection Strategy Status | FIN_MNG_COLSTR_IS_ACTIVE | CHAR (1) | |
| COLLSTRGYSTSCRITICALITY | Collection Strategy Status Criticality | FIN_MNG_COLSTR_STS_CRITICALITY | INT1 (3) | |
| COLLSTRGYSTSDESC | Collection Strategy Status | FIN_MNG_COLSTR_STATUS_DESC | CHAR (20) | |
| COLLDUDTECSHDISCISCONSIDERED | Consideration of Due Date for Cash Discount | FIN_MNG_COLSTR_CASH_DISC_DLINE | CHAR (1) | |
| COLLSTRGYNMBRDAYSBEFOREDUEDATE | Number of Days before Due Date | FIN_MNG_COLSTR_DAY_BEFORE_DUE | INT4 (10) | |
| COLLSTRGYTOLDAYSAFTERDUNN | Tolerance Days after Sending Dunning Notice | FIN_MNG_COLSTR_DUNN_GRACE_DAYS | NUMC (2) | |
| COLLITMWTHLGLDUNPROCEDISEXCL | Exclude Items with Legal Dunning Procedure | FIN_MNG_COLSTR_FLAG_LEGAL_DUNN | CHAR (1) | |
| COLLSTRGYOVERDUEPERIOD1 | Overdue Period | UDM_OVERDUE_PERIOD1 | INT4 (10) | |
| COLLSTRGYOVERDUEPERIOD2 | Overdue Period 2 | FIN_MNG_COLSTR_OVERDUE_PERIOD2 | INT4 (10) | |
| COLLSTRGYOVERDUEPERIOD3 | Overdue Period 3 | FIN_MNG_COLSTR_OVERDUE_PERIOD3 | INT4 (10) | |
| COLLSTRGYOVERDUEPERIOD4 | Overdue Period 4 | FIN_MNG_COLSTR_OVERDUE_PERIOD4 | INT4 (10) | |
| COLLSTRGYDUEDATEPERIOD1 | Due Date Period | UDM_DUE_PERIOD1 | INT4 (10) | |
| COLLSTRGYDUEDATEPERIOD2 | Due Date Period 2 | FIN_MNG_COLSTR_DUE_PERIOD2 | INT4 (10) | |
| COLLSTRGYDUEDATEPERIOD3 | Due Date Period 3 | FIN_MNG_COLSTR_DUE_PERIOD3 | INT4 (10) | |
| COLLSTRGYDUEDATEPERIOD4 | Due Date Period 4 | FIN_MNG_COLSTR_DUE_PERIOD4 | INT4 (10) | |
| COLLSTRGYCREATEDBY | Created By User | FIN_MNG_COLSTR_CREATED_BY | CHAR (12) | |
| COLLSTRGYCREATEDON | Created On | FIN_MNG_COLSTR_CREATED_ON | DEC (21) | |
| COLLSTRGYLASTCHANGEDBY | Last Changed By | UDM_CHANGED_BY | CHAR (12) | |
| COLLSTRGYLASTCHANGEDON | Changed On | FIN_MNG_COLSTR_CHANGE_ON | DEC (21) | |
| 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) |
