FINIJU_POLICY

Transparent Table Application Table
21 Fields 2 CDS Views

Policy

FINIJU_POLICY is an SAP database table in S/4HANA. Policy. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JournalCasePostingPolicy view_entity from EXTENSION Manage Journal Policy - Extension
I_JournalCasePostingPolicy view_entity from BASIC Jrnl Case Posting Policy Basic

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pdoc_uuid SYSUUID_X16 UUID
pdocid PDOC_ID Policy ID
versionid POLICY_VERSION Version
case_cat CASE_CAT Category Code
case_subcat CASE_SUBCAT Subcategory Code
policy_desc POLICY_DESC Description
jrnl_pst_tmpl_cd JRNL_POSTG_TMPL_CODE Jrnl Postg Tmpl Code
lifecyclestatus POLICY_LIFECYCLE_STATUS Life Cycle Status
extractionstatus POLICY_EXTRACTION_STATUS Extraction Status
actionmappingstatus POLICY_ACTIONMAPPING_STATUS Action Status
datefrom FINIJU_DATEFROM Valid From
dateto FINIJU_DATETO Valid To
attachment FINIJU_ATTACHMENT Attachment
mimetype FINIJU_MIME_TYPE Mime Type
filename FINIJU_FILENAME File Name
createdby ABP_CREATION_USER Created By
createdon ABP_CREATION_TSTMPL Created On
changedby ABP_LOCINST_LASTCHANGE_USER Changed By
changedon ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
dummy_jrnl_policy_incl_eew_ps CFD_DUMMY Dummy

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.

-- Policy
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINIJU_POLICY (
    MANDT,                          -- Client [MANDT]
    PDOC_UUID,                      -- UUID [SYSUUID_X16]
    PDOCID,                         -- Policy ID [PDOC_ID]
    VERSIONID,                      -- Version [POLICY_VERSION]
    CASE_CAT,                       -- Category Code [CASE_CAT]
    CASE_SUBCAT,                    -- Subcategory Code [CASE_SUBCAT]
    POLICY_DESC,                    -- Description [POLICY_DESC]
    JRNL_PST_TMPL_CD,               -- Jrnl Postg Tmpl Code [JRNL_POSTG_TMPL_CODE]
    LIFECYCLESTATUS,                -- Life Cycle Status [POLICY_LIFECYCLE_STATUS]
    EXTRACTIONSTATUS,               -- Extraction Status [POLICY_EXTRACTION_STATUS]
    ACTIONMAPPINGSTATUS,            -- Action Status [POLICY_ACTIONMAPPING_STATUS]
    DATEFROM,                       -- Valid From [FINIJU_DATEFROM]
    DATETO,                         -- Valid To [FINIJU_DATETO]
    ATTACHMENT,                     -- Attachment [FINIJU_ATTACHMENT]
    MIMETYPE,                       -- Mime Type [FINIJU_MIME_TYPE]
    FILENAME,                       -- File Name [FINIJU_FILENAME]
    CREATEDBY,                      -- Created By [ABP_CREATION_USER]
    CREATEDON,                      -- Created On [ABP_CREATION_TSTMPL]
    CHANGEDBY,                      -- Changed By [ABP_LOCINST_LASTCHANGE_USER]
    CHANGEDON,                      -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    DUMMY_JRNL_POLICY_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PDOC_UUID)
);

Learn More