Main SAP tables

Main SAP tables

Basis
MM
DDIC (domain, data elements…)
Orders (Production orders…)
Transport orders
SD – Sales and distribution
LE – Logistic and execution
CO documents
Work center (Poste de travail)


Basis

  • T001 : Company code (Société)
  • T001W : Plants/Branches (Divisions/Filiales)


MM

  • MA07V : View with MARA and MARC
  • V_MARA_MAKT_MARC : View with MARA, MAKT, MARC (in S4 systems)


DDIC

  • DD01L : DB tables with List of domains
  • DD02L : DB table with list of table names
  • DD03L : DB tables with list of field names linked to table or structures
  • DD04L : DB tables with list of data element
  • DD03M : DB view with field names (and infos like SE11 + DATA EL. descriptions)
  • DD07L : DB tables with values of domains
  • DD07V : DB view with values of domains and associated descriptions

Search tag: domaine, élément, donnée


Orders

  • AUFK : Order master data (Ordres – données de base)
  • AFKO : Order header data PP orders (Données d’en-tête des ordres PCP)
  • AFPO : Order item (Poste d’ordre)
  • RESB : Reservation/dependent requirements (Composants – Réservation / besoin dépendant)
  • AFVC : Operation within an order (Opération d’ordre)
  • CAUFV : View header data (Vue données d’en-tête ordre)

Search tag: prodord, production order, ordre de fabrication


Transport orders

  • E070 : List of transport request (TR)
  • V_E071EU : (View) Items in a Correction E070 + E071

Search tag: TO, TR, Transport request, ordre de transport, OT


SD – Sales and distribution

  • TVKO : Sales organization (Organisation d’achat) – Link VKORG – BURKS
  • TVTW : Distribution Channel (Canal de distribution)
  • TVKOV : Relation between VKORG and VTVEG


LE – Logistic and execution

  • LIKP : SD Document: Delivery Header Data (En-tête livraison)
  • LIPS : SD document: Delivery: Item data (Postes livraison)
  • VTTK : Shipment Header (En-tête Transport)
  • VTTP : Shipment Item (Postes Transport)
  • LTBK : Transfer requirement header (En-tête : Ordre de transfert)
  • LTBP : Transfer requirement item (Postes : Ordre de transfert)
  • LTAK : Transfer order header (En-tête : Ordre de transport)
  • LTAP : Transfer order item (Postes : Ordre de transport)
  • LQUA : Quant (Quantité)
  • LAGP : Storage bins – LGPLA (Emplacements)
  • VBFA : Links between Sales order / Deliveries / Transports
  • VTFA : Links between Deliveries / Transports / Handling Unit (HU)

Search tag: unités de manutention, UM, TR, TO


CO documents

  • COBK : CO Object: Document Header
  • COEP : CO Object: Line Items (by Period)

Search tag: Controlling, controle de gestion

To be completed…


Work center (poste de travail)

  • CRHD : Workcenter Header Data
  • CRCA : Workcenter Capacity Allocation
  • CRCO : Workcenter Cost Center Assignment
  • CRHH : Hierarchy Header
  • CRHS : Hierarchy Structure
  • CRTX : Workcenter Text

About the author

fjourneau administrator

Hi, I'm Florian Journeau, SAP ABAP R3 Freelance, based in Toulouse, France. You want to know more about me, have a look on my CV : cv.fjourneau.net.

1 Comment so far

lana.21Posted on9:41 am - Mar 26, 2020

Great blog thank you! Feel free to check mine out.

Leave a Reply