SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

91 columns | Print definition?ERP 6.0  | LFART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data21LFARTnvarchar40
2/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item22LFARTnvarchar40
3B765Sales org./Del. type5LFARTDelivery Typenvarchar40
4B850Del. type4LFARTDelivery Typenvarchar40
5EDOCLDTEDLNeDocument Chile: Assign DTE Type to Delivery Type2LFARTDelivery Typenvarchar40
6T161VShipping-Specific Data for Stock Tfr. for Purch. Doc. Type5LFARTDelivery Typenvarchar40
7T184LSales Documents: Item Category Determination2LFARTDelivery Typenvarchar40
8TVLKEDOCeDocument Delivery Types3LFARTDelivery Typenvarchar40
9TVLSPDelivery Blocks3LFARTDelivery Typenvarchar40
TOPAccount Determination
10TVARLArchiving Control for Delivery3LFARTDelivery Typenvarchar40
TOPAdditionals Management
11TWTCTRLControl table for procedures for additionals14LFARTDelivery Typenvarchar40
TOPAgency Business Global Trade
12TCWBCRBTReason for Complaint - Billing types3LFARTAgency business: Billing document typenvarchar40
13TMFKAgency Business: Billing Document Types2LFARTAgency business: Billing document typenvarchar40
14TMFKTAgency Business: Document Type Texts3LFARTAgency business: Billing document typenvarchar40
15TMFKTGAB: Transfer Groups for Billing Type2LFARTAgency business: Billing document typenvarchar40
16TMRRLAB-RRLE: Assign Remuneration List Groups to Billing Type2LFARTAgency business: Billing document typenvarchar40
17TMZRAgency Business: Payment Types6LFARTAgency business: Billing document typenvarchar40
18TMZR_PRXAB: Payment Types for eSOA Services5LFARTAgency business: Billing document typenvarchar40
19TMZR_PRX_GRPAB: Mapping Group for eSOA-Services15LFARTAgency business: Billing document typenvarchar40
20TWLFEXDetermination of Transaction Type for Intrastat Declaration3LFARTAgency business: Billing document typenvarchar40
21TWLF_WRART_LFARTAB: Allowed Combinations Payment Type / Billing Type3LFARTAgency business: Billing document typenvarchar40
22WBRKAgency business: Header3LFARTAgency business: Billing document typenvarchar40
23WZRE_C_DATANecessary Data to Create Agency Documents9LFARTAgency business: Billing document typenvarchar40
TOPAllocation
24AUPOAllocation Table Document Item50LFARTDelivery type of allocation tablenvarchar40
25AUVDIWorklist for Deliveries (Follow-on Doc. Generation)34LFARTDelivery type of allocation tablenvarchar40
26T621Item Categories for Allocation Tables7LFARTDelivery type of allocation tablenvarchar40
TOPBasic Functions
27TVLKDelivery Types2LFARTDelivery Typenvarchar40
28TVLKAIPDetermine Delivery Type for Delivery Creation Using BAPI5LFARTSales Document Typenvarchar40
29TVLKNDeliveries: Number Range per Warehouse Number and Dlv. Type3LFARTDelivery Typenvarchar40
30TVLKTDelivery: Types: Texts3LFARTDelivery Typenvarchar40
TOPComplaints and Returns
31/SPE/RET_SHP_PNTDefault shipping point determination for returns deliveries2LFARTDelivery Typenvarchar40
TOPConditions
32B009Delivery Type4LFARTDelivery Typenvarchar40
33B012Sales Organization/Delivery Type5LFARTDelivery Typenvarchar40
34B021DlvType/Shipping Point4LFARTDelivery Typenvarchar40
35B501Delivery Type / Shipping cond.4LFARTDelivery Typenvarchar40
36B910Deliv.type/Vendor4LFARTDelivery Typenvarchar40
TOPConsumption-Based Planning See Also PP-MRP
37TMDRD_DOCTPDelivery Relationshp: Document Types per Document Category4LFARTDelivery Typenvarchar40
38TWDRD_DOCTPDelivery Relationshp: Document Types per Document Category4LFARTDelivery Typenvarchar40
TOPCross-Application Topics
39/SPE/PP_DLV_TYPEDelivery Type Determination in EWM Manufacturing Integration5LFARTDelivery Typenvarchar40
TOPData Collection
40S053Shipment: shipping data9LFARTDelivery Typenvarchar40
41S053ES053 - Structural Information4LFARTDelivery Typenvarchar40
42S159W&S: Picking Waves43LFARTDelivery Typenvarchar40
43S261SD - Delivery note24LFARTDelivery Typenvarchar40
44S261BIW1SD - Delivery note24LFARTDelivery Typenvarchar40
45S261BIW2SD - Delivery note24LFARTDelivery Typenvarchar40
TOPDelivery Processing
46TVDSPProfile for Subsequent Outbound Deliv. Split per Deliv. Type3LFARTDelivery Typenvarchar40
TOPDistribution
47WCAT_V_PAYTYPEPlanned Reb. Var.: Payment Types for Vendor Billing Types3LFARTAgency business: Billing document typenvarchar40
TOPDSD Connector
48/DSD/ME_CNDLEDSD Connector: Table Listing/Exclusion Conditions4LFARTDelivery Typenvarchar40
49/DSD/ME_DELV_LFTDSD CN: Assignm. of Delivery Types to DSD Delivery Scenarios3LFARTDelivery Typenvarchar40
TOPExpenses
50TWBEXPTrading Expenses: Expense Type3LFARTAgency business: Billing document typenvarchar40
TOPGoods Issue Process
51/SPE/HU_UPDATESPE Handling Unit Update from WME to ERP4LFARTDelivery Typenvarchar40
TOPImplementation of Organizational Flexibility in Logistics
52/ISDFPS/CRELSTYRelocation Step Type6LFARTDelivery Type for Relocationnvarchar40
TOPInformation System
53MCVSRFKStatistically Relevant Fields for Order + Delivery Header5LFARTDelivery Typenvarchar40
TOPInspection
54MSR_C_INSP_PRINTConfigure Adobe Form for Inspection Worklist4LFARTDelivery Typenvarchar40
TOPInterface to Terminal Automation System
55OIK03IS-OIL/TAS: Deliveries open for goods issue6LFARTDelivery Typenvarchar40
TOPInventory Management
56MWXVM07MFields: Update Control of Module Pool SAPMM07M175LFARTDelivery Typenvarchar40
57MWZVM07MFields: Update Control of Module Pool SAPMM07M175LFARTDelivery Typenvarchar40
58WRMA_MANDTSingle Client Settings for RMA4LFARTAgency business: Billing document typenvarchar40
59WRMA_T001WDefine plant-dependent parameter for RMA3LFARTRMA billing typenvarchar40
TOPLoading Units
60/BEV1/LUTLLU: Permitted Document Types Delivery4LFARTDelivery Typenvarchar40
TOPLocalization
61J_1BNFE_PROCSettings for NF-e Business Processes6LFARTDelivery Typenvarchar40
TOPLogistics - General
62TB2BETrading Contract: Trading Contract Type67LFARTDifferent Billing Type at Contract Settlementnvarchar40
TOPMedia Sales and Distribution
63/NAM/TJKAPPL_MONApplication Access for Determination of Monitoring7LFARTDelivery Typenvarchar20
TOPMobile Materials Management
64/ISDFPS/MEMMTRTPTransfer Requirement Request Types (Mobile)3LFARTDelivery Typenvarchar40
TOPPeriodical Sales and Distribution
65JDTBZANGIS-M/SD: Mix Offer6LFARTDelivery type for mix offernvarchar20
66JVTDSPTRIS-M/SD: Planning trigger5LFARTDelivery Typenvarchar20
67JVTNCT2IS-M/SD: Tab.2 in Coll.Netchange File (Change No.-Trig.Asgt)6LFARTDelivery Typenvarchar20
68JVTNCT3IS-M/SD: Tab.3 of Coll.Netch.File (ChNo.-OrItem-Tr.-Asgt)6LFARTDelivery Typenvarchar20
69JVTVARLARTIS-M/SD: Assgmt of Shipping Schedule Variant to Deliv.Types3LFARTLogistical delivery typenvarchar20
70TJI05IS-M/SD: Basic Audit Report Category Default: Periodical SD8LFARTDelivery Typenvarchar20
71TJKABIS-M/SD: Sales Document Type-Mix Offer Assignment7LFARTDelivery type for mix offernvarchar20
72TJV77IS-M/SD: Logistical Delivery Type-Network Assignment2LFARTDelivery Typenvarchar20
TOPPersonnel Categories
73/ISDFPS/PROJ_STDefinition of Project Stock6LFARTDelivery Typenvarchar40
TOPPurchasing
74T161VNShipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc6LFARTDelivery Typenvarchar40
75T163DAssignment Internal/External Confirmation Category4LFARTDelivery Typenvarchar40
TOPRecycling Administration Core Functions
76J_7LC673REA Data Filters: Document Flow Evaluation Delivery Type4LFARTDelivery Typenvarchar40
TOPRemaining Beverage - Obsolete Objects
77/BEV1/RPDBLARTPermissible Delivery and Order Types for Dynamic Dispatch3LFARTDelivery Typenvarchar40
78/BEV1/RSLFWARoute Settlement - Delivery Types Without Auto. GI Posting3LFARTDelivery Typenvarchar40
79/BEV1/TSSSPBFEIndiv.Doc.- Permiss.Doc.Types - Column Dtld Defntn TS Stats8LFARTDelivery Typenvarchar40
TOPRoute Settlement
80/DSD/SL_DIFIACDSD Settlement: Interim Accounts14LFARTDelivery Typenvarchar40
81/DSD/SL_TCSTAMAPDSD Route Settlement:Document Ctrl.Customer Sales Trans.Type9LFARTDelivery Typenvarchar40
TOPShipping
82DVK01R/2-R/3 Link: Delivery Header Data R2 -> R326LFARTDelivery Typenvarchar40
83LIKPSD Document: Delivery Header Data9LFARTDelivery Typenvarchar40
84VBLKSD Document: Delivery Note Header3LFARTDelivery Typenvarchar40
85VLKPASD Index: Deliveries by Partner Functions7LFARTDelivery Typenvarchar40
86VLPMASD Index: Delivery Items by Material6LFARTDelivery Typenvarchar40
TOPStructures Workbench
87/ISDFPS/MATSPPLNMaterials Planned for Force Element47LFARTDelivery Typenvarchar40
TOPTransportation Management Integration
88TMS_C_SHPExt. Transport Manag.: Determination of Transfer Relev. SHP3LFARTDelivery Typenvarchar40
TOPVisit Control
89/DSD/VC_DELIVERDSD: Delivery Types for DSD3LFARTDelivery Typenvarchar40
TOPWarehouse Management
90T321Assignment MM Movement Type --> MM-WM Movement Type18LFARTDelivery Typenvarchar40
91T345Client-Dependent Control Table for WM->PP Staging6LFARTDelivery Typenvarchar40