Master Data

Common

Refer to tcmcsdll0008

TableDescription
tcccp001Availability Types
tcccp003Time Interval Types
tcccp010Calendar Codes
tcccp019Non-Available Days
tcccp020Calendar Times Interval
tcccp040Standard Calendar
tcccp041Calendar Patterns
tcccp042Calendar Recurrence Working Hours
tcccp050Calendar - Availability Types
tcccp060Period Tables
tcccp061Period Table Usage
tcccp070Periods
tcccp071Usage of Period
tcccp081Calendar Selection for ESP
tccom001Employees - General
tccom100Business Partners
tccom110Sold-to Business Partners
tccom111Ship-to Business Partners
tccom112Invoice-to Business Partners
tccom113Invoice-to Business Partner Balances
tccom114Pay-by Business Partners
tccom115Banks by Pay-by Business Partner
tccom117Ship-to by Sold-to Business Partner
tccom120Buy-from Business Partners
tccom121Ship-from Business Partners
tccom122Invoice-from Business Partners
tccom123Invoice-from Business Partner Balances
tccom124Pay-to Business Partners
tccom125Banks by Pay-to Business Partner
tccom126Pay-to Business Partner 1099 Details
tccom130Addresses
tccom135Address Formats
tccom136ZIP Codes/Postal Codes
tccom137Distance Table by City
tccom138Distance Table by ZIP Code/Postal Code
tccom139Cities by Country
tccom140Contacts
tccom145Contacts by Business Partner
tccom500Planning Board Groups
tccom501Default Charts by User and Session
tccom700Sales Listing Data
tccom704Extra Intrastat Info Definition
tccom705Additional Statistical Information Sets
tccom710Import/Export Statistics
tccom720Intrastat Mapping Scheme
tccom737Payer's 1099 Details
tccom738Product Category
tccom739Product Category Tax Matrix
tccom740Country Tax Provider Register
tcemm010Option Groups
tcemm011Options
tcemm012Topics
tcemm013Required Topics
tcemm014Parameters
tcemm015Required Parameters
tcemm100Time Zones
tcemm110Key Entities
tcemm112Warehouses
tcemm113Projects
tcemm122Business Partners
tcemm124Departments
tcemm135Clusters
tcemm170Companies
tcemm210Entity - Entity Relationships
tcemm235Default Relationships
tcemm250Goods Transfers
tcfin010Integration Document Type by Transaction Origin/ Financial Transaction
tcfin015Integration Document Types by Reconciliation Group
tcfin020Reconciliation Groups
tcfin025Possible Reconciliation Elements by Reconciliation Group
tcfin030Reconciliation Elements
tcibd001Items - General
tcibd002Items - General Defaults
tcibd003Conversion Factors
tcibd004Item Codes by Item Code System
tcibd005Alternative Items
tcibd006Item Code Systems
tcibd010Date-Effective Item Data
tcibd020Reference Designators by Item
tcibd100Item Inventory
tcibd200Items - Ordering
tcibd201Items - Ordering Defaults
tcibd300List Components
tcibd301List Groups
tcibd401Serial Numbers
tcibd402Masks
tcibd403Mask Segments
tcibd404Translation Functions
tcibd405Mask by Item/Item Group
tcibd406Translation Table Values
tcibd410Lot and Serial Sets
tcibd411Lot and Serial Set Details
tcmcs001Units
tcmcs002Currencies
tcmcs003Warehouses
tcmcs004Routes
tcmcs005Reasons
tcmcs006Unit Sets
tcmcs007Units by Language
tcmcs008Currency Rates
tcmcs009Credit Insurance Companies
tcmcs010Countries
tcmcs011Late Payment Surcharges
tcmcs012Units by Unit Set
tcmcs013Payment Terms
tcmcs015Product Types
tcmcs016Seasonal Patterns
tcmcs017Seasonal Pattern Factors
tcmcs018Item Signals
tcmcs019Titles
tcmcs021Discount Codes
tcmcs022Selection Codes
tcmcs023Item Groups
tcmcs024Price Groups
tcmcs028Commodities
tcmcs029Business Partner Types
tcmcs031Lines of Business
tcmcs032Single Tax Rates
tcmcs033Multiple Tax Rates
tcmcs034Price Lists
tcmcs035Multiple Tax Codes
tcmcs036Tax Codes by Country
tcmcs037Tax Codes
tcmcs038Tax Handling
tcmcs039Signals
tcmcs040Exchange Rate Types
tcmcs041Delivery Terms
tcmcs042Points of Title Passage
tcmcs044Statistical Groups
tcmcs045Areas
tcmcs046Languages
tcmcs048Cost Components
tcmcs050First Free Numbers
tcmcs051Number Groups
tcmcs052Projects
tcmcs053Rounding Codes
tcmcs055Invoicing Methods
tcmcs056Invoice Delivery Methods
tcmcs060Manufacturers
tcmcs061Product Lines
tcmcs062Product Classes
tcmcs064Credit Ratings
tcmcs065Departments
tcmcs066Channels
tcmcs070Priorities
tcmcs075Freight Service Levels
tcmcs080Carriers
tcmcs085Setup Classes
tcmcs086Setup States
tcmcs090Reference Designators
tcmcs095Parameters
tcmcs096Statuses
tcmcs097Performance Boosters
tcmcs098Table Boosters
tcmcs131Revenue Stamp Tax by Country
tcmcs132Division for Revenue Stamp Tax
tcmcs136Tax Codes by GEO Code
tcmcs137Tax Authorities
tcmcs138Exceptions for Tax
tcmcs139Exceptions by Tax Location
tcmcs140Tax Authority Groups
tcmcs143States/Provinces
tcmcs145Routing Groups
tcmcs160Tax Exemptions for Purchasing
tcmcs161Register Warehouse for Tax Exemptions
tcmcs180Country Groups
tcmcs201Purchase Types
tcmcs202Sales Types
tcmcs203Purchase Type Exceptions
tcmcs204Sale Type Exceptions
tcmcs205Closing Methods
tcmcs206Payment Agreements
tcmcs207Payment Agreement Lines
tcmcs208Payment Agreement by Item (Group) and Invoice-from BP (Group)
tcmcs209Priorities to Set Default Payment Agreement
tcmcs220Payment Schedule Headers
tcmcs221Payment Schedule Lines
tcppl010Skills
tcppl020Skills by Employee
tcppl030Labor Types
tcppl031Labor Type - Surcharges
tcppl040Teams
tcppl050Employees by Team
tcppl060Roles
tcppl070Roles by Employee
tcppl080Roles by Team
tcppl090Labor Rate Codes
tcppl091Labor Rate Code - Rates
tcppl092Labor Rates by Business Partner and Project
tcppl100Working Time Schedule
tcppl101Working Time Schedule Codes
tctax000Tax Parameters
tctax010Tax Base Value Variables
tctax011Tax Base Value Formulas
tctax015Tax Categories
tctax016Tax Classifications
tctax017Limits of Income Tax and Social Contribution
tctax020Country Sets
tctax021Countries by Country Set
tctax038Tax Handling
tctax039Tax Codes by Group Tax Code
tctax070Company Sets
tctax071Companies by Company Set
tctax080Business Partner Sets
tctax081Business Partners by Business Partner Set
tctax100Exception Modeling by Country
tctax101Exception Modeling by Country Set
tctax170Destination Tax Rules for Service
tctax175Destination Tax Rules for Service Contracts
tctax400Tax Numbers by Business Partner
tctax405Tax Number Definition
tctax410Financial Departments
tcuef001Effectivity Series
tcuef002Effectivity Number
tcuef005Effectivity Statement
tcuef006Requirements
tcuef007Requirement - Effectivity Units
tcuef008Default Requirements by Item

 

