ICLPARTDRAFT2

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_CLAIMPARTICIPANTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICLPARTDRAFT2 (
    MANDT,                           -- Client [MANDT]
    INSURCLMACTIVE,                  -- Active/Suspense [ICL_ACTIVE]
    INSURANCECLAIM,                  -- Claim Number [ICL_CLAIM]
    INSURCLMBUSINESSPARTNER,         -- Participant [ICL_PART]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    CHANGEDONDATETIME,               -- Last Changed At [ICL_ACHANGETIME_FIORI]
    LASTCHANGEDBYUSER,               -- Changed By [ICL_CHANGEDBY]
    INSURCLMDATABASELINESTATUS,      -- Status [ICL_RECSTATUS]
    INSURCLMREFNMBRPRTCPNTDATA,      -- Reference No. [ICL_REFERENCE]
    INSURCLMRELATIONSHIP,            -- Rel. to PH [ICL_PARTRELTYPE]
    INSURCLMPRTCPNTRESPPOLICETEXT,   -- Long Text [ICL_PART_TEXT01]
    INSURCLMPRTCPNTFILEREQDATE,      -- File requested [ICL_FILE_REQ]
    INSURCLMPRTCPNTDESC,             -- Participant [ICL_DESCRIP]
    INSURCLMASSIGNUUID,              -- Link UUID [ICL_ASSIGN_GUID]
    INSURCLMPARTICIPANTTYPE,         -- Participtn Type [ICL_PARTTYPE]
    INSURCLMPRTCPNTHASLAWYER,        -- Lawyer? [ICL_XLAWYER]
    INSURCLMVALUEADDEDTAXISPAID,     -- No Val.Add Tax [ICL_XSALESTAX]
    INSURCLMPRTCPNTLIABILITYRATE,    -- Liability Rate [ICL_GUILTRATE]
    INSURCLMINTRACOMPANY,            -- Intra-Company [ICL_INTRACOMPANY]
    INSURCLMNOINSURANCE,             -- Not Insured [ICL_XNOINS]
    INSURANCECLAIMPRTCPNTSEATPOS,    -- Position in Veh [ICL_SEAT]
    INSURANCECLAIMDAMAGEDVEHICLE,    -- Vehicle [ICL_VEHICLE]
    INSURCLMPRTCPNTWTNSSTYPE,        -- Type [ICL_WIREPTYPE]
    INSURCLMPRTCPNTSTMNTISCONFD,     -- Confirmed [ICL_WIREP01]
    INSURCLMPRTCPNTWTNSSEVAL,        -- Evaluation [ICL_JUDGM]
    INSURCLMWTNSSISKNOWNTOCLAIMANT,  -- Knows claimant [ICL_WIREP02]
    INSURCLMWTNSSISKNOWNTOINSURED,   -- Knows PH? [ICL_WIREP03]
    INSURCLMPARTICIPANTAGEVALUE,     -- Age [ICL_AGE]
    INSURCLMPRTCPNTLICISSUEDATE,     -- Issue date [ICL_ISSUEDATE]
    BUSINESSPARTNERBIRTHDATE,        -- Date of Birth [BU_BIRTHDT]
    INSURCLMPRTCPNTRPRSTVCATEGORY,   -- Represent. Cat. [ICL_REPR_TYPE]
    INSURANCEDATAAGINGOBJECTDATE,    -- Data Aging [DATA_TEMPERATURE]
    BUSINESSPARTNERCATEGORY,         -- Partner Cat. [BU_TYPE]
    LASTNAME,                        -- Last Name [BU_NAMEP_L]
    ADDITIONALLASTNAME,              -- Other Last Name [BU_NAMEPL2]
    FIRSTNAME,                       -- First Name [BU_NAMEP_F]
    INSURCLMBUSINESSPARTNERGENDER,   -- Sex [BU_SEXID]
    INITIALS,                        -- Initials [AD_INITS]
    BIRTHDATE,                       -- Date of Birth [BU_BIRTHDT]
    FORMOFADDRESS,                   -- Title Key [AD_TITLE]
    ORGANIZATIONBPNAME1,             -- Name 1 [BU_NAMEOR1]
    ORGANIZATIONBPNAME2,             -- Name 2 [BU_NAMEOR2]
    GROUPBUSINESSPARTNERNAME1,       -- Name 1 [BU_NAMEGR1]
    GROUPBUSINESSPARTNERNAME2,       -- Name 2 [BU_NAMEGR2]
    PHONEAREACODESUBSCRIBERNUMBER,   -- Telephone [AD_TLNMBR]
    PHONEEXTENSIONNUMBER,            -- Extension [AD_TLXTNS]
    FAXAREACODESUBSCRIBERNUMBER,     -- Fax [AD_FXNMBR]
    FAXEXTENSIONNUMBER,              -- Extension [AD_FXXTNS]
    EMAILADDRESS,                    -- E-Mail Address [AD_SMTPADR]
    BANKCOUNTRYKEY,                  -- Bank Ctry/Reg. [BU_BANKS]
    BANKNUMBER,                      -- Bank Key [BU_BANKK]
    BANKACCOUNT,                     -- Bank acct [BU_BANKN]
    BANKCONTROLKEY,                  -- Control Key [BU_BKONT]
    BANKACCOUNTREFERENCETEXT,        -- Reference [BU_BKREF]
    BANKACCOUNTHOLDERNAME,           -- Account Holder [BU_KOINH]
    BUSINESSPARTNEREXTERNALBANKID,   -- Extern.bank ID [BU_BKEXT]
    COLLECTIONAUTHIND,               -- Collect.author. [BU_XEZER]
    LOANCONTRACTIBAN,                -- IBAN [BU_IBAN]
    CITYNAME,                        -- City [AD_CITY1]
    POSTALCODE,                      -- Postal Code [AD_PSTCD1]
    STREETNAME,                      -- Street [AD_STREET]
    HOUSENUMBER,                     -- House Number [AD_HSNM1]
    COUNTRY,                         -- Country/Reg. [LAND1]
    REGION,                          -- Region [REGIO]
    BPTAXTYPE,                       -- Category [BPTAXTYPE]
    BPTAXNUMBER,                     -- Tax Number [BPTAXNUM]
    ACADEMICTITLE,                   -- Academic Title [AD_TITLE1]
    ACADEMICTITLENAME,               -- Academic Title [AD_TITLE1T]
    LASTNAMEPREFIX,                  -- Prefix Key [AD_PREFIX]
    CORRESPONDENCELANGUAGE,          -- Correspondence lang. [BU_LANGU_CORR]
    MOBILEPHONENUMBER,               -- Mobile Phone [AD_MBNMBR1]
    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, INSURCLMBUSINESSPARTNER, DRAFTUUID)
);