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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

71 columns | Print definition?ERP 6.0  | CITY1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values5CITY1Citynvarchar400
2/FLDQ/AD_INI_ERRRecord records which encounter an error in RSADRINI22CITY1Citynvarchar400
3/FLDQ/AD_INI_IDXCopy of Shadow Table /fldq/ad_mtc_sh22CITY1Citynvarchar400
4/FLDQ/AD_MTCCODEFirstLogic Match Code Index Table22CITY1Citynvarchar400
5/FLDQ/AD_MTCRSLTMatch Results table to store results from RSADRINI program23CITY1Citynvarchar400
6/FLDQ/AD_MTC_SHFirstLogic Shadow table for /FLDQ/AD_MTCCODE22CITY1Citynvarchar400
7/FLDQ/AD_MTC_SH2FirstLogic Shadow table for /FLDQ/AD_MTCCODE22CITY1Citynvarchar400
8/FLDQ/AD_PUPDATEMatchcode Records pending to be updated22CITY1Citynvarchar400
9/FLDQ/AD_QTRRVWCleansed addresses from RSADRQU2 to review before comitting19CITY1Citynvarchar400
10/FLDQ/AD_QU_INDXQU2 Index Table15CITY1Citynvarchar400
11/FLDQ/BPMTCCDGenerated Match Code Table for BP7CITY1Citynvarchar400
12/FLDQ/BPMTCDISPGenerated Display Table for BP7CITY1Citynvarchar400
13/FLDQ/BPMTCPUDGenerated Pending Update Table for BP7CITY1Citynvarchar400
14/FLDQ/BPMTCSHDWGenerated Match Shadow Table for BP7CITY1Citynvarchar400
15/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK6CITY1Citynvarchar400
16/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK6CITY1Citynvarchar400
17/FLDQ/HNA_BM_INHANA task Batch Match Input Records15CITY1Citynvarchar400
18/FLDQ/HNA_PREQU2staging table for RSADRQU2 report15CITY1locality with increased size to stop truncationnvarchar2000
19/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report15CITY1locality with increased size to stop truncationnvarchar2000
20/SAPSRM/SH_PLANTTable for ERP Search Help Plants8CITY1Citynvarchar400
21CNVTDMS_11_SCADRScrambling Addresses8CITY1Citynvarchar400
22TIVXCNLHPCITYHighly populated cities2CITY1Citynvarchar400
23T7PIQ_NL_INSBRINBRIN Number of the Institute7CITY1Citynvarchar400
24T7PIQ_NL_INSTITInstitutes and Education Details16CITY1Citynvarchar400
TOPAddress ManagementBusiness Address
25ADRCAddresses (Business Address Services)13CITY1Citynvarchar400
26ADRCSShadow Table: Addresses (Business Address Services)14CITY1Citynvarchar400
27ADRCS2Shadow Table 2: Addresses (Business Address Services)15CITY1Citynvarchar400
TOPBank Customer Accounts
28BCA_US_BC_ADDRAddresses Associated with Bank Cheques32CITY1Citynvarchar400
TOPBasic Functions
29FSLSAForeign Trade: Legal Control-Sanctioned Party List-Address9CITY1Citynvarchar400
TOPBasis Components
30/XFT/INV_Q_6PO details (header) for an invoice receipt process32CITY1Citynvarchar400
31/XFT/INV_Q_6_SPO details (header) for an invoice receipt process32CITY1Citynvarchar400
TOPChina
32PA0528HR Master Record: Infotype 0528 (Family information)53CITY1Citynvarchar400
TOPClaims Management
33ICLX_PARTICIPANTError Table for Participants with XI Input21CITY1Participant: Participant Citynvarchar400
TOPCollectionsDisbursements
34VVSCPOSESRPayment Plan Item: ISR Attachment12CITY1Citynvarchar400
TOPContract Accounts Receivable and Payable
35DFKKESRPOR Payment Supplement10CITY1Citynvarchar400
36DFKKGP_SHORTData Extract: BP Data7CITY1Citynvarchar400
37DFKKZAXRepayment Request (Address Data for Check)5CITY1Citynvarchar400
38FKK_GPSHADData Extract: Business Partner Data (Faster Access)15CITY1Citynvarchar400
TOPFinancial Accounting
39AC400ADRCP01 Adressen für Programm AC400DEBITOR13CITY1Ortnvarchar400
TOPGlobal Trade Services
40/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit20CITY1Citynvarchar400
41/SAPSLL/SPLAUDLegal Control - SPL - Audit53CITY1Citynvarchar400
TOPHong Kong
42PA0345HR Master Record: Infotype 0345 (Hong Kong Tax)30CITY1Citynvarchar250
TOPLocalization
43J_1BNFCPDNota Fiscal one-time accounts33CITY1Citynvarchar400
TOPLocations Location Structure
44EHFNDD_LOC_REVLocation - Revisions26CITY1Citynvarchar400
TOPMaster Data
45EBP_ADDR_SERVICESearch Index for Business Partner Service Addresses8CITY1City name in upper case for search helpnvarchar250
46EFISELField Selection Control for Address Data13CITY1Locationnvarchar10
47TECHSTRChanges to Street Names4CITY1Citynvarchar400
TOPMaterials Management
48/ISDFPS/1DPERHEHS: Single Permit Header19CITY1Citynvarchar400
TOPMove-InOut
49ECAMIOPRADDRIS-U: Parked Document: Addresses (Business Partner)16CITY1Citynvarchar400
TOPNon Profit Organizations
50PA3244HR Master Record: Infotype 324427CITY1NPO Citynvarchar600
TOPOffer and Rental Request
51VIOROOOffered Object64CITY1Citynvarchar400
52VIORRRRental Request76CITY1Citynvarchar400
TOPPayroll
53T5HPBS06Technikai azonosító (1) - Közigazgatási szerv5CITY1Helységnvarchar400
54T5HPBS07Szervezeti egységek címe4CITY1Helységnvarchar400
TOPPersonnel Administration
55T7PLD1Payee data18CITY1Citynvarchar400
56T7PLD2GUS reporting entity data7CITY1Citynvarchar400
TOPPhilippines
57PA0634Philippines Previous Employer Information Info-type26CITY1Prev Employer's Citynvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
58DFMCA_BRF540BRF: Create Address for Business Partner10CITY1BRF: Expressionnvarchar200
59DFMCA_BRF750BRF: Address Check7CITY1BRF: Expressionnvarchar200
60DFMCA_BRF760BRF: Read Location7CITY1BRF: Expressionnvarchar200
61DFMCA_BRF770BRF: Create Location11CITY1BRF: Expressionnvarchar200
62DFMCA_BRF820BRF: Address Autocorrection9CITY1Field Namenvarchar300
TOPSales Promotions
63SADLSTRECBDynamic Part of Address List (Record Body)29CITY1Citynvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
64TN50ADefault Values for ASL and ISTAT Code2CITY1Citynvarchar400
TOPSAP NetWeaver Mobile - Use subcomponents
65MEREP_ADDRESSAddress (Sample Application)4CITY1City1 (Sample Application)nvarchar400
TOPStakeholder Relationship Management
66USC_CONT_ADDSRM Contact: Event Info12CITY1Citynvarchar400
TOPWaste Management
67EEWA_CIC_FILTABIS-U CIC for Waste: Store Filter Data6CITY1Citynvarchar400
68EHSWAT_APPBPMD: Waste Permit Partner32CITY1Citynvarchar400
69EHSWAT_MNBPWaste Manifest/Delivery Note: Partners29CITY1Citynvarchar400
70EPROP_ADRFLD_SELField Selection Control for Address Screen of Property13CITY1Locationnvarchar10
71EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object13CITY1Locationnvarchar10