People

Refer to bpmdmdll0005

TableDescription
bpmdm001Employee
bpmdm030Assignments
bpmdm050General Tasks
bpmdm055General Expense Codes

 

Freight Management

Refer to fmfmddll0004

TableDescription
fmfmd020Combination Code
fmfmd030Freight Class
fmfmd040Transport Type
fmfmd042Transport Means Combination
fmfmd044Transport Means Combination – By Carrier
fmfmd047Vehicle Type
fmfmd048Vehicle Type/Means of Transport – by Transport Means Combination
fmfmd050Transport Means Group
fmfmd052Transport Means Group - by Carrier
fmfmd055Means of Transport
fmfmd060Freight Order Type
fmfmd070Service Level
fmfmd080Shipping Office
fmfmd095Class Codes
fmfmd100Item - Freight Management
fmfoc050Planning Groups
fmfoc150Route Plan
fmlbd010Plan
fmlbd050Standard Route
fmlbd200Trip

 

Procurement and Sales

Refer to tdpurdll4800 and tdslsdll4800

TableDescription
tdipu001Item Purchase Data
tdipu045Manufacturer Part Numbers
tdipu048MPNs by Item – Business Partner
tdisa001Item Sales Data
tdpur012Purchase Offices
tdpur054Purchase Acknowledgment Codes
tdpur094Purchase Order Types
tdpur097Change Reasons
tdpur098Change Types
tdpur414Purchase Change Order Sequence Numbers
tdsls012Sales Offices
tdsls054Sales Acknowledgment Codes
tdsls094Sales Order Types
tdsls097Change Reason Codes
tdsls098Change Types
tdsls414Sales Change Order Sequence Numbers

 

