FARP_MIV_GLITM

Transparent Table Application Table
56 Fields 1 CDS Views

manage ap/ar gl account info

FARP_MIV_GLITM is an SAP database table in S/4HANA. manage ap/ar gl account info. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IncgOutgInvoiceItemTP view_entity from TRANSACTIONAL Manage G/L Item Info of AP/AR Invoices

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY outgoinginvoiceitemuuid farp_miv_upldglinvoiceitemuuid UCOI G/L Items UUID
outgoinginvoiceuuid farp_miv_uploadinvoiceuuid Upload Invoice UUID
outgoinginvoiceitem farp_miv_item_num Number
glaccount hkont G/L Acct
amountintransactioncurrency fis_act_wsl Act Amt in Tran Crcy
actualamountintransactioncrcy farp_miv_dummy_amount_field Dummy Field of Amt
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 farp_miv_vbeln Sales Order Doc.
salesorderitem farp_miv_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_miv_imkey Real Estate Key
costobject kstrg Cost Object
projectnetwork nplnr Network
networkactivity farp_miv_vornr Operation/Activity
wbselement ps_posid_edit 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 farp_miv_xskrl W/o Cash Discount
taxbaseamountintranscrcy fwbas_shl Tx Bse Amt TransCrcy
taxamountintranscrcy fap_recurr_fwbas_cs Base Amount
profitabilitysegment rkeobjnr_char Profitability Segment
plant werks_d Plant
budgetperiod fm_budget_period Budget Period
controllingarea kokrs CO Area
jointventurecostrecoverycode jv_recind Recovery Ind.
workitem /cpd/pfp_workitem_id Work Item ID
taxcountry fot_tax_country Tax Ctry/Reg.
transactioncurrency waers Currency
partnerprofitcenter fis_pprctr Partner Profit Center
reportingsegment fco_reporting_segment Reporting Segment
salesorderscheduleline etenr Schedule Line
material matnr Material
servicedocumenttype farp_miv_psrdoc_type Part. Srvc. Doc. Typ
servicedocid fco_srvdoc_id Service Document
servicedocitemid fco_srvdoc_item_id Service Doc. Item
financialtransactiontype fis_rmvct Financial Transaction Type

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 gl account info
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FARP_MIV_GLITM (
    MANDT,                          -- Client [mandt]
    OUTGOINGINVOICEITEMUUID,        -- UCOI G/L Items UUID [farp_miv_upldglinvoiceitemuuid]
    OUTGOINGINVOICEUUID,            -- Upload Invoice UUID [farp_miv_uploadinvoiceuuid]
    OUTGOINGINVOICEITEM,            -- Number [farp_miv_item_num]
    GLACCOUNT,                      -- G/L Acct [hkont]
    AMOUNTINTRANSACTIONCURRENCY,    -- Act Amt in Tran Crcy [fis_act_wsl]
    ACTUALAMOUNTINTRANSACTIONCRCY,  -- Dummy Field of Amt [farp_miv_dummy_amount_field]
    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,                     -- Sales Order Doc. [farp_miv_vbeln]
    SALESORDERITEM,                 -- Sales Doc. Item [farp_miv_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_miv_imkey]
    COSTOBJECT,                     -- Cost Object [kstrg]
    PROJECTNETWORK,                 -- Network [nplnr]
    NETWORKACTIVITY,                -- Operation/Activity [farp_miv_vornr]
    WBSELEMENT,                     -- WBS Element [ps_posid_edit]
    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 Cash Discount [farp_miv_xskrl]
    TAXBASEAMOUNTINTRANSCRCY,       -- Tx Bse Amt TransCrcy [fwbas_shl]
    TAXAMOUNTINTRANSCRCY,           -- Base Amount [fap_recurr_fwbas_cs]
    PROFITABILITYSEGMENT,           -- Profitability Segment [rkeobjnr_char]
    PLANT,                          -- Plant [werks_d]
    BUDGETPERIOD,                   -- Budget Period [fm_budget_period]
    CONTROLLINGAREA,                -- CO Area [kokrs]
    JOINTVENTURECOSTRECOVERYCODE,   -- Recovery Ind. [jv_recind]
    WORKITEM,                       -- Work Item ID [/cpd/pfp_workitem_id]
    TAXCOUNTRY,                     -- Tax Ctry/Reg. [fot_tax_country]
    TRANSACTIONCURRENCY,            -- Currency [waers]
    PARTNERPROFITCENTER,            -- Partner Profit Center [fis_pprctr]
    REPORTINGSEGMENT,               -- Reporting Segment [fco_reporting_segment]
    SALESORDERSCHEDULELINE,         -- Schedule Line [etenr]
    MATERIAL,                       -- Material [matnr]
    SERVICEDOCUMENTTYPE,            -- Part. Srvc. Doc. Typ [farp_miv_psrdoc_type]
    SERVICEDOCID,                   -- Service Document [fco_srvdoc_id]
    SERVICEDOCITEMID,               -- Service Doc. Item [fco_srvdoc_item_id]
    FINANCIALTRANSACTIONTYPE,       -- Financial Transaction Type [fis_rmvct]
    PRIMARY KEY (MANDT, OUTGOINGINVOICEITEMUUID)
);

Learn More