ICLPROCEDUREDRFT

Transparent Table Application Table
29 Fields 1 CDS Views

Draft table for entity R_INS_ClaimProcedure

ICLPROCEDUREDRFT is an SAP database table in S/4HANA. Draft table for entity R_INS_ClaimProcedure. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_INS_ClaimProcedureDraft view_entity from BASIC Claim Procedures - Draft

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY insurclmactive ICL_ACTIVE Active/Suspense
KEY insuranceclaim ICL_CLAIM Claim Number
KEY insuranceclaimprocedureuuid ICL_PROCEDUREGUID UUID Procedure
KEY insurclmpaymentsubclaim ICL_SUBCLP Subclaim
KEY insuranceclaimprocurementid ICL_PROCUREMENT ClaimItem Gpng
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
lastchangedatetime ICL_ACHANGETIME_FIORI Last Changed At
lastchangedbyuser ICL_CHANGEDBY Changed By
insurclmdatabaselinestatus ICL_RECSTATUS Status
insuranceclaimprocedurename ICL_PROCEDURES_NAME Procedure Name
insurclmitembenefitcataloguuid ICL_SERVCAT_POSID_INT Int. BC Item ID
insurclmitemidofservicecatalog ICL_SERVCATID_PROCEDURES Benef.Catalog
insurclmitmbnftcatalogitemid ICL_SERVCAT_POSID BenCtlg Item
insuranceclaimprocedurenumber ICL_PROCEDURENO Number
insuranceclaimpatientnumber ICLH_PROCED_PART Person Treated
insuranceclaimisprimproced ICL_PRIMPROCEDURE Prim.Procedure
insurclmprocedperfrmddtetme ICL_PROCEDURE_TIME Time Performed
insurclmlocalizedside ICL_LOCALIZATION Localization
insurclmdeptofhosp ICL_DEPARTMENT Department
insurclmisusdforgrpg ICL_USED4CALC Used f.Grouping
dummy_field abap.char
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Draft table for entity R_INS_ClaimProcedure
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPROCEDUREDRFT (
    MANDT,                           -- Client [MANDT]
    INSURCLMACTIVE,                  -- Active/Suspense [ICL_ACTIVE]
    INSURANCECLAIM,                  -- Claim Number [ICL_CLAIM]
    INSURANCECLAIMPROCEDUREUUID,     -- UUID Procedure [ICL_PROCEDUREGUID]
    INSURCLMPAYMENTSUBCLAIM,         -- Subclaim [ICL_SUBCLP]
    INSURANCECLAIMPROCUREMENTID,     -- ClaimItem Gpng [ICL_PROCUREMENT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    LASTCHANGEDATETIME,              -- Last Changed At [ICL_ACHANGETIME_FIORI]
    LASTCHANGEDBYUSER,               -- Changed By [ICL_CHANGEDBY]
    INSURCLMDATABASELINESTATUS,      -- Status [ICL_RECSTATUS]
    INSURANCECLAIMPROCEDURENAME,     -- Procedure Name [ICL_PROCEDURES_NAME]
    INSURCLMITEMBENEFITCATALOGUUID,  -- Int. BC Item ID [ICL_SERVCAT_POSID_INT]
    INSURCLMITEMIDOFSERVICECATALOG,  -- Benef.Catalog [ICL_SERVCATID_PROCEDURES]
    INSURCLMITMBNFTCATALOGITEMID,    -- BenCtlg Item [ICL_SERVCAT_POSID]
    INSURANCECLAIMPROCEDURENUMBER,   -- Number [ICL_PROCEDURENO]
    INSURANCECLAIMPATIENTNUMBER,     -- Person Treated [ICLH_PROCED_PART]
    INSURANCECLAIMISPRIMPROCED,      -- Prim.Procedure [ICL_PRIMPROCEDURE]
    INSURCLMPROCEDPERFRMDDTETME,     -- Time Performed [ICL_PROCEDURE_TIME]
    INSURCLMLOCALIZEDSIDE,           -- Localization [ICL_LOCALIZATION]
    INSURCLMDEPTOFHOSP,              -- Department [ICL_DEPARTMENT]
    INSURCLMISUSDFORGRPG,            -- Used f.Grouping [ICL_USED4CALC]
    DUMMY_FIELD,                     -- abap.char
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, INSURCLMACTIVE, INSURANCECLAIM, INSURANCECLAIMPROCEDUREUUID, INSURCLMPAYMENTSUBCLAIM, INSURANCECLAIMPROCUREMENTID, DRAFTUUID)
);

Learn More