FAP_RSIV_GLLINER
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. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_RecrrgSuplrInvcTmplItemTP | view_entity | from | TRANSACTIONAL | GL items of recurring suplr invc tmpl |
Fields (48)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA