FINIJU_POLICY_D

Transparent Table Application Table
27 Fields 2 CDS Views

Draft table for entity R_JOURNALCASEPOSTINGPOLICYTP

FINIJU_POLICY_D is an SAP database table in S/4HANA. Draft table for entity R_JOURNALCASEPOSTINGPOLICYTP. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JournalCasePostingPolicyD view_entity from EXTENSION Journal Case Posting Policy - Extension
R_JournalCasePostingPolicyDrft view_entity from BASIC Journal Case Posting Policy - Draft

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY journalcasepolicyuuid SYSUUID_X16 UUID
journalcasepolicy PDOC_ID Policy ID
journalcasepolicyversion POLICY_VERSION Version
journalcasecategory CASE_CAT Category Code
journalcasesubcategory CASE_SUBCAT Subcategory Code
journalcasepolicyname POLICY_DESC Description
journalcasepolicystatus POLICY_LIFECYCLE_STATUS Life Cycle Status
jrnlcasepolicyextractionstatus POLICY_EXTRACTION_STATUS Extraction Status
jrnlcaseplcyactnmappingstatus POLICY_ACTIONMAPPING_STATUS Action Status
validitystartdate FINIJU_DATEFROM Valid From
validityenddate FINIJU_DATETO Valid To
jrnlcaseplcyattchcontentbinary FINIJU_ATTACHMENT Attachment
mimetype FINIJU_MIME_TYPE Mime Type
jrnlcaseplcyattachmentfilename FINIJU_FILENAME File Name
createdbyuser ABP_CREATION_USER Created By
creationdatetime ABP_CREATION_TSTMPL Created On
lastchangebyuser ABP_LOCINST_LASTCHANGE_USER Changed By
locallastchangedatetime ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
lastchangedatetime ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
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
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.

-- Draft table for entity R_JOURNALCASEPOSTINGPOLICYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINIJU_POLICY_D (
    MANDT,                           -- Client [MANDT]
    JOURNALCASEPOLICYUUID,           -- UUID [SYSUUID_X16]
    JOURNALCASEPOLICY,               -- Policy ID [PDOC_ID]
    JOURNALCASEPOLICYVERSION,        -- Version [POLICY_VERSION]
    JOURNALCASECATEGORY,             -- Category Code [CASE_CAT]
    JOURNALCASESUBCATEGORY,          -- Subcategory Code [CASE_SUBCAT]
    JOURNALCASEPOLICYNAME,           -- Description [POLICY_DESC]
    JOURNALCASEPOLICYSTATUS,         -- Life Cycle Status [POLICY_LIFECYCLE_STATUS]
    JRNLCASEPOLICYEXTRACTIONSTATUS,  -- Extraction Status [POLICY_EXTRACTION_STATUS]
    JRNLCASEPLCYACTNMAPPINGSTATUS,   -- Action Status [POLICY_ACTIONMAPPING_STATUS]
    VALIDITYSTARTDATE,               -- Valid From [FINIJU_DATEFROM]
    VALIDITYENDDATE,                 -- Valid To [FINIJU_DATETO]
    JRNLCASEPLCYATTCHCONTENTBINARY,  -- Attachment [FINIJU_ATTACHMENT]
    MIMETYPE,                        -- Mime Type [FINIJU_MIME_TYPE]
    JRNLCASEPLCYATTACHMENTFILENAME,  -- File Name [FINIJU_FILENAME]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEBYUSER,                -- Changed By [ABP_LOCINST_LASTCHANGE_USER]
    LOCALLASTCHANGEDATETIME,         -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    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]
    DUMMY_JRNL_POLICY_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, JOURNALCASEPOLICYUUID)
);

Learn More