FARP_MIV_IVINF

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.

-- manage ap/ar invoice head info
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARP_MIV_IVINF (
    MANDT,                           -- Client [mandt]
    OUTGOINGINVOICEUUID,             -- Upload Invoice UUID [farp_miv_uploadinvoiceuuid]
    ACCOUNTINGDOCUMENT,              -- Inv. Doc. No. [re_belnr]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr]
    COMPANYCODE,                     -- Company Code [bukrs]
    DOCUMENTREFERENCEID,             -- Reference [xblnr1]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [bktxt]
    TOTALAMOUNTINTRANSACTIONCRCY,    -- Gross Inv. Amnt [fap_recurr_dmbtr_cs]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    CUSTOMER,                        -- Customer [kunnr]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fis_rwcur]
    ASSIGNMENTREFERENCE,             -- Assignment [farp_miv_zuonr]
    SUPPLIERBANKTYPE,                -- Partner Bank Type [farp_miv_bvtyp]
    IBAN,                            -- IBAN [iban]
    SWIFTCODE,                       -- SWIFT/BIC [swift]
    PAYMENTTERMS,                    -- Pyt Terms [dzterm]
    PAYMENTMETHOD,                   -- Pymt Meth. [dzlsch]
    PAYMENTREFERENCE,                -- Payment Ref. [kidno]
    CASHDISCOUNT1DAYS,               -- Cash Discount Days 1 [farp_miv_dzbd1t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [farp_miv_dzbd1p]
    CASHDISCOUNT2DAYS,               -- Cash Discount Days 2 [farp_miv_dzbd2t]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [farp_miv_dzbd2p]
    NETPAYMENTDAYS,                  -- Net Pmt Terms Period [farp_miv_dzbd3t]
    HOUSEBANK,                       -- House Bank [hbkid]
    HOUSEBANKACCOUNT,                -- Account ID [hktid]
    MANUALCASHDISCOUNT,              -- Amount in LC [dmbtr]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [uzawe]
    SUPLRINVCPAYMENTBLOCKINGREASON,  -- Pmnt block [dzlspr]
    TAXDETERMINATIONDATE,            -- Tax Date [txdat]
    OUTGOINGINVOICESTATUS,           -- Status [farp_miv_status]
    POSTINGDATE,                     -- Posting Date [budat]
    INVOICEDATE,                     -- Run On [laufd]
    CREATEDBYUSER,                   -- Created By [ernam]
    USERNAME,                        -- Created By [fac_rjet_recurrence_entered]
    CREATIONDATETIME,                -- Created On [fap_creationdatetime]
    LASTCHANGEDBYUSER,               -- Last Changed By [fap_lastchgby]
    LASTCHANGEDATETIME,              -- Last Changed On [fap_lastchangedatetime]
    SUPPLIERINVOICETRANSACTIONTYPE,  -- Transaction [inv_tran]
    ACCOUNTINGDOCUMENTTYPE,          -- Document Type [farp_recurr_blart]
    PAYMENTBLOCKINGREASON,           -- Payment Block [dzahls]
    DUECALCULATIONBASEDATE,          -- Baseline Date [farp_miv_dzfbdt]
    CASHDISCOUNTAMOUNT,              -- Cash Discount Amount [fis_wskto]
    ELIGIBLEAMOUNTFORCSHDISCINTC,    -- Cash Discount Base [farp_miv_skfbt]
    INVOICEREFERENCE,                -- Invoice Reference [fis_rebzg]
    INVOICEITEMREFERENCE,            -- Invoice Item Reference [fis_rebzz]
    DATAEXCHANGEINSTRUCTION1,        -- Instruction 1 [farp_dtat16]
    DATAEXCHANGEINSTRUCTION2,        -- Instruction 2 [farp_dtat17]
    DATAEXCHANGEINSTRUCTION3,        -- Instruction 3 [farp_dtat18]
    DATAEXCHANGEINSTRUCTION4,        -- Instruction 4 [farp_dtat19]
    PAYMENTDIFFERENCEREASON,         -- Reason Code [farp_rstgr]
    FIXEDCASHDISCOUNT,               -- Fixed [dzbfix]
    DOCUMENTITEMTEXT,                -- Text [sgtxt]
    BUSINESSAREA,                    -- Business Area [gsber]
    PARTNERBUSINESSAREA,             -- Partner Bus. Area [fis_pargb]
    TREASURYCONTRACT,                -- Contract Number [ranl]
    TREASURYCONTRACTTYPE,            -- Contract Type [rantyp]
    REFERENCE1IDBYBUSINESSPARTNER,   -- Reference Key 1 [farp_xref1]
    REFERENCE2IDBYBUSINESSPARTNER,   -- Reference Key 2 [farp_xref2]
    REFERENCE3IDBYBUSINESSPARTNER,   -- Reference Key 3 [farp_xref3]
    STATECENTRALBANKPAYMENTREASON,   -- SCB Ind. [lzbkz]
    SUPPLYINGCOUNTRY,                -- Supply C/R [landl]
    RECRRGSUPLRINVCISSRVCINVOICE,    -- Service Ind. [diekz]
    FINTRANSFLOWTYPE,                -- Flow Type [tb_sfhazba]
    CREDITCONTROLAREA,               -- Credit Control Area [farp_kkber]
    COMPANYCODECOUNTRY,              -- Reporting C/R [egmld_bsez]
    ISEUTRIANGULARDEAL,              -- EU Triang. Deal [xegdr]
    PLANNINGLEVEL,                   -- Planning Level [fdlev]
    PLANNINGDATE,                    -- Planning Date [farp_miv_plan_date]
    ISNEGATIVEPOSTING,               -- Negative Posting [farp_xnegp]
    TAXAMOUNTINTRANSCRCY,            -- Tax Amount [wmwst_shl]
    TAXCODE,                         -- Tax Code [mwskz]
    TAXREPORTINGDATE,                -- Tax Reporting Date [vatdate]
    TAXFULFILLMENTDATE,              -- Tax Fulfill. Date [fot_fulfilldate]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    EXCHANGERATE,                    -- Exchange Rate [fis_exchange_rate]
    RAITEMTRANSLATIONDATE,           -- Translatn Date [wwert_d]
    BUSINESSPLACE,                   -- Business Place [farp_bupla]
    BUSINESSSECTIONCODE,             -- Section Code [secco]
    BRANCH,                          -- Branch number [j_1abrnch]
    INVOICEREFERENCEFISCALYEAR,      -- Invoice Reference Fiscal Year [fis_rebzj]
    RECONCILIATIONACCOUNT,           -- Recon. Account [farp_akont]
    CREATIONDATE,                    -- Created On [farp_recurr_cpdat]
    FINPLANAPPLICATIONLOGHANDLE,     -- Handle [balloghndl]
    APPLICATIONLOGHANDLE,            -- Handle [balloghndl]
    EVENTHANDLERTYPEDESCRIPTION,     -- Formula [farr_formula]
    SITNTYPEDESCRIPTION,             -- Formula [farr_formula]
    UPLOADBATCHUUID,                 -- Upload Batch UUID [farp_miv_uploadbatchuuid]
    DOCUMENTSEQUENCENO,              -- Doc. Sequence Number [farp_miv_doc_seq_no]
    ONETIMEACCOUNTBPSALUTATIONTEXT,  -- Title [anred]
    LANGUAGE,                        -- Language [spras]
    BUSINESSPARTNERNAME1,            -- Name [ad_name1]
    BUSINESSPARTNERNAME2,            -- Name 2 [ad_name2]
    BUSINESSPARTNERNAME3,            -- Name 3 [ad_name3]
    BUSINESSPARTNERNAME4,            -- Name 4 [ad_name4]
    STREETNAME,                      -- Street [stras_gp]
    CITYNAME,                        -- City [ort01_gp]
    POSTALCODE,                      -- Postal Code [pstlz]
    POBOX,                           -- PO Box [pfach]
    POBOXISWITHOUTNUMBER,            -- PO Box w/o No. [ad_pobxnum]
    POBOXPOSTALCODE,                 -- PO Box Postal Code [fis_ad_pstcd2]
    COUNTRY,                         -- Country/Region Key [land1_gp]
    REGION,                          -- Region [regio]
    EMAILADDRESS,                    -- E-Mail Address [ad_smtpadr]
    BANKCOUNTRY,                     -- Bank Ctry/Reg. [banks]
    BANKINTERNALID,                  -- Bank Key [bankk]
    BANKACCOUNT,                     -- Bank Account [bankn]
    BANKREFERENCE,                   -- Bank Reference [refbk]
    BANKCONTROLKEY,                  -- Control Key [bkont]
    PAYMENTSYSTEM,                   -- Payment System [payment_system_id]
    ALIASTYPE,                       -- Alias Type [alias_type_id]
    BPBANKACCOUNTALIASNAME,          -- Bank Account Alias [bu_bank_alias]
    ISVATLIABLE,                     -- Liable for VAT [stkzu]
    ACCOUNTTAXTYPE,                  -- Tax Type [j_1afitp_d]
    TAXNUMBERTYPE,                   -- Tax number type [j_1atoid]
    TAXID1,                          -- Tax Number 1 [stcd1]
    TAXID2,                          -- Tax Number 2 [stcd2]
    TAXID3,                          -- Tax Number 3 [stcd3]
    TAXID4,                          -- Tax Number 4 [stcd4]
    TAXID5,                          -- Tax Number 5 [stcd5]
    VATREGISTRATION,                 -- VAT Registration No. [farp_stceg]
    ISNATURALPERSON,                 -- Natural person [stkzn]
    ONETMEACCTISEQUALIZATIONTXSUBJ,  -- Equalizatn tax [stkza]
    BUSINESSTYPE,                    -- Type of Business [gestyp]
    INDUSTRYTYPE,                    -- Type of Industry [indtyp]
    REPRESENTATIVENAME,              -- Rep's Name [repres]
    DATAEXCHANGEINSTRUCTIONKEY,      -- Instruction [farp_dtaws]
    DATAMEDIUMEXCHANGEINDICATOR,     -- DME Rec. Code [dtams]
    ALTERNATIVEPAYEEISALLOWED,       -- Payee in doc. [xzemp]
    ISONETIMEACCOUNT,                -- One-time acct [xcpdk]
    ADDRESSANDBANKISSETMANUALLY,     -- Address and Bank is Set Manually [farp_xcpdd]
    JRNLENTRYCNTRYSPECIFICREF1,      -- Country/Region Specific Reference 1 [fac_glo_ref1_hd]
    JRNLENTRYCNTRYSPECIFICDATE1,     -- Country/Region Specific Date 1 [fac_glo_dat1_hd]
    JRNLENTRYCNTRYSPECIFICREF2,      -- Country/Region Specific Reference 2 [fac_glo_ref2_hd]
    JRNLENTRYCNTRYSPECIFICDATE2,     -- Country/Region Specific Date 2 [fac_glo_dat2_hd]
    JRNLENTRYCNTRYSPECIFICREF3,      -- Country/Region Specific Reference 3 [fac_glo_ref3_hd]
    JRNLENTRYCNTRYSPECIFICDATE3,     -- Country/Region Specific Date 3 [fac_glo_dat3_hd]
    JRNLENTRYCNTRYSPECIFICREF4,      -- Country/Region Specific Reference 4 [fac_glo_ref4_hd]
    JRNLENTRYCNTRYSPECIFICDATE4,     -- Country/Region Specific Date 4 [fac_glo_dat4_hd]
    JRNLENTRYCNTRYSPECIFICREF5,      -- Country/Region Specific Reference 5 [fac_glo_ref5_hd]
    JRNLENTRYCNTRYSPECIFICDATE5,     -- Country/Region Specific Date 5 [fac_glo_dat5_hd]
    JRNLENTRYCNTRYSPECIFICBP1,       -- Ctry/Reg. Specific Business Partner 1 [fac_glo_bp1_hd]
    JRNLENTRYCNTRYSPECIFICBP2,       -- Ctry/Reg. Specific Business Partner 2 [fac_glo_bp2_hd]
    PRIMARY KEY (MANDT, OUTGOINGINVOICEUUID)
);