ICL_BW_PROCURE SAP (Extract Structure for Claim Item Grouping) Structure details
Description: Extract Structure for Claim Item Grouping
Related tables to ICL_BW_PROCURE
Access table ICL_BW_PROCURE
Structure field list including key, data, relationships and ABAP select examples
ICL_BW_PROCURE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extract Structure for Claim Item Grouping" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ICL_BW_PROCURE TYPE ICL_BW_PROCURE.
The ICL_BW_PROCURE table consists of various fields, each holding specific information or linking keys about Extract Structure for Claim Item Grouping data available in SAP. These include CLIENT (Client), ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), SUBCLAIM (Subclaim of Payment).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ICL_BW_PROCURE structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ACTIVE | Table entry is active (A) or in suspense (S) | ICL_ACTIVE | CHAR | 1 | ICL_ACTIVE | ||||
CLAIM | Number of Claim | ICL_CLAIM | CHAR | 17 | ICLCLAIM | ALPHA | ICL_CLAIM | ICL_CLAIM | ICL_CLAIMNO_COL |
SUBCLAIM | Subclaim of Payment | ICL_SUBCLP | CHAR | 3 | ICLSUBCL | ICL_SUBCL | |||
PROCUREMENT | ID of Claim Item Grouping | ICL_PROCUREMENT | NUMC | 4 | Assigned to domain | ICL_PROCUREMENT | |||
CHANGETIME | Changed: Date + Time | ICL_CHANGEUTC1 | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
CHANGEDBY | Changed By | ICL_CHANGEDBY | CHAR | 12 | USR02 | XUBNAME | |||
DELETED | Database Line Status (Original, Changed, Deleted) | ICL_RECSTATUS | CHAR | 1 | ICL_RECSTATUS | ||||
CREATEDBY | Created By | ICL_CREATEDBY | CHAR | 12 | USR02 | XUBNAME | |||
CREATETIME | Created: Date + Time | ICL_CREATEUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
PDOCTYPE | Benefit Type for Grouping of Lower Level Benefit Types | ICL_PDOCTYPE | CHAR | 10 | Assigned to domain | ICL_BENTYPE | |||
PDOCCAT | Claim Item Grouping Category | ICL_PDOCCAT | CHAR | 2 | TICL138 | ICL_PDOCCAT | |||
ISSUEDATE | Date Created | ICL_ISSUEDATE1 | DATS | 8 | DATS | ||||
RECEIVEDATE | Date Received | ICL_RECEIVEDATE | DATS | 8 | DATS | ||||
DATEFROM | Start Date of Period | ICL_DATEFROM | DATS | 8 | DATS | ||||
TIMEFROM | Start Time of Claim Item Group | ICL_TIMEFROM | TIMS | 6 | ICL_TIMEFROM | ||||
DATETO | End Date of Period | ICL_DATETO | DATS | 8 | DATS | ||||
TIMETO | End Time of Claim Item Group | ICL_TIMETO | TIMS | 6 | ICL_TIMETO | ||||
ISSUEDATE_PRESCR | Date Prescription Created Acc. to Invoice | ICL_ISSUEDATE_PRESCR | DATS | 8 | DATS | ICL_ISSUEDATE_PRESCR | |||
ACQUISITIONDATE | Date Entered | ICL_ACQUISITIONDATE | DATS | 8 | DATS | ||||
AMOUNT1 | General Amount Field | ICL_AMOUNT1 | CURR | 15(2) | ICL_AMOUNT | ||||
CURRENCY | Currency | ICL_CURRENCY | CUKY | 5 | TCURC | WAERS | |||
EXTERNALREF | External Reference of Claim Item Grouping | ICL_EXTERNALREF | CHAR | 20 | ICL_EXTERNALREF | ||||
EXTDOCUMENT | External Document Number | ICL_EXTDOCUMENT | CHAR | 16 | ICL_EXTDOCUMENT | ||||
EXTCASENO | Hospital-Internal ID | ICLH_EXTCASENO | CHAR | 23 | ICLH_EXTCASENO | ||||
EXTFILENO | HI: External Data Set Identification | ICLH_EXTFILENO | CHAR | 20 | ICLH_EXTFILENO | ||||
PROC_REF | Reference to Claim Item Grouping | ICL_PROC_REF | NUMC | 4 | ICLPROCURE | ICL_PROCUREMENT | |||
DISCOUNTAMOUNT | Discount on Invoice Amount | ICL_DISCOUNTAMOUNT | CURR | 15(2) | ICL_AMOUNT | ||||
DISCOUNTPERCENT | Discount on Total Invoice Amount in Percent | ICL_DISCOUNTPERCENT | DEC | 5(2) | ICL_PERCENT | ||||
ACCIDENT | Accident or Other Reason for Possible Recovery | ICL_ACCIDENT | CHAR | 2 | TICL158 | ICL_ACCIDENT | |||
SUBROGATION | Indication Whether Recovery Claim Might Be Involved | ICL_SUBROGATION | CHAR | 2 | TICL157 | ICL_SUBROGATION | |||
DUEDATE | Due Date | ICL_DUEDATE | DATS | 8 | DATE | ||||
DUEDATE_ORIG | Origin of Due Date | ICL_DUEDATE_ORIG | DATS | 8 | DATE | ||||
STATUS | Status of a Claim Item Grouping | ICL_PROCSTATUS | CHAR | 2 | TICL140 | ICL_STATUS | |||
STATREASON | Reason for Changing the Status | ICL_FORMSET | CHAR | 2 | TICL018 | ICL_FORMSET | |||
OWNCONTRIB | Copayment | ICL_OWNCONTRIB | NUMC | 3 | NUMC03 | ||||
REASON | Reason for Creating a Claim Item Grouping | ICL_REASON | CHAR | 3 | TICL152 | ICL_REASON | |||
CAUSE | Specification of Reason for Creating Claim Item Grouping | ICLH_CAUSE | CHAR | 2 | Assigned to domain | ICLH_CAUSE | |||
PDOCCATTYPE | Type of Claim Item Grouping Category | ICL_PDOCCATTYPE | CHAR | 3 | TICL153 | ICL_PDOCCATTYPE | |||
SUBCL_ORIG | Original Subclaim Multiple Prescription/Curr.Subclm Appraisl | ICL_SUBCL_ORIG | CHAR | 3 | Assigned to domain | ICL_SUBCL | |||
PROC_ORIG | Original Claim Item Grouping of Multiple Prescription | ICL_PROC_ORIG | NUMC | 4 | Assigned to domain | ICL_PROCUREMENT | |||
DATASOURCE | Data Origin | ICL_DATASOURCE | CHAR | 2 | TICL136 | ICL_DATASOURCE | |||
SETORDERDATE | Set Order Date | ICL_SETORDERDATE | DATS | 8 | DATS | ||||
COMPLETIONDATE | Completion Date | ICL_COMPLETIONDATE | DATS | 8 | DATS | ||||
FEE | Fee | ICLH_FEE | CURR | 15(2) | ICL_AMOUNT | ||||
MATLABCOST | Material and Laboratory Costs | ICLH_MATLABCOST | CURR | 15(2) | ICL_AMOUNT | ||||
MATLABCOSTINT | will be deleted. | ICLH_MATLABCOSTINT | CURR | 15(2) | ICL_AMOUNT | ||||
ADDCOST | Other Costs | ICLH_ADDCOST | CURR | 15(2) | ICL_AMOUNT | ||||
VALPERUNIT | Value per Unit of Benefits Catalog Item | ICL_SERVCAT_POS_VALPERUNIT | DEC | 20(12) | ICL_SERVCAT_POS_VALPERUNIT | ||||
SUBSIDYPERCENT | Subsidy in Percent (%) | ICLH_SUBSIDYPERCENT | DEC | 5(2) | ICL_PERCENT | ||||
SUBSIDYAMOUNT | Subsidy Amount | ICLH_SUBSIDYAMOUNT | CURR | 15(2) | ICL_AMOUNT | ||||
SENTUTC | Sent: Date and Time | ICL_SENTUTC | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
SENT_BY_DME | Sent via External Interface (Not Yet Used) | ICL_SENT_BY_DME | CHAR | 1 | XFELD | ||||
RECEIPT_BY_DME | Receipt via External Interface | ICL_RECEIPT_BY_DME | CHAR | 1 | XFELD | ||||
CANCEL | Status 'Cancelled' | ICL_STATUS_CANCEL | CHAR | 1 | XFELD | ||||
REJECTED | Status 'Rejected' | ICL_STATUS_REJECTED | CHAR | 1 | XFELD | ||||
INSUSPENSE | Status 'Pending' | ICL_STATUS_INSUSPENSE | CHAR | 1 | XFELD | ||||
INPROCESS | Status 'In Process' | ICL_STATUS_INPROCESS | CHAR | 1 | XFELD | ||||
RELEASED | Status 'Released' | ICL_STATUS_RELEASED | CHAR | 1 | XFELD | ||||
XFINISHED | Complete/Approved/Finished | ICL_XFINISHED | CHAR | 1 | XFELD | ||||
ORDERED | Status 'Commissioned' | ICL_STATUS_ORDERED | CHAR | 1 | XFELD | ||||
TRANSFERRED | Status 'Reassigned' | ICL_STATUS_TRANSFERRED | CHAR | 1 | XFELD | ||||
TOBEAPPROVED | Status 'To Be Approved' | ICL_STATUS_TOBEAPPROVED | CHAR | 1 | XFELD | ||||
XCLINICCARD | Flag: Clinic Card | ICLH_CLINIC_CARD | CHAR | 1 | ICLH_CLINIC_CARD | ||||
PAYFREQPLAN | Payment Frequency of a Repetitive Payment | ICL_PAYFREQPLAN_REP | CHAR | 2 | TVS010B | PKEY_VK | |||
ASSIGN_GUID | UUID of Entry to be Linked | ICL_ASSIGN_GUID | CHAR | 32 | SYSUUID_C | ||||
XREQUEST | Indicator: Receivable | ICL_XREQUEST | CHAR | 1 | XFELD | ||||
COMPPER_DATEFROM | Comparision Period From | ICL_COMPPER_DATEFROM_D_PE | DATS | 8 | ICL_COMPPER_PE | ||||
COMPPER_DATETO | Comparison Period To | ICL_COMPPER_DATETO_D_PE | DATS | 8 | ICL_COMPPER_PE | ||||
PAYOUT_SCENARIO | Repetitive Payment Scenario | ICL_PAYOUT_SCENARIO_D | CHAR | 1 | ICL_PAYOUT_SCENARIO | ||||
REASONREJ | Rejection Reasons for Payments and Reserves | ICL_REASONREJ | CHAR | 2 | Assigned to domain | ICL_REASONREJ | |||
METHOD | Payment Method | ICL_PAYMENT01 | CHAR | 1 | Assigned to domain | PYMET_KK | PAYMENTMETHOD | ||
ADDRNUMBER | Address Number for Checks | ICL_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
BKID | Bank Details ID | ICL_BKID | CHAR | 4 | CHAR4 | ||||
CLAIMTYPE | Internal Claim Type | ICL_CLTYPE | CHAR | 4 | TICL011 | ICL_CLTYPE | |||
INVOICER | Invoicing Party | ICL_INVOICER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
HEALTHSERVPROV | Service Provider | ICL_HEALTHSERVPROV | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
APPRAISER | Appraiser | ICL_APPRAISER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
PRESCDOCTOR | Prescriber | ICL_PRESCDOC | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
DATELOSS | Date of Loss/Claim | ICL_LOSSDATE | DATS | 8 | DATE | ICL_LOSSDATE | |||
PLINEOFBUS | Insurance Line of Business | ICL_LINEOFBUS | CHAR | 3 | Assigned to domain | ICL_LINEOFBUS | |||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ORGUNIT | Organizational Unit | ICL_ORGUNIT | NUMC | 8 | Assigned to domain | HR_SOBJID | |||
UPDMOD | BW Delta Process: Record Mode | RODMUPDMOD | CHAR | 1 | RODMUPDMOD |
Key field | Non-key field |
How do I retrieve data from SAP structure ICL_BW_PROCURE using ABAP code?
As ICL_BW_PROCURE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ICL_BW_PROCURE as there is no data to select.How to access SAP table ICL_BW_PROCURE
Within an ECC or HANA version of SAP you can also view further information about ICL_BW_PROCURE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects