FARP_POST_ITM_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_FINPOSTINGCLEARINGITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARP_POST_ITM_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
    ACCOUNTINGDOCUMENTITEM,          -- Posting View Item [fis_buzei]
    POSTINGCLEARINGDOCUMENTTMPITEM,  -- Position [posnr_acc]
    COMPANYCODEFOREDIT,              -- Company Code [fis_bukrs]
    FISCALYEARFOREDIT,               -- Fiscal Year [fis_gjahr_no_conv]
    ACCOUNTINGDOCUMENTFOREDIT,       -- Journal Entry [farp_belnr_d]
    ACCOUNTINGDOCUMENTITEMFOREDIT,   -- Posting View Item [fis_buzei]
    ACCOUNTINGDOCUMENTITEMTYPE,      -- Line Item ID [buzid]
    CLEARINGDATE,                    -- Clearing Date [fis_augdt]
    CLEARINGCREATIONDATE,            -- Clrg Creation Date [fis_augcp]
    CLEARINGJOURNALENTRYFISCALYEAR,  -- Fiscal Year of Clearing Journal Entry [fis_auggj_no_conv]
    CLEARINGJOURNALENTRY,            -- Clearing Journal Entry [fis_augbl]
    POSTINGKEY,                      -- Posting Key [fis_bschl]
    FINANCIALACCOUNTTYPE,            -- Account Type [farp_koart]
    SPECIALGLCODE,                   -- Special G/L [fac_umskz]
    SPECIALGLTRANSACTIONTYPE,        -- Sp. G/L Trans.Type [farp_umsks]
    DEBITCREDITCODE,                 -- Debit/Credit Code [fis_shkzg]
    TAXCODE,                         -- Tax Code [fis_mwskz]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TAXRATEVALIDITYSTARTDATE,        -- Tax Rate Validity Start Date [fis_txdat_from]
    TRANSACTIONTYPEDETERMINATION,    -- Transaction Key [fac_ktosl]
    ASSIGNMENTREFERENCE,             -- Assignment Reference [fis_zuonr]
    DOCUMENTITEMTEXT,                -- Item Text [farp_sgtxt]
    CONTROLLINGAREA,                 -- Controlling Area [fis_kokrs]
    COSTCENTER,                      -- Cost Center [fis_kostl]
    ORDERID,                         -- Order ID [fis_aufnr]
    SALESDOCUMENT,                   -- Sales Document [vbeln_va]
    SERVICEDOCUMENTTYPE,             -- Service Doc. Type [fco_srvdoc_type]
    SERVICEDOCUMENT,                 -- Service Document [fco_srvdoc_id]
    MASTERFIXEDASSET,                -- Fixed Asset [fis_anln1]
    FIXEDASSET,                      -- Asset Subnumber [fis_anln2]
    OPERATIONALGLACCOUNT,            -- Operational G/L Acct [fis_op_saknr]
    GLACCOUNT,                       -- G/L Account [fis_racct]
    CUSTOMER,                        -- Customer [kunnr]
    SUPPLIER,                        -- Supplier [md_supplier]
    ISBALANCESHEETACCOUNT,           -- Is Balance Sheet Account [fis_xbilk]
    SPECIALGLACCOUNTASSIGNMENT,      -- Special G/L Assignmt [fins_hzuon]
    DUECALCULATIONBASEDATE,          -- Due Calculation Base Date [fis_dzfbdt]
    DUNNINGKEY,                      -- Dunning Key [farp_mschl]
    DUNNINGBLOCKINGREASON,           -- Dunning Blocking Reason [fis_mansp]
    DUNNINGAREA,                     -- Dunning Area [farp_maber]
    VALUATIONAREA,                   -- Valuation Area [bwkey]
    PAYMENTDIFFERENCEREASON,         -- Payment Difference Reason [fis_rstgr]
    PROFITCENTER,                    -- Profit Center [fis_prctr]
    COMPANYCODECURRENCYDETNMETHOD,   -- Co Crcy Detn Meth [fac_hwmet]
    TAXDETERMINATIONDATE,            -- Tx Determination Dte [fis_txdat]
    FUNCTIONALAREA,                  -- Functional Area [fm_farea]
    SEGMENT,                         -- Segment [fb_segment]
    POSTINGDATE,                     -- Posting Date [fis_budat]
    ACCOUNTINGDOCUMENTTYPE,          -- Journal Entry Type [farp_blart]
    NETDUEDATE,                      -- Net Due Date [farp_netdt]
    COMPANYCODECURRENCY,             -- Company Code Currency [fis_hwaer]
    AMOUNTINCOMPANYCODECURRENCY,     -- Amount in Company Code Currency [fis_hsl]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fis_rwcur]
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount in Transaction Currency [fis_wsl]
    BALANCETRANSACTIONCURRENCY,      -- Balance Transaction Currency [fis_rtcur]
    AMOUNTINBALANCETRANSACCRCY,      -- Amount in Balance Transaction Currency [fis_tsl]
    ADDITIONALCURRENCY1,             -- Additional Crcy 1 [fis_hwae2]
    AMOUNTINADDITIONALCURRENCY1,     -- Amount in Additional Currency 1 [fis_dmbe2]
    ADDITIONALCURRENCY2,             -- Additional Crcy 2 [fis_hwae3]
    AMOUNTINADDITIONALCURRENCY2,     -- Amount in Additional Currency 2 [fis_dmbe3]
    POSTINGCLEARINGDATAENTRYSTATUS,  -- Data Entry Status [fdc_data_entry_status_code]
    POSTINGCLEARINGDOCITEMISMAIN,    -- Main Item of a process belonging to Accdoc Header [fdc_mainind]
    POSTINGCLEARINGITMFLDSTSVAL,     -- Text of length 500 [cbo_text500]
    POSTINGCLEARINGITMMNLENTRVAL,    -- Character 100 [char100]
    STATISTICALPOSTINGSTATUS,        -- fis_statistical_posting_status
    PRIMARY KEY (MANDT, POSTINGCLEARINGDOCUMENTUUID, COMPANYCODE, FISCALYEAR, ACCOUNTINGDOCUMENT, POSTINGCLEARINGDOCDRAFTTYPE, ACCOUNTINGDOCUMENTITEM, POSTINGCLEARINGDOCUMENTTMPITEM)
);