FARP_POST_HDR_D

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_FINPOSTINGCLEARINGHEADERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARP_POST_HDR_D (
    MANDT,                           -- Client [mandt]
    POSTINGCLEARINGDOCUMENTUUID,     -- RAW16 [fdc_dft_key]
    COMPANYCODE,                     -- Company Code [fis_bukrs]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr_no_conv]
    ACCOUNTINGDOCUMENT,              -- Journal Entry [farp_belnr_d]
    POSTINGCLEARINGDOCDRAFTTYPE,     -- fis_post_clear_doc_draft_type
    COMPANYCODEFOREDIT,              -- Company Code [fis_bukrs]
    FISCALYEARFOREDIT,               -- Fiscal Year [fis_gjahr_no_conv]
    ACCOUNTINGDOCUMENTFOREDIT,       -- Journal Entry [farp_belnr_d]
    ACCOUNTINGDOCUMENTTYPE,          -- Journal Entry Type [farp_blart]
    DOCUMENTDATE,                    -- Journal Entry Date [fis_bldat]
    POSTINGDATE,                     -- Posting Date [fis_budat]
    POSTINGFISCALPERIOD,             -- Period [monat]
    JOURNALENTRYCREATIONDATE,        -- Entered On [farp_cpudt]
    JOURNALENTRYCREATIONTIME,        -- Creation Time [ttet_dt_cr_time]
    EXCHANGERATEDATE,                -- Exchange Rate Date [vdm_v_exchange_rate_date]
    ACCOUNTINGDOCCREATEDBYUSER,      -- Journal Entry Created By [fis_usnam]
    TRANSACTIONCODE,                 -- Transaction Code [tcode]
    DOCUMENTREFERENCEID,             -- Document Reference ID [fis_xblnr1]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [bktxt]
    TRANSACTIONCURRENCY,             -- Currency [waers]
    ABSOLUTEEXCHANGERATE,            -- Absolute Exchange Rate [fis_absolute_exchangerate]
    EXCHRATEISINDIRECTQUOTATION,     -- Exchange Rate Is Indirect Quotation [fis_indirect_quotation]
    BUSINESSTRANSACTIONTYPE,         -- Bus. Trans. Category [fins_bttype]
    REFERENCEDOCUMENTTYPE,           -- Reference Document Type [fis_awtyp]
    COMPANYCODECURRENCY,             -- Company Code Currency [fis_hwaer]
    ADDITIONALCURRENCY1,             -- Additional Crcy 1 [fis_hwae2]
    TAXISCALCULATEDAUTOMATICALLY,    -- Tax Is Automatically Calculated [fis_xmwst]
    TAXBASEAMOUNTISNETAMOUNT,        -- Tax Base Amount is Net Amount [fis_xmwsn]
    BRANCH,                          -- Branch [fis_j_1abrnch]
    NMBROFPAGES,                     -- Number of Pages [j_1anopg]
    LEDGER,                          -- Ledger [fis_rldnr]
    EXCHANGERATETYPE,                -- Exch. Rate Type [kurst]
    JOURNALENTRYLASTCHANGEDATETIME,  -- Journal Entry Last Change Date Time [fis_je_lastchange_datetime]
    POSTINGCLEARINGSESSIONID,        -- Temp. Document ID [fdc_accdoc_tmp_doc_id]
    POSTINGCLEARINGSESSIONCRTNDATE,  -- Date [dats]
    POSTINGCLEARINGSESSIONCRTNTIME,  -- Field of type TIMS [tims]
    PAYMENTRUNIDENTIFICATION,        -- Identification [laufi]
    POSTINGCLEARINGDATAENTRYSTATUS,  -- Data Entry Status [fdc_data_entry_status_code]
    POSTINGCLEARINGHDRFLDSTSVAL,     -- Text (200 char) [char200]
    POSTINGCLEARINGHDRMNLENTRVAL,    -- c [char50]
    POSTINGCLEARINGWRNGISREPORTED,   -- Truth Value [abap_boolean]
    PRIMARY KEY (MANDT, POSTINGCLEARINGDOCUMENTUUID, COMPANYCODE, FISCALYEAR, ACCOUNTINGDOCUMENT, POSTINGCLEARINGDOCDRAFTTYPE)
);