Financials

Refer to tfglddll6026

TableDescription
tfacp001Financial Supplier Groups
tfacp002Blocking Codes
tfacp003Blocking References
tfacp004Aging Analysis Data
tfacp005Ledger Accounts by Supplier Group
tfacp008Procurement Cards
tfacp010Procurement Card Line Types
tfacp011Discrepancy Reasons
tfacp012Matching Codes
tfacp015Control Accounts by Financial Supplier Group
tfacp106Pay-to Business Partners per Factor
tfacp300Subcontractors
tfacp301Industrial Assurance Boards
tfacp302Remittance Agreements
tfacr001Financial Customer Groups
tfacr002Problem Codes
tfacr003Problem References
tfacr005Ledger Accounts by Customer Group
tfacr015Control Accounts by Financial Customer Group
tfacr016Pay-by Business Partners by Factor
tfacr310Reminder Methods
tfacr311Statement of Account Methods
tfacr312Statement of Account Layouts
tfcat401Allocation Rule Sets
tfcmg001Bank Relations
tfcmg002Reasons for Payment
tfcmg003Payment/Receipt Methods
tfcmg004Codes by Type of Payment
tfcmg006Data by Bank & Payment/Receipt Method
tfcmg007Posting Data by Bank & Payment/Receipt Method
tfcmg008Posting Data by Tax Code
tfcmg009Financial Institutions
tfcmg011Bank Branches
tfcmg012Bank Transaction Data
tfcmg013Additional descriptions for Reasons for Payment
tfcmg016Trade Note Types
tfcmg190Payment Process Defaults
tffbs001Budget Distribution
tffbs002Budget Distribution Data per Period
tffbs003Budget
tffbs004Budget Defaults by Ledger Account/Dimensions
tffbs005Budgets per Year
tffbs010Hierarchy
tffbs011Hierarchy for Ledger Accounts
tffbs012Hierarchy for Dimensions
tffbs020Ledger Account Structure per Dimension
tffbs021Relations between Ledger Accounts
tffbs030Reference Units per Dimension
tffbs040Report Structure per Dimension Type
tffbs041Report Structure Lines
tffbs042Summation Rules for Report Structure Lines
tfgld001Financial Companies by Company Group
tfgld002Dimension Descriptions
tfgld005Periods
tfgld006End Dates by Year
tfgld007Period Status
tfgld008Chart of Accounts
tfgld009Dimension Ranges by Ledger Account
tfgld010Dimensions
tfgld011Transaction Types
tfgld017Transaction Type Series
tfgld023Cash Flow Statements
tfgld024Cash flow reason groups
tfgld026Cash flow reasons by statement
tfgld035Protocol Codes
tfgld038Source of Earnings
tfgld039Source of Earning - Details
tfgld050Journal Book Sections
tfgld060Vat Book
tfgld134VAT Liquidation
tfgld136VAT Book Summary
tfgld435Integration User Groups
tfgld436Integration Transaction Users
tfgld450Integration Parameters
tfgld454Business Objects
tfgld456Elements
tfgld457Integration Document Types
tfgld458Elements by Integration Document Type
tfgld459Integration Document Type Groups
tfgld460Integration Document Types by Integration Document Type Group
tfgld473Mapping Schemes
tfcmg125Trade Notes Payable
tfcmg425Trade Notes Receivable

 

Manufacturing

Refer to tisfcdll0003

TableDescription
ticpr050Operation Rate Codes
ticpr100Price Calculation Codes
tiipd001Item Production Data
tipcs010Calculation Groups
tipcs020General Project Data
tipcs024Project Stages
tipcs030Project Details
tipcs040Budget Details
tirou001Work Center
tirou002Machine
tirou003Task
tirpt001Production Schedule Codes
tirpt003Scheduling Areas
titrp001Tool Types
titrp003Tool Kits

 

Project

Refer to functions ipdm0099 and ipdm0112

TableDescription
tppdm001User Defaults
tppdm002Map Session Options by User
tppdm005Item Project Data
tppdm006Item Project Data (Defaults)
tppdm015Labor
tppdm016Trade Groups
tppdm025Equipment
tppdm035Subcontracting
tppdm040Sundry Costs
tppdm043Revenues
tppdm045Third Party Types
tppdm046Third Parties
tppdm048Responsibilities
tppdm049Employees by Responsibility
tppdm051Competitors
tppdm053Appointment Types
tppdm055Business Sectors
tppdm057Sufferance Tax
tppdm059Financing Methods
tppdm063Project Acquiring Methods
tppdm065Project Groups
tppdm069Document Types
tppdm075Categories
tppdm085Phases
tppdm090Standard Elements
tppdm110Standard Activities
tppdm139Revenue Codes of Standard Activities
tppdm141Revenue Codes of Standard Elements
tppdm142Revenue Codes of Progress Invoicing Elements
tppdm143Revenue Codes Cost Plus (General and by Cost Type)
tppdm144Revenue Codes Cost Plus (Material)
tppdm145Revenue Codes Cost Plus (Labor)
tppdm146Revenue Codes Cost Plus (Equipment)
tppdm147Revenue Codes Cost Plus (Subcontracting)
tppdm148Revenue Codes Cost Plus (Sundry Costs)
tppdm151Price Fluctuations
tppdm152Index Tables of Price Fluctuations
tppdm153Index Tables of Material Price Fluctuations
tppdm155Financial Result Types
tppdm170Standard Surcharges (General and by Cost Type)
tppdm171Standard Surcharges by Cost Component
tppdm172Standard Surcharges by Material
tppdm173Standard Surcharges by Labor
tppdm174Standard Surcharges by Equipment
tppdm175Standard Surcharges by Subcontracting
tppdm176Standard Surcharges by Sundry Cost
tppdm177Standard Surcharges by Revenue
tppdm750Buy-from Items
tppdm751Buy-from File Layouts
tppdm752Discount Groups by Buy-from
tppdm754Units by Buy-from
tppdm758Items by Buy-from's Discount Group
tppdm801Employee Project Data

 

Warehousing

Refer to whwmddll0009

TableDescription
whina101Item Valuation Groups
whina102Warehouse Valuation Groups
whina200Forecast Methods
whinh005Warehousing Procedures
whinh010Warehousing Order Types
whinh620Priority Definitions
whltc100Lots
whltc101Lost Cost Details
whltc103Lot Inventory Variances
whltc104Lot Inventory Variance Cost Details
whltc110Lot Selection Codes
whltc500Serials by Warehouse
whltc501Serial Price Transactions
whltc502Serial Price Transaction Cost Details
whwmd130Remarks
whwmd200Warehouses
whwmd300Locations
whwmd310Zones
whwmd400Item Warehousing Data
whwmd410Package Definitions
whwmd430Package Definitions by Item
whwmd520Label Layouts