1. Home
  2. Resources
  3. SAP Tables
  4. V_OBJECTID - Generated Table for View

SAP Table V_OBJECTID

Generated Table for View

V_OBJECTID (Generated Table for View) 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 V_OBJECTID to other SAP tables.

V_OBJECTID table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
OBJID Object Number FILA_OBJID RAW 16 0
TMSTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
OBJECTID Contract Number FILA_REFOBJ CHAR 10 0
OBJTXT Description of Contract FILA_OBJTXT CHAR 50 0
SPRAS Language Key SPRAS LANG 1 0
OBJID_C Object Number (for Internal Use Only) FILA_OBJID_C CHAR 32 0
STATUSARCH Processing Status FILA_ARCH_STATUS NUMC 1 0
0 Not Archived
1 Intended for Archiving (not Used)
2 Archived
COMPONENT Application Component FILA_COMPONENT CHAR 4 0
EXT_HEADER_REF External Contract Reference of Ordering Party FILA_EXT_HEADER_REF CHAR 35 0
SUBID Subobject Number FILA_SUBID NUMC 5 0
EVENT Process FILA_EVENT CHAR 20 0
ITEMNO Item Number FILA_ITEMNO NUMC 10 0
ITEMNO_EXT External Item Number FILA_ITEMNO_EXT NUMC 10 0
ITEMTXT Item Description FILA_ITEMTXT CHAR 50 0
CURRENCY Currency Key WAERS CUKY 5 0
EXCHG_RATE Exchange rate KURSF DEC 9 5
QUANTITY Quantity AM_MENGE QUAN 13 3
UNIT Base Unit of Measure MEINS UNIT 3 0
BUKRS_REF Company Code BUKRS CHAR 4 0
OBJID_REF Object Number of Reference Object FILA_OBJID_REF RAW 16 0
SUBID_REF Reference Sub-Object Number FILA_SUBID_REF NUMC 5 0
SUBID_STG Reference Sub-Object Number FILA_SUBID_REF NUMC 5 0
UIID Unique Item ID in Life Cycle FILA_UIID CHAR 12 0
EXT_POS_REF External Item Reference FILA_EXT_ITEM_REF CHAR 35 0
FREE_POS_REF Custom External Item Reference FILA_FREE_EXT_ITEM_REF CHAR 35 0
CONTSTARTDT Start Date of Contract for Contract Item FILA_CONTSTARTDT DATS 8 0
CONTENDDT End Date of Contract for Contract Item FILA_CONTENDDT DATS 8 0
LEASTARTDT Date on Which Contract Processes Are Active(Lease Start Date FILA_LEASTARTDT DATS 8 0
LEASOPTEXEDT Option Exercise Date FILA_LEASOPTEXEDT DATS 8 0
TERM Contract Term (in Months) FILA_TERM NUMC 3 0
REM_USEFUL_LIFE Remaining Useful Life FILA_REMAINING_USEFUL_LIFE NUMC 3 0
PRODUCT Material Number MATNR CHAR 18 0
USEDPRODUCT Used Goods FILA_USEDPRODUCT CHAR 1 0
X Yes
NULL No
CUSTGROUP Customer group KDGRP T151 CHAR 2 0
SALESORG Sales Organization VKORG TVKO CHAR 4 0
DIS_CHANNEL Distribution Channel VTWEG TVTW CHAR 2 0
SOLDTO Sold-to party KUNAG KNA1 CHAR 10 0
INSTAT Installation Location FILA_INSTAT CHAR 10 0
FINPROD Financing Product FILA_FINPROD CHAR 18 0
FINCLAS Classification of Financing Type FILA_FINCLASSIFICATION CHAR 2 0
01 Leasing
02 Loan
03 Rent
04 Maintenance
05 Service Financing
06 Traders
07 Product
10 Service
11 Rent with Fixed Asset
12 Pool
13 Rent Without Fixed Asset
14 Demonstration
20 Sale and Leaseback Active Contract
21 Sale and Leaseback Passive Contract
22 Residual Value Loan
23 Installment Forfaiting
51 Inception, Debit-Side
52 Inception, Debit-Side
53 After Incoming Customer Payment, Debit-Side
61 Inception, Credit-Side
62 Termination, Credit-Side
63 After Incoming Customer Payment, Credit-Side
90 Tax Financing
BP_USAGE Use of Billing Plan FILA_BP_USAGE CHAR 1 0
NULL Periodic Billing
A Revenue Plan
B Milestone Billing
U UBB Periodic Billing
1 UBB Service
2 UBB Leasing
3 UBB Usage
4 UBB Usage Aggregate Contract
5 UBB Usage Single Pool Contract
6 UBB Included
7 UBB Pool Distribution
8 UBB Usage with Asset
DEVICECLASS Device Class FILA_DEVICECLASS CHAR 10 0
OPTIONID Option ID FILA_OPTIONID CHAR 2 0
CLASSIF_LOCAL Tax Financing Classification - Local FILA_CLASSLO CHAR 2 0
CLASSIF_GROUP Tax Financing Classification - Group FILA_CLASSGR CHAR 2 0
CLASSIF_LO_FLAG Forced Classification Indicator FILA_CLASSLO_FLAG CHAR 1 0
X Yes
NULL No
CLASSIF_GR_FLAG Forced Classification FILA_CLASSGR_FLAG CHAR 1 0
X Yes
NULL No
CLAS_CUSTOMER Classification - Customer FILA_CLASSCU CHAR 2 0
BUS_AREA Business Area GSBER CHAR 4 0
CLASSIF_LOCALBK Book Financing Classification - Local FILA_CLASSLOCBK CHAR 2 0
CLASSIF_GROUPBK Book Financing Classification - Group FILA_CLASSGRPBK CHAR 2 0
CLASSIF_LOBK_FL Forced Classification Indicator FILA_CLASSLOCBK_FLAG CHAR 1 0
X Yes
NULL No
CLASSIF_GRBK_FL Forced Classification Indicator FILA_CLASSGRPBK_FLAG CHAR 1 0
X Yes
NULL No
INTRATE Annual Interest Rate FILA_INTRATE DEC 7 4
PROC_INDICATOR Process Indicator for Leveraged Debt Cost FILA_PROC_CNTRL_INDICATOR NUMC 1 0
0 Not Refinanced
1 Refinanced and Asset Sold
2 Refinanced and Asset Not Sold
BU_ID_NUMBER Identification Number FILA_BU_ID_NUMBER CHAR 60 0
BU_ID_TYPE Identification Type FILA_BU_ID_TYPE CHAR 6 0
BU_PARTNER Business Partner Number FILA_BU_PARTNER CHAR 10 0
BEMOT Accounting Indicator FILA_BEMOT CHAR 2 0
BUAG_ID Business Agreement Number FILA_BUAG_ID CHAR 12 0
TMSTAMPADJ Time Stamp of Last Business Transaction from CRM FILA_TMSTAMPADJ DEC 15 0
PROCMODE Processing Mode of Process FILA_PROCMODE NUMC 1 0
0 Normal Processing of Process
1 Reverse Process and Process Again
2 Validation of Date Change
3 Financing Classification
4 Subsequent Adjustment Process
5 Reverse Process
6 Validation of Data Change
7 Reversal of Subsequent Adjustment Process
LOGHANDLE Application Log: Log Handle BALLOGHNDL CHAR 22 0
TMSTAMPREV Time Stamp of Business Transaction to be Reversed FILA_TMSTAMPREV DEC 15 0
ALLOCATION_ID External Assignment Indicator FILA_ALLOCATION_ID CHAR 16 0
TMSTAMPESP Time Stamp - Processed Successfully (BW Delta Extraction) FILA_TMSTAMPESP DEC 15 0
RUNID Migration Run Number FILA_RUNID_MIG NUMC 10 0
BUS_SCENARIO_ID Business Scenario for Which Controlling Is Performed FILA_BS_IDENTIFICATION CHAR 16 0
FIELD01 Field for Customer-Specific Data FILA_FIELD01 CHAR 20 0
FIELD02 Field for Customer-Specific Data FILA_FIELD02 CHAR 20 0
FIELD03 Field for Customer-Specific Data FILA_FIELD03 CHAR 20 0
LESSOR Account Number of Vendor or Creditor LIFNR CHAR 10 0

V_OBJECTID foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_OBJECTID CUSTGROUP SYST MANDT T151 Customers: Customer Groups MANDT
V_OBJECTID CUSTGROUP V_OBJECTID CUSTGROUP T151 Customers: Customer Groups KDGRP
V_OBJECTID DIS_CHANNEL SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
V_OBJECTID DIS_CHANNEL V_OBJECTID DIS_CHANNEL TVTW Organizational Unit: Distribution Channels VTWEG
V_OBJECTID SALESORG V_OBJECTID SALESORG TVKO Organizational Unit: Sales Organizations VKORG
V_OBJECTID SALESORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
V_OBJECTID SOLDTO SYST MANDT KNA1 General Data in Customer Master MANDT
V_OBJECTID SOLDTO V_OBJECTID SOLDTO KNA1 General Data in Customer Master KUNNR