SAP Table VEPT

Cmmt/Actual Line Items for Assigned Budget Independ.of Year

VEPT (Cmmt/Actual Line Items for Assigned Budget Independ.of Year) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VEPT to other SAP tables.

VEPT table fields

Field Data element Checktable Datatype Length Decimals
FISTL Funds Center FISTL FMFCTR CHAR 16 0
FIPEX Commitment Item FM_FIPEX FMCI CHAR 24 0
FAREA Functional Area FM_FAREA TFKB CHAR 16 0
REFBN Reference Document Number CO_REFBN CHAR 10 0
RFPOS Item number of reference document CC_RFPOS NUMC 5 0
REFBT Reference document category (conversion exit; c.f. REFBTYP) CO_REFBTYP NUMC 3 0
010 Purchase requisition
020 Purchase order
030 Material reservation
100 Earmarked funds
200 Transfer price agreement
RFORG Reference Organizational Units AWORG CHAR 10 0
RFKNT Account assignment number of reference document CC_RFKNT NUMC 5 0
RFETE Reference document classification number CC_RFETE NUMC 4 0
WRTTP Value Type CO_WRTTP CHAR 2 0
01 Plan
02 Plan: Splitting Among Activity Types
03 Actual: Splitting Among Activity Types
04 Actual
05 Target
06 Target (WIP)
07 Target: Splitting Among Activity Types
08 Plan: Correction for Internal Bus.Vol Between Cost Centers
09 Actual: Correction for IBV Between Cost Centers
10 Statistical Plan
11 Statistical Actual
12 Down Payment as Operating Expense
13 Statistical Down Payments as Expense
19 Order Receipt/Orders Balance
21 Commitments from Purchase Requisition
22 Purchase Order Commitment
23 Reservation Commitment
24 Funds Commitment
25 Remainder from Apportioned Orders/Networks (Order Commitmts)
26 Commitments from Transfer Price Agreement
28 Value from Customer Quotation
29 Value from Sales Order
2A Funds Reservation
2B Funds Precommitment
30 Scrap
31 Variances
32 Results Analysis and WIP Calculation
33 Results Analysis: Credit Side/Debit Side
34 Results Analysis: Cost of Sales from Resource-Rel. Billing
35 Plan for True Investments
36 Budget for True Investments
37 Program Budget for True Investments
38 Program Plan for True Investments
39 Request Plan
40 Request Plan for True Investments
41 Budget
42 Assigned Budget
43 Payment Budget
44 Payment Budget: Assigned Funds
45 Payment budget: Releases
46 Cash Release
47 Program Budget
48 Program Plan
49 Planned Accrual Calculations: Results Analysis, WIP Calc.
4A Payment Budget: Statistical
4B Budget Balance
4C Payment Budget: Clear on Revenue Item
50 Purchase Requisitions
5A Payment Obligations from Purchasing Down Payments
51 Purchase Orders
52 Business Trip Commitments
53 User-Defined Payment Commitment (Financial Transaction 50)
54 Invoices
55 Bank clearings
56 User-Defined Payment Obligation (Financial Transaction 70)
57 Payments
58 Down Payment Requests
59 Down Payments for Bank Clearing
60 Parked Document
61 Down Payments
62 Planned Payments
6A Planned Down Payments
6B Clarification Worklist FI-CA
63 Down Payment Clearings
64 Funds Transfers
65 Funds Commitment
66 Profit Transfer Postings
67 Other Statistical Documents
68 Other Non-Statistical Document
69 Commitment Budget: Funds Reservations
70 Commitment Budget
71 Commitment Budget - Assigned Funds
72 Commitment Budget: Releases
73 Purchase Order: Cycle Counting Blocking Amount
74 Funds Reservation: Cycle Counting Blocking Amount
75 Commitment Budget: Funds Reservation Cycle Cntg Blckng Amt
76 Commitment Budget: Purchase Orders, Cycle Counting Blckg Amt
77 Commitment Budget: Purchase Orders
7C Commitment Budget: Expense Type Budget for Revenue Item
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation
85 Payment Budget: Reservations
86 Payment Budget: Earmarked Funds
87 Payment Budget: Reserved Releases
88 Payment Budget: Earmarked Releases
89 Commitment Budget: Reservations
90 Commitment Budget: Earmarked Funds
91 Commitment Budget: Reserved Releases
92 Commitment Budget: Earmarked Releases
93 Financial Budget
94 Payment Budget: Adjustment Field
95 Actual CO Postings
96 Purchase Order Overhead
97 Purchase Requisition Overhead
98 Funds Reservation (CO)
99 Financial Result
9A Financial Result: Statistical
9B Financial Budget: Statistical
9C Financial Budget Plan Balance
9D Funds Management: HR Integration
9E Approved Total Costs/Revenue
D1 Distribution of Actual Costs (By Source Assignment)
D2 Distribution of Commitments (By Source Assignment)
D3 Distribution of Work-in-Process (By Source Assignment)
D4 Distribution of Earned Value (By Source Assignment)
D5 Distribution of Payments (By Source Assignment)
D6 Distribution of Down Payments (By Source Assignment)
P1 Earned Value (Plan)
P2 Earned Value (Actual)
P3 Capitalized Remainder Costs
3C Control Costs
WTEXT Val.type name FM_WRTTPT CHAR 40 0
BTART Amount type FM_BTART CHAR 4 0
0100 Original
0110 Approved in Workflow (Workflow ledger 9D only)
0120 Not approved in Workflow (Workflow ledger 9D only)
0150 Change
0200 Reduction
0210 Reduction Cheque Clearing
0220 Change by Revaluation
0250 Paid
0260 Paid Cheque Clearing
0300 Previous Year Carryforward (Commitments)
0350 Following year carryforward (commitments)
0351 Commitment Carryforward: Carryforward Consumed Amount
0352 Commitment Carryforward: Reduction of Consumed Amount
0360 Balance from Previous Years
0400 Block Entry
0500 Adjustment by Follow-on Document
0600 Reassignment Sender
0650 Reassignment Receiver
0700 Settlement of Retirements
0750 Settlement of Acquisitions
BTEXT Name of amount type FM_BTARTT CHAR 40 0
ERLKZ Completion indicator for line item KBLERLKZ CHAR 1 0
NULL Not Selected
X Selected
LOEKZ Deletion Indicator KBLLOEKZ CHAR 1 0
NULL Not Selected
X Selected
GJAHR Fiscal Year GJAHR NUMC 4 0
GNJHR Year of Cash Effectivity GNJHR NUMC 4 0
PERIO Period FM_PERIODE NUMC 3 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
ZHLDT Funds Management - Update Date FM_ZHLDT DATS 8 0
CTRNR Funds Management Control Number FM_CTRNR CHAR 20 0
BUKRS Company Code BUKRS T001 CHAR 4 0
HKONT General Ledger Account HKONT SKA1 CHAR 10 0
SGTXT Item Text SGTXT CHAR 50 0
FMBELNR Document Number of FM Line Item FM_BELNR CHAR 10 0
FMBUZEI Number of a posting line in a TR-FM line item FM_BUZEI NUMC 3 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
VOGJAHR Fiscal year for payment document number FM_VOGJAHR NUMC 4 0
VOBELNR Payment Document Number FM_VOBELNR CHAR 10 0
VOBUZEI Item for payment document number FM_VOBUZEI NUMC 3 0
KNGJAHR Fiscal year for FI document number FM_KNGJAHR NUMC 4 0
XREVS Cancelation flag STNKZ CHAR 1 0
VRGNG CO Business Transaction CO_VORGANG TJ01 CHAR 4 0
VTEXT Name of CO transaction FM_VRGNGT CHAR 30 0
AWREF RW document number FM_AWREF CHAR 10 0
CF_FLAG Carryforwards at year-end closing FM_CF_FLAG CHAR 1 0
X Yes
NULL No
CFSTAT FM Commitment Carryforward: Status FM_CFST NUMC 2 0
00
31 Carried forward to following year
32 Carried forward from previous year
41 Selected for carryforward (Workflow)
42 Carryforward Approved (Workflow)
51 Carryforward reversed
99 No commitment cfwd
CFSTATSV Year-End Closing: Status (Back Up) FM_CFSTSV NUMC 2 0
00
31 Carried forward to following year
32 Carried forward from previous year
41 Selected for carryforward (Workflow)
42 Carryforward Approved (Workflow)
51 Carryforward reversed
99 No commitment cfwd
CFCNT Year-End Closing: Number of Transfers FM_CFCNT NUMC 2 0
CFLEV Carryforward level FM_CFLEV CHAR 1 0
NULL Document and Predecessor not Carried Forward
X X Document or Predecessor Carried Forward
U U Customer Flag: Document or Predecessor Carried Forward
0 Customer Specification: Number of Carryforwards
FWAER FM area currency FMWAER TCURC CUKY 5 0
FKBTR Commitment/Actual for an assigned value in FM area currency FM_FKBTRAS CURR 15 2
TWAER Transaction Currency TWAER TCURC CUKY 5 0
TRBTR Commitment/actual for an assigned value in transaction curr. FM_TRBTRAS CURR 15 2
KOKRS Controlling Area KOKRS CHAR 4 0

