SAP Construction Equipment Management Tables

Are you looking for the right table related to SAP Construction Equipment Management Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Construction Equipment Management (IS-EC-CEM) module.

Top 10 tables in Construction Equipment Management

TableDescription
J_3GKSCHLFRISTDeadline Logic per Condition Type
J_3GANZVARDisplay Variants - Link to INDX
J_3GVBRPCEM Additional Data for VBRP
J_3GVERSITax/Insurance Data
J_3GARCHIVCEM Archiving Lists
J_3GTVKOCustomer Internal Settlement per Sales Organization in CEM
J_3GKATEINCatalog
J_3GSTLPOSItem Data for Equipment BOMs
J_3GNUMKAUAssignment of Number Ranges to Order Types for CEM
J_3GABESTCurrent Stocks

List of tables in Construction Equipment Management

TableDescription
J_3GKSCHLFRISTDeadline Logic per Condition Type
J_3GANZVARDisplay Variants - Link to INDX
J_3GVBRPCEM Additional Data for VBRP
J_3GVERSITax/Insurance Data
J_3GARCHIVCEM Archiving Lists
J_3GTVKOCustomer Internal Settlement per Sales Organization in CEM
J_3GKATEINCatalog
J_3GSTLPOSItem Data for Equipment BOMs
J_3GNUMKAUAssignment of Number Ranges to Order Types for CEM
J_3GABESTCurrent Stocks
J_3GFEQUIExternal Equipment Type
J_3GKATMERCatalog Characteristics
J_3GKONZABGroup Mapping
J_3GTPMKCost Key Figures of the Maintenance Order
J_3GZUABGTReason for Acquisition/Withdrawal - Texts
J_3GMTARTCEM/MM Inventory Mgmt per Material Type and Recipient Type
J_3GBELKDocument File - Header Data
J_3GDEMPERSDefault Recipient for Personnel Performance per Org. Struct.
J_3GBELPDocument Data - Item Data
J_3GBERGRTAuthorization Group Texts
J_3GPLKOPFPrice List Header
J_3GBESARTInventory Management Type
J_3GGBBKVBSales Area per Company Code/Business Area/Plant
J_3GHBESTHistorical Stock
J_3GVBAPAdditional Data CEM SD Document Item
J_3GKATZUDefault Catalog Code per Resource Type
J_3GDRUCKCEM: Processing Programs for Print Control
J_3GABGRFMATRemoval Sequence for Materials
J_3GPAKKPackage Header Data
J_3GEMPFTRecipient Type Texts
J_3GKSCHLUMBAssign Condition Types for Transfer Postings
J_3GABGRFRemoval Sequence - Activity Types
J_3GBLARTTDocument Type Texts
J_3GBESTFARTTTexts for Inventory Management Type
J_3GEIVERPOwner/Administrator Leasing Types
J_3GEQBSTPInventory Management Check per Equipment Type
J_3GBELAMAAssign Sale/Repurchase for Material Deliveries
J_3GINTFORFormula Definition for Costing (Interpolation)
J_3GIENUMVInternal/External Owner/Administrator Number Assignment
J_3GZVBAPBackup Table for CEM Data in Rel. 3.0
J_3GPAKKTPackage Description
J_3GABRMTARTSettlement Indicator in CEM/MM per Material Type
J_3GSTATUSSingle Display-Relevant Status of Object
J_3GLEIARTActivity Types
J_3GWFCEMCEM: Default Values for Workflow
J_3GPRLHDCEM Price Lists Condition Header
J_3GBAMTARTAllowed Material Types per Document Type
J_3GJ000Condition Table for Price List Determination
J_3GLABETActivity Types/Limits per Document Category
J_3GT370SStructure Indicator for Catalog
J_3GINTNA1Formula Parameters for Costing (Interpolation)
J_3GSTLKOPFHeader Data for Equipment BOMs
J_3GLASEAllowed Activity Types per Document Type
J_3GEIVERTOwner/Administrator Description
J_3GZUABGRReason for Acquisition/Withdrawal
J_3GERLMTARTAllowed Material Types
J_3GLADEKELoading Costs Indicator
J_3GKAL1Selection Parameters for CEM Calendar Visualization
J_3GFRISTLAZUAssign Activity Types to Deadline Surcharges
J_3GBESTFARTInventory Management Type
J_3GDEMEQUIDefault Recipient for Equipment per Organizational Structure
J_3GAUSARTSettlement Calendar
J_3GAUSATXSettlement Calendar, Acty Type Times, Language-Dependent
J_3GKNDMOConditions Modification on Screen
J_3GDYNPROScreens to be Processed
J_3GLVARTTActivity Type Texts
J_3GKALSMPricing Procedure Determination
J_3GTPMKTTexts for Cost Key Figures of the Maintenance Order
J_3GPACHTVLease Settlement
J_3GBELARTDocument Types
J_3GKAL0Definitions for CEM Calendar Visualizations
J_3GEMPFBFARTAssign Inventory Mgmt Type to Rcpnt Type/Actvty Type
J_3GPRLISTCEM Price List Data
J_3GLADEKTTexts for Loading Costs Indicator
J_3GEQUIVODefault Values for CEM Equipment Data
J_3GPMCO2Cost Structure: Job Key Figures (PMIS)
J_3GBELKORecipient Type per Document Type
J_3GT370STStructure Indicator for Catalog Texts
J_3GEQUMPAssignment of Measuring Point to Equipment
J_3GFEQUITExternal Equipment Type Texts
J_3GZUETYPRecipient Type Assignment
J_3GFAKSPBilling Doc. Blocking Indicator Document Item CEM
J_3GSTLAKTActivation File/Buffer for BOMs
J_3GTBESTTemporary Stock
J_3GFRISTBTLADeadline Logic per Document Type, Trans. Type and Acty Type
J_3GBERGR(Recipient) Authorization Groups
J_3GPLKATAssignment Price List - Condition Types - Catalogs
J_3GEMTLADAssignment Recipient Types-Activity Types Default
J_3GEIVERSOwner/Administrator Master Record
J_3GPAKPPackage Item Data
J_3GUMLENKRedirection of Account Determination
J_3GKATALCatalog
J_3GINBELCustomer Numbers Used in Documents
J_3GSTERNVStandard Allocation Table
J_3GFAKSPTBilling Doc. Blocking Indicator Texts CEM
J_3GCOFIXAccount Determination Using Fixed CO Object
J_3GDRUCK_PARAMPrint Parameters per User
J_3GLKOSTDefault Loading Costs Indicator/Provision Fee
J_3GSTDANZUsers Allowed to Create Standard Display Variants
J_3GTCHLPAuxiliary Table for Joint Venture Trans. Calls (SAPMJ3GO)
J_3GVBRP_ZFrozen Data from VBRP Conversion
J_3GKONDMOConditions Modification on Screen
J_3GSTEUMInternal Settlement/Writing Invoices (Tax Matrix)
J_3GLAMTARTActivity Types per Material Type
J_3GMCIDMatchcode ID Choice for Selecting PSP Elem. for Proj. Def.
J_3GZUEIGNLeasing Table
J_3GMEMPFDominance Indicator per Document Type/Recipient Type
J_3GKAL2Function Codes/Performs for CEM Calendar