FAP_RSIV_TMPLR

Transparent Table Application Table
92 Fields 3 CDS Views

template of recurring supplier invoices

FAP_RSIV_TMPLR is an SAP database table in S/4HANA. template of recurring supplier invoices. It contains 92 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_RecurringSupplierInvoiceItem view from BASIC Number of posted Invoices
P_RecrrgSuplrInvcTmplInBatch view from BASIC
R_RecrrgSuplrInvcTmplTP view_entity from TRANSACTIONAL template of recurring supplier invoice

Fields (92)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY recrrgsuplrinvctmpluuid FAP_RSIV_GUID GUID
recrrgsupplierinvoicetemplate FAP_RSIV_DOCNO Document Number
fiscalyear FIS_GJAHR Fiscal Year
accountingdocumenttype FARP_RECURR_BLART Document Type
companycode BUKRS Company Code
documentreferenceid XBLNR1 Reference
accountingdocumentheadertext BKTXT Doc.Header Text
totalamountintransactioncrcy FAP_RECURR_DMBTR_CS Gross Inv. Amnt
invoicingparty LIFRE Invoicing Party
exchangerate UKURS_CURR Exchange Rate
grossamtintc JV_GRSAMT_TC Gross Amt in Trans Crcy
totalamountinlocalcurrency DMBTR_SHL Amount in LC
localcurrency FC_CURR Local Currency
transactioncurrency FIS_RWCUR Transaction Currency
documentcurrency /SCMTMS/DOC_CURRENCY Document Currency
transactiondate FQM_TRANSACTION_DATE Transaction Date
assignmentreference FAP_RECURR_FIS_ZUONR Assignment
supplierbanktype BVTYP Part.bank type
iban IBAN IBAN
swiftcode SWIFT SWIFT/BIC
businessarea GSBER Business Area
companycodecountry GLO_COUNTRY Reporting Ctry/Reg.
suppliervatregistration STCEG VAT Reg. No.
iseutriangulardeal XEGDR EU Triang. Deal
documentitemtext SGTXT Text
createdbyuser ERFNAM Entered By
username FAC_RJET_RECURRENCE_ENTERED Created By
creationdate FARP_RECURR_CPDAT Created On
recrrgsuplrinvcissrvcinvoice DIEKZ Service Ind.
statecentralbankpaymentreason LZBKZ SCB Ind.
supplyingcountry FAC_LANDL Supplying Ctry/Reg.
activecountry LANDL Supply C/R
paymentterms DZTERM Pyt Terms
paymentmethod DZLSCH Pymt Meth.
paymentreference KIDNO Payment Ref.
cashdiscount1days DZBD1T Days 1
cashdiscount1percent DZBD1P CD Percentage 1
cashdiscount2days DZBD2T Days 2
cashdiscount2percent DZBD2P CD Percentage 2
netpaymentdays DZBD3T Days Net
housebank HBKID House Bank
housebankaccount HKTID Account ID
manualcashdiscount DMBTR Amount in LC
invoicereference AWREF_REB InR.Ref.no.
paymentmethodsupplement UZAWE Pmnt Meth. Sup.
suplrinvcpaymentblockingreason DZLSPR Pmnt block
paytslipwthrefcheckdigit FARP_ESRPZ Check Digit
paytslipwthrefreference FARP_ESRRE POR Reference
paytslipwthrefsubscriber FARP_ESRNR PBC/POR Number
taxcode MWSKZ_MRM1 Tax Code
fixedcashdiscount DZBFIX Fixed
taxbaseamountintranscrcy FWSTEV Value-Added Tax
taxdeterminationdate TXDAT Tax Date
taxjurisdictionbyprovider TXJCD Tax Jur.
taxcountry FOT_TAX_COUNTRY Tax Ctry/Reg.
withholdingtaxisenabled FAP_RSIV_WHGDTAX_FLAG Indicator
glaccount HKONT G/L Acct
startdate FAC_RJET_START_OCCUR_DATE Recurrence StartDate
calendarday FAC_RJET_DAY_OF_MONTH Occur Day in a Month
weekday FAC_RJET_DAY_OF_WEEK Occur Day in a Week
firstoccurrencedate FAC_RJET_FIRST_OCCUR_DATE Start Date
nextoccurrencedate DBATR Next Run
estdcostcostgrunrcrrcdate CK_REC_DAT Start Date
nextoccurrenceamountintc DMBTR Amount in LC
recurrencetype FAC_RJET_RECURRENCE_PATTERN Recurrence Pattern
recurrencepattern FAC_RJET_RECURRENCE_PATTERN Recurrence Pattern
recurrencefrequency FAC_RJET_RECURR_DAY_FREQUENCY Interval in Days
restartfrequencyweek FAC_RJET_RECURR_WEK_FREQUENCY Interval in Weeks
refrequencystart FAC_RJET_RECURR_MON_FREQUENCY Interval in Months
ehstaskrecurrenceinterval FAC_RJET_INTERVAL By
recurrenceinterval FAC_RJET_INTERVAL By
recurrencefrequencyinmonth FAC_RJET_RECURR_MON_FREQUENCY Interval in Months
recurrencefrequencyinweek FAC_RJET_RECURR_WEK_FREQUENCY Interval in Weeks
recurrencefrequencyinday FAC_RJET_RECURR_DAY_FREQUENCY Interval in Days
occurrencetype FAC_RJET_OCCUR_DAY_TYPE On
occurrencedaybyrecurrencetype FAC_RJET_OCCUR_DAY Occurrence Day
recurrenceendtype FAC_RJET_RECURR_END_BY_TYPE End Recurrence By
numberofoccurrences FAC_RJET_REC_NUMBER_OF_OCCUR Number of Occurrence
numberofpostedinvoices FAC_RJET_REC_NUMBER_OF_OCCUR Number of Occurrence
numberofnotpostedinvoices FAC_RJET_REC_NUMBER_OF_OCCUR Number of Occurrence
lastoccurrencedate FAC_RJET_LAST_OCCUR_DATE End Date
foreigncrcyamtcnvrsnrule FAC_RJET_TRANS_LC_AMTS Conversion Rule
recrrgsuplrinvctemplatestatus FAP_TMPL_STATUS Template Status
businessplace FARP_BUPLA Business Place
businesssectioncode SECCO Section Code
in_gstpartner J_1IG_PARTNER GST Partner
in_gstplaceofsupply J_1IG_REGION Place of Supply
in_invoicereferencenumber J_1IG_IRN Invoice Ref. Number
settlmtcocodetaxcountry WLF_LANDTX_BUKRS Tax Ctry/Reg. CoCode
lastchangedat TIMESTAMPL Time Stamp
lastchangedatetime VDM_LASTCHANGEDON Last Changed On

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]
    LASTCHANGEDAT,                   -- Time Stamp [TIMESTAMPL]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    PRIMARY KEY (MANDT, RECRRGSUPLRINVCTMPLUUID)
);

Learn More