VEPT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VEPT BUKRS SY MANDT T001 Company Codes MANDT
VEPT BUKRS VEPT BUKRS T001 Company Codes BUKRS
VEPT FAREA SYST MANDT TFKB Functional areas MANDT
VEPT FAREA VEPT FAREA TFKB Functional areas FKBER
VEPT FIPEX VEPT GJAHR FMCI Commitment items master data FIKRS
VEPT FIPEX VEPT FIPEX FMCI Commitment items master data GJAHR
VEPT FIPEX SYST MANDT FMCI Commitment items master data .INCLUDE
VEPT FIPEX FKRS FIKRS FMCI Commitment items master data MANDT
VEPT FISTL SY MANDT FMFCTR Funds Center Master Record MANDT
VEPT FISTL FM01 FIKRS FMFCTR Funds Center Master Record FIKRS
VEPT FISTL VEPT FISTL FMFCTR Funds Center Master Record FICTR
VEPT FISTL * FMFCTR Funds Center Master Record DATBIS
VEPT FWAER VEPT FWAER TCURC Currency Codes WAERS
VEPT FWAER SYST MANDT TCURC Currency Codes MANDT
VEPT HKONT * SKA1 G/L Account Master (Chart of Accounts) KTOPL
VEPT HKONT VEPT HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
VEPT HKONT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
VEPT KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
VEPT KUNNR VEPT KUNNR KNA1 General Data in Customer Master KUNNR
VEPT LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
VEPT LIFNR VEPT LIFNR LFA1 Vendor Master (General Section) LIFNR
VEPT TWAER SY MANDT TCURC Currency Codes MANDT
VEPT TWAER VEPT TWAER TCURC Currency Codes WAERS
VEPT VRGNG VEPT VRGNG TJ01 Business Transactions VRGNG