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

26 columns | Print definition?ERP 6.0  | TRANSPZONE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values27TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
2/FLDQ/AD_QTRRVWCleansed addresses from RSADRQU2 to review before comitting36TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
3/FLDQ/AD_QU_INDXQU2 Index Table35TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
4/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK28TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
5/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK28TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
6/FLDQ/HNA_PREQU2staging table for RSADRQU2 report35TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
7/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report35TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
8BBP_PCPOSProcurement Card Statement: Position Data48TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
9BBP_SUS_STG_ADRStaging address table38TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
10BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses39TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
11BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address39TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
12REQADDRESSDelivery Address for Requirement Coverage Request Lines60TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
13PIQDB_NL_ADDRMaintain GBA Address41TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
TOPAddress ManagementBusiness Address
14ADRCAddresses (Business Address Services)35TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
15ADRCITYPostal cities9TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
16ADRCSShadow Table: Addresses (Business Address Services)36TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
17ADRCS2Shadow Table 2: Addresses (Business Address Services)37TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
18ADRDIF_CTCity Difference Table for Quarterly Adjustment18TRANSPZONETransportation zonenvarchar100
TOPBank Customer Accounts
19BCA_US_BC_ADDRAddresses Associated with Bank Cheques41TRANSPZONETransportation zonenvarchar100
TOPFinancial Accounting
20AC400ADRCP01 Adressen für Programm AC400DEBITOR35TRANSPZONETransportzone, in die bzw. aus der geliefert wirdnvarchar100
TOPGlobal Trade Services
21/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit42TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
22/SAPSLL/SPLAUDLegal Control - SPL - Audit75TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
TOPLocalization
23J_1BNFCPDNota Fiscal one-time accounts55TRANSPZONETransportation zone to or from which the goods are deliverednvarchar100
TOPMaster Data
24EFISELField Selection Control for Address Data34TRANSPZONETransportation zone to or from which the goods are deliverednvarchar10
TOPWaste Management
25EPROP_ADRFLD_SELField Selection Control for Address Screen of Property34TRANSPZONETransportation zone to or from which the goods are deliverednvarchar10
26EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object34TRANSPZONETransportation zone to or from which the goods are deliverednvarchar10