FAP_RSIV_TMPLR

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.

-- template of recurring supplier invoices
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAP_RSIV_TMPLR (
    MANDT,                           -- Client [mandt]
    RECRRGSUPLRINVCTMPLUUID,         -- GUID [fap_rsiv_guid]
    RECRRGSUPPLIERINVOICETEMPLATE,   -- Document Number [fap_rsiv_docno]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr]
    ACCOUNTINGDOCUMENTTYPE,          -- Document Type [farp_recurr_blart]
    COMPANYCODE,                     -- Company Code [bukrs]
    DOCUMENTREFERENCEID,             -- Reference [xblnr1]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [bktxt]
    TOTALAMOUNTINTRANSACTIONCRCY,    -- Gross Inv. Amnt [fap_recurr_dmbtr_cs]
    INVOICINGPARTY,                  -- Invoicing Party [lifre]
    EXCHANGERATE,                    -- Exchange Rate [ukurs_curr]
    GROSSAMTINTC,                    -- Gross Amt in Trans Crcy [jv_grsamt_tc]
    TOTALAMOUNTINLOCALCURRENCY,      -- Amount in LC [dmbtr_shl]
    LOCALCURRENCY,                   -- Local Currency [fc_curr]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fis_rwcur]
    DOCUMENTCURRENCY,                -- Document Currency [/scmtms/doc_currency]
    TRANSACTIONDATE,                 -- Transaction Date [fqm_transaction_date]
    ASSIGNMENTREFERENCE,             -- Assignment [fap_recurr_fis_zuonr]
    SUPPLIERBANKTYPE,                -- Part.bank type [bvtyp]
    IBAN,                            -- IBAN [iban]
    SWIFTCODE,                       -- SWIFT/BIC [swift]
    BUSINESSAREA,                    -- Business Area [gsber]
    COMPANYCODECOUNTRY,              -- Reporting Ctry/Reg. [glo_country]
    SUPPLIERVATREGISTRATION,         -- VAT Reg. No. [stceg]
    ISEUTRIANGULARDEAL,              -- EU Triang. Deal [xegdr]
    DOCUMENTITEMTEXT,                -- Text [sgtxt]
    CREATEDBYUSER,                   -- Entered By [erfnam]
    USERNAME,                        -- Created By [fac_rjet_recurrence_entered]
    CREATIONDATE,                    -- Created On [farp_recurr_cpdat]
    RECRRGSUPLRINVCISSRVCINVOICE,    -- Service Ind. [diekz]
    STATECENTRALBANKPAYMENTREASON,   -- SCB Ind. [lzbkz]
    SUPPLYINGCOUNTRY,                -- Supplying Ctry/Reg. [fac_landl]
    ACTIVECOUNTRY,                   -- Supply C/R [landl]
    PAYMENTTERMS,                    -- Pyt Terms [dzterm]
    PAYMENTMETHOD,                   -- Pymt Meth. [dzlsch]
    PAYMENTREFERENCE,                -- Payment Ref. [kidno]
    CASHDISCOUNT1DAYS,               -- Days 1 [dzbd1t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2DAYS,               -- Days 2 [dzbd2t]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [dzbd2p]
    NETPAYMENTDAYS,                  -- Days Net [dzbd3t]
    HOUSEBANK,                       -- House Bank [hbkid]
    HOUSEBANKACCOUNT,                -- Account ID [hktid]
    MANUALCASHDISCOUNT,              -- Amount in LC [dmbtr]
    INVOICEREFERENCE,                -- InR.Ref.no. [awref_reb]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [uzawe]
    SUPLRINVCPAYMENTBLOCKINGREASON,  -- Pmnt block [dzlspr]
    PAYTSLIPWTHREFCHECKDIGIT,        -- Check Digit [farp_esrpz]
    PAYTSLIPWTHREFREFERENCE,         -- POR Reference [farp_esrre]
    PAYTSLIPWTHREFSUBSCRIBER,        -- PBC/POR Number [farp_esrnr]
    TAXCODE,                         -- Tax Code [mwskz_mrm1]
    FIXEDCASHDISCOUNT,               -- Fixed [dzbfix]
    TAXBASEAMOUNTINTRANSCRCY,        -- Value-Added Tax [fwstev]
    TAXDETERMINATIONDATE,            -- Tax Date [txdat]
    TAXJURISDICTIONBYPROVIDER,       -- Tax Jur. [txjcd]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    WITHHOLDINGTAXISENABLED,         -- Indicator [fap_rsiv_whgdtax_flag]
    GLACCOUNT,                       -- G/L Acct [hkont]
    STARTDATE,                       -- Recurrence StartDate [fac_rjet_start_occur_date]
    CALENDARDAY,                     -- Occur Day in a Month [fac_rjet_day_of_month]
    WEEKDAY,                         -- Occur Day in a Week [fac_rjet_day_of_week]
    FIRSTOCCURRENCEDATE,             -- Start Date [fac_rjet_first_occur_date]
    NEXTOCCURRENCEDATE,              -- Next Run [dbatr]
    ESTDCOSTCOSTGRUNRCRRCDATE,       -- Start Date [ck_rec_dat]
    NEXTOCCURRENCEAMOUNTINTC,        -- Amount in LC [dmbtr]
    RECURRENCETYPE,                  -- Recurrence Pattern [fac_rjet_recurrence_pattern]
    RECURRENCEPATTERN,               -- Recurrence Pattern [fac_rjet_recurrence_pattern]
    RECURRENCEFREQUENCY,             -- Interval in Days [fac_rjet_recurr_day_frequency]
    RESTARTFREQUENCYWEEK,            -- Interval in Weeks [fac_rjet_recurr_wek_frequency]
    REFREQUENCYSTART,                -- Interval in Months [fac_rjet_recurr_mon_frequency]
    EHSTASKRECURRENCEINTERVAL,       -- By [fac_rjet_interval]
    RECURRENCEINTERVAL,              -- By [fac_rjet_interval]
    RECURRENCEFREQUENCYINMONTH,      -- Interval in Months [fac_rjet_recurr_mon_frequency]
    RECURRENCEFREQUENCYINWEEK,       -- Interval in Weeks [fac_rjet_recurr_wek_frequency]
    RECURRENCEFREQUENCYINDAY,        -- Interval in Days [fac_rjet_recurr_day_frequency]
    OCCURRENCETYPE,                  -- On [fac_rjet_occur_day_type]
    OCCURRENCEDAYBYRECURRENCETYPE,   -- Occurrence Day [fac_rjet_occur_day]
    RECURRENCEENDTYPE,               -- End Recurrence By [fac_rjet_recurr_end_by_type]
    NUMBEROFOCCURRENCES,             -- Number of Occurrence [fac_rjet_rec_number_of_occur]
    NUMBEROFPOSTEDINVOICES,          -- Number of Occurrence [fac_rjet_rec_number_of_occur]
    NUMBEROFNOTPOSTEDINVOICES,       -- Number of Occurrence [fac_rjet_rec_number_of_occur]
    LASTOCCURRENCEDATE,              -- End Date [fac_rjet_last_occur_date]
    FOREIGNCRCYAMTCNVRSNRULE,        -- Conversion Rule [fac_rjet_trans_lc_amts]
    RECRRGSUPLRINVCTEMPLATESTATUS,   -- Template Status [fap_tmpl_status]
    BUSINESSPLACE,                   -- Business Place [farp_bupla]
    BUSINESSSECTIONCODE,             -- Section Code [secco]
    IN_GSTPARTNER,                   -- GST Partner [j_1ig_partner]
    IN_GSTPLACEOFSUPPLY,             -- Place of Supply [j_1ig_region]
    IN_INVOICEREFERENCENUMBER,       -- Invoice Ref. Number [j_1ig_irn]
    SETTLMTCOCODETAXCOUNTRY,         -- Tax Ctry/Reg. CoCode [wlf_landtx_bukrs]
    QUICKRESPONSEIBAN,               -- QR-IBAN [qriban]
    ONETIMEACCTCNTRYSPECIFICREF1,    -- Country/Region Specific Reference 1 [fac_glo_ref1_ot]
    REFERENCEACCOUNTFORIBAN,         -- Ref. Account [fota_ref_account_for_iban]
    LASTCHANGEDAT,                   -- Time Stamp [timestampl]
    LASTCHANGEDATETIME,              -- Last Changed On [vdm_lastchangedon]
    PRIMARY KEY (MANDT, RECRRGSUPLRINVCTMPLUUID)
);