FAP_RSIV_GLLINER

Transparent Table Application Table

G/L line items of recurring supplier invoice template

FAP_RSIV_GLLINER is an SAP database table in S/4HANA. G/L line items of recurring supplier invoice template. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RecrrgSuplrInvcTmplItem view_entity from BASIC G/L Items in Recurring Suplr Invc Tmpl
R_RecrrgSuplrInvcTmplItemTP view_entity from TRANSACTIONAL GL items of recurring suplr invc tmpl

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY recrrgsuplrinvctmplitemuuid fap_rsiv_guid GUID
recrrgsuplrinvctmpluuid fap_rsiv_guid GUID
recrrgsuplrinvoicetemplateitem fap_rsiv_item_num Number
glaccount hkont G/L Acct
amountintransactioncurrency fap_recurr_bapiwrbtr_cs Amount
actualamountintransactioncrcy fis_act_wsl Act Amt in Tran Crcy
debitcreditcode shkzg Debit/Credit
isnegativeposting xnegp Negative Postg
companycode bukrs Company Code
taxcode mwskz Tax Code
taxjurisdiction txjcd Tax Jur.
documentitemtext sgtxt Text
costcenter kostl Cost Center
salesorder vbeln SD Document
salesorderitem vbelp Sales doc. item
internalorder fins_int_aufnr Internal Order
settlementreferencedate farp_dabrbez Reference Date
fundscenter fistl Funds Center
functionalarea fm_farea Functional Area
profitcenter prctr Profit Center
fund bp_geber Fund
businessarea gsber Business Area
partnerbusinessarea pargb Trdg Part.BA
realestateobject farp_imkey Real Estate Key
costobject kstrg Cost Object
projectnetwork nplnr Network
networkactivity vornr Activity
wbselement ps_posid WBS Element
receiveractivitytype lstar Activity Type
personnelnumber pernr_d Personnel No.
businessprocess co_prznr Business Process
assetgrant gm_grant_nbr Grant
commitmentitem fm_fipex Commitment Item
quantityinbaseunit menge_d Quantity
baseunit meins Base Unit
assignmentreference dzuonr Assignment
isnotcashdiscountliable xskrl W/o CashDsc.
taxbaseamountintranscrcy fap_recurr_bapifwbas_cs Base Amount
taxamountintranscrcy fap_recurr_fwbas_cs Base Amount
profitabilitysegment rkeobjnr Profit. segment
plant werks_d Plant
budgetperiod fm_budget_period Budget Period
controllingarea kokrs CO Area
jointventurecostrecoverycode jv_recind_cds Joint Venture Cost Recovery Code
workitem /cpd/pfp_workitem_id Work Item ID
taxcountry fot_tax_country Tax Ctry/Reg.
transactioncurrency waers Currency

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.

-- G/L line items of recurring supplier invoice template
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAP_RSIV_GLLINER (
    MANDT,                           -- Client [mandt]
    RECRRGSUPLRINVCTMPLITEMUUID,     -- GUID [fap_rsiv_guid]
    RECRRGSUPLRINVCTMPLUUID,         -- GUID [fap_rsiv_guid]
    RECRRGSUPLRINVOICETEMPLATEITEM,  -- Number [fap_rsiv_item_num]
    GLACCOUNT,                       -- G/L Acct [hkont]
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount [fap_recurr_bapiwrbtr_cs]
    ACTUALAMOUNTINTRANSACTIONCRCY,   -- Act Amt in Tran Crcy [fis_act_wsl]
    DEBITCREDITCODE,                 -- Debit/Credit [shkzg]
    ISNEGATIVEPOSTING,               -- Negative Postg [xnegp]
    COMPANYCODE,                     -- Company Code [bukrs]
    TAXCODE,                         -- Tax Code [mwskz]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    DOCUMENTITEMTEXT,                -- Text [sgtxt]
    COSTCENTER,                      -- Cost Center [kostl]
    SALESORDER,                      -- SD Document [vbeln]
    SALESORDERITEM,                  -- Sales doc. item [vbelp]
    INTERNALORDER,                   -- Internal Order [fins_int_aufnr]
    SETTLEMENTREFERENCEDATE,         -- Reference Date [farp_dabrbez]
    FUNDSCENTER,                     -- Funds Center [fistl]
    FUNCTIONALAREA,                  -- Functional Area [fm_farea]
    PROFITCENTER,                    -- Profit Center [prctr]
    FUND,                            -- Fund [bp_geber]
    BUSINESSAREA,                    -- Business Area [gsber]
    PARTNERBUSINESSAREA,             -- Trdg Part.BA [pargb]
    REALESTATEOBJECT,                -- Real Estate Key [farp_imkey]
    COSTOBJECT,                      -- Cost Object [kstrg]
    PROJECTNETWORK,                  -- Network [nplnr]
    NETWORKACTIVITY,                 -- Activity [vornr]
    WBSELEMENT,                      -- WBS Element [ps_posid]
    RECEIVERACTIVITYTYPE,            -- Activity Type [lstar]
    PERSONNELNUMBER,                 -- Personnel No. [pernr_d]
    BUSINESSPROCESS,                 -- Business Process [co_prznr]
    ASSETGRANT,                      -- Grant [gm_grant_nbr]
    COMMITMENTITEM,                  -- Commitment Item [fm_fipex]
    QUANTITYINBASEUNIT,              -- Quantity [menge_d]
    BASEUNIT,                        -- Base Unit [meins]
    ASSIGNMENTREFERENCE,             -- Assignment [dzuonr]
    ISNOTCASHDISCOUNTLIABLE,         -- W/o CashDsc. [xskrl]
    TAXBASEAMOUNTINTRANSCRCY,        -- Base Amount [fap_recurr_bapifwbas_cs]
    TAXAMOUNTINTRANSCRCY,            -- Base Amount [fap_recurr_fwbas_cs]
    PROFITABILITYSEGMENT,            -- Profit. segment [rkeobjnr]
    PLANT,                           -- Plant [werks_d]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    JOINTVENTURECOSTRECOVERYCODE,    -- Joint Venture Cost Recovery Code [jv_recind_cds]
    WORKITEM,                        -- Work Item ID [/cpd/pfp_workitem_id]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TRANSACTIONCURRENCY,             -- Currency [waers]
    PRIMARY KEY (MANDT, RECRRGSUPLRINVCTMPLITEMUUID)
);