/PM0/ABDRTAXJOUR

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_INSURANCEPOLICYTAXJOURNALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PM0/ABDRTAXJOUR (
    MANDT,                           -- Client [MANDT]
    INSURPLCYUUID,                   -- Policy UUID [/PM0/VDM_POLICY_UUID]
    INSURPLCYAPPLUUID,               -- Application UUID [/PM0/VDM_APPLICATION_UUID]
    INSURPLCYINSURCONTR,             -- Contract Key [/PM0/ABD_POLPR_ID]
    INSURPLCYCOVERAGEPACKAGEID,      -- Cov.Package ID [/PM0/ABD_COVPAC_ID]
    INSURPLCYCOVERAGEID,             -- Coverage Key [/PM0/ABD_COVERAGE_ID]
    INSURPLCYTAXJOURNALID,           -- Tax Journal [/PM0/ABD_TAXJOUR_ID]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    INSURPLCYORDERNUMBER,            -- Sequence Number [/PM0/ABJ_ORDERNO_ID]
    INSURPLCYBUSPROCTYPE,            -- Bus. Process [/PM0/ABU_BIZPRC_ID]
    INSURPLCYBUSPROCESSNUMERATOR,    -- Bus. Proc. No. [/PM0/ABJ_BIZPRCNO_ID]
    INSURPLCYJRNLENDNMBR,            -- Term. Jour. No. [/PM0/ABJ_JOURNALENDNO_ID]
    INSURPLCYJRNLNMBR,               -- Journal Number [/PM0/VDM_JOURNAL_NUMBER_ID]
    INSURPLCYPRODUCTPACKAGEID,       -- Prod. Pckg. Key [/PM0/ABD_PPDPAC_ID]
    INSURPLCYTAXJRNLISCANCELLED,     -- Rev. Flag [/PM0/ABD_CANCEL_FG]
    INSURPLCYTAXJRNLPROCESSINGDATE,  -- Processing Date [/PM0/ABJ_MOD_DT]
    INSURPLCYTAXJRNLPROCESSOR,       -- Processor [/PM0/ABJ_MODNAME_TT]
    INSURPLCYTAXJRNLPROCGSTEP,       -- Tax Proc. Step [/PM0/ABD_TAXWORKSTEP_CD]
    INSURPLCYTAXJRNLTAXASSMTBASE,    -- Tax Asmnt Basis [/PM0/ABD_TAXBASE_CD]
    INSURPLCYTAXJRNLBASEAMOUNT,      -- Tax Asmt B Amt [/PM0/ABD_TAXBASE_AM]
    INSURPLCYTAXJRNLSTRTDATE,        -- Tax Start Date [/PM0/ABD_TAXBEGIN_DT]
    INSURPLCYTAXJRNLENDDATE,         -- Tax End Date [/PM0/ABD_TAXEND_DT]
    INSURPLCYTAXJRNLRECOGNITION,     -- Tax Recognition [/PM0/ABD_TAXAPPRAISAL_CD]
    INSURPLCYTAXJRNLCALCDBNFTAMT,    -- Calc. Ben. Val. [/PM0/ABD_CALCBNF_AM]
    INSURPLCYTAXJRNLTOTPREMAMT,      -- Premium Total [/PM0/ABD_PREMFACINVEST_AM]
    INSURPLCYTAXJRNLPREMWTHDRWNAMT,  -- Withdrawn Prems [/PM0/ABD_PREMWITHDRAWN_AM]
    INSURPLCYTAXJRNLTAXAMT,          -- Tax Amount [/PM0/ABD_TAXAMOUNT_AM]
    INSURPLCYTAXJRNLCURRENCY,        -- Currency [/PM0/ABD_CURRENCY_ID]
    INSURPLCYTAXJRNLISCHGTAXRECGN,   -- Chg. Tax Recog. [/PM0/ABD_CHANGETAXAPPR_FG]
    INSURPLCYTAXJRNLPREMRATIO,       -- Rat. NP to TP [/PM0/ABD_PREMRATIO_VL]
    INSURPLCYTAXJRNLBASEGRPID,       -- Tax Jour. Entry [/PM0/ABD_TAXBASEGROUP_ID]
    INSURPLCYTAXJRNLISFINISHED,      -- TaxJour.Concluded [/PM0/ABD_TAXJOUR_FINISHED_FG]
    INSURPLCYTAXJRNLCOUNTRY,         -- Country/Reg. [LAND1]
    INSURPLCYTAXJRNLREGION,          -- Region [/PM0/ABD_REGION_CD]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    CUSTOMER_PB_CI,                  -- Single-Character Flag [CHAR1]
    PRIMARY KEY (MANDT, INSURPLCYUUID, INSURPLCYAPPLUUID, INSURPLCYINSURCONTR, INSURPLCYCOVERAGEPACKAGEID, INSURPLCYCOVERAGEID, INSURPLCYTAXJOURNALID, DRAFTUUID)
);