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

64 columns | Print definition?ERP 6.0  | TAXJURCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values52TAXJURCODETax Jurisdictionnvarchar150
2/FLDQ/AD_QTRRVWCleansed addresses from RSADRQU2 to review before comitting50TAXJURCODETax Jurisdictionnvarchar150
3/FLDQ/AD_QU_INDXQU2 Index Table51TAXJURCODETax Jurisdictionnvarchar150
4/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK53TAXJURCODETax Jurisdictionnvarchar150
5/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK53TAXJURCODETax Jurisdictionnvarchar150
6/FLDQ/HNA_PREQU2staging table for RSADRQU2 report51TAXJURCODETax Jurisdictionnvarchar150
7/FLDQ/HNA_PSTQU2Result Table for RSADRQU2 report51TAXJURCODETax Jurisdictionnvarchar150
8/OPT/AT_APPR_HISApproval History for Level Based Approvals53TAXJURCODETax Jurisdictionnvarchar150
9/OPT/AT_LBA_LOGApproval History for Level Based Approvals54TAXJURCODETax Jurisdictionnvarchar150
10/ORS/INV_ADDInvoice Add8TAXJURCODETax Jurisdictionnvarchar150
11BBP_PCACCProcurement Card: Accounting Data11TAXJURCODETax Jurisdictionnvarchar150
12BBP_PCLOGProcurement Card Statement: Logistic data20TAXJURCODETax Jurisdictionnvarchar150
13BBP_PCMODProcurement Card: Modified Statement Data13TAXJURCODETax Jurisdictionnvarchar150
14BBP_PCPOSProcurement Card Statement: Position Data37TAXJURCODETax Jurisdictionnvarchar150
15BBP_PCTAXProcurement Card: Tax Data7TAXJURCODETax Jurisdictionnvarchar150
16BBP_SUS_STG_ADRStaging address table36TAXJURCODETax Jurisdictionnvarchar150
17BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses37TAXJURCODETax Jurisdictionnvarchar150
18BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address37TAXJURCODETax Jurisdictionnvarchar150
19CNVTDMS_11_SCADRScrambling Addresses33TAXJURCODETax Jurisdictionnvarchar150
20REQADDRESSDelivery Address for Requirement Coverage Request Lines81TAXJURCODETax Jurisdictionnvarchar150
21REQLINESRTemporary Line Data: Requirement Coverage Request (Services)47TAXJURCODETax Jurisdictionnvarchar150
22T7BRCITYMunicipality code by postal code interval6TAXJURCODEBrazilian municipality codenvarchar150
23T7BRCITY_TEXTText table for Brazilian municipality code4TAXJURCODEBrazilian municipality codenvarchar150
24PIQDB_NL_ADDRMaintain GBA Address39TAXJURCODETax Jurisdictionnvarchar150
TOPAddress ManagementBusiness Address
25ADRCAddresses (Business Address Services)83TAXJURCODETax Jurisdictionnvarchar150
26ADRCITYPostal cities8TAXJURCODETax Jurisdictionnvarchar150
27ADRCSShadow Table: Addresses (Business Address Services)84TAXJURCODETax Jurisdictionnvarchar150
28ADRCS2Shadow Table 2: Addresses (Business Address Services)85TAXJURCODETax Jurisdictionnvarchar150
29ADRDIF_CTCity Difference Table for Quarterly Adjustment15TAXJURCODETax Jurisdictionnvarchar150
30ADRDIF_STStreet Difference Table for Quarterly Adjustment32TAXJURCODETax Jurisdictionnvarchar150
31ADRSTREETStreets9TAXJURCODETax Jurisdictionnvarchar150
32ADRSTRPCDStreet (section)/postal code: Assignment13TAXJURCODETax Jurisdictionnvarchar150
TOPBasis Components
33/XFT/INV_Q_1Invoice receipt queue: Items12TAXJURCODETax Jurisdictionnvarchar150
34/XFT/INV_Q_11Account assignment data8TAXJURCODETax Jurisdictionnvarchar150
35/XFT/INV_Q_11_SAccount assignment data8TAXJURCODETax Jurisdictionnvarchar150
36/XFT/INV_Q_1_SInvoice receipt queue: Items12TAXJURCODETax Jurisdictionnvarchar150
TOPCountry-Specific Objects
37COMC_TAXJUR_CITYTax Jurisdiction codes by City5TAXJURCODETax Jurisdictionnvarchar150
38COMC_TAXJUR_REGTax Jurisdiction codes by region4TAXJURCODETax Jurisdictionnvarchar150
39COMC_TAXJUR_REGTTax Jurisdiction codes by region5TAXJURCODETax Jurisdictionnvarchar150
40COMC_TAXJUR_ZPCDTax Jurisdiction Codes by Range of Postal Codes6TAXJURCODETax Jurisdictionnvarchar150
41CRMC_TAX_JURTax jurisdiction code values3TAXJURCODETax Jurisdictionnvarchar150
42CRMC_TAX_JUR_TXTTax jurisdiction code text4TAXJURCODETax Jurisdictionnvarchar150
TOPDown Payment Chains
43/SAPPCE/TDPC01Down Payment Chains41TAXJURCODETax Jurisdictionnvarchar150
44/SAPPCE/TDPC21Down Payment Chain: Document Segments24TAXJURCODETax Jurisdictionnvarchar150
TOPFinancial Accounting
45AC400ADRCP01 Adressen für Programm AC400DEBITOR83TAXJURCODESteuerstandortnvarchar150
TOPGL Account Posting
46TCJ_POSITIONSCash Journal Document Items92TAXJURCODETax Jurisdictionnvarchar150
TOPGlobal Trade Services
47/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit67TAXJURCODETax Jurisdictionnvarchar150
48/SAPSLL/SPLAUDLegal Control - SPL - Audit100TAXJURCODETax Jurisdictionnvarchar150
TOPLocalization
49J_1BNFCPDNota Fiscal one-time accounts80TAXJURCODETax Jurisdictionnvarchar150
50J_1BSERVASSIGN1Assignment of Official to Generic Service Types4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
51J_1BSERVASSIGN2Assignment of Official Service Types to Material Numbers4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
52J_1BSERVASSIGN3Assignment of Official Service Types to Service Numbers4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
53J_1BSERVTYPES1Official Brazilian Service Types - Incoming3TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
54J_1BSERVTYPES1TTexts For Official Brazilian Service Types - Incoming4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
55J_1BSERVTYPES2Official Brazilian Service Types - Outgoing3TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
56J_1BSERVTYPES2TTexts For Official Brazilian Service Types - Outgoing4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
57J_1BTREG_CITYTax Jurisdiction Codes by Range of Postal Codes6TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
58J_1BTXISSTax Calculation: ISS4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
59J_1BTXJURTax Jurisdiction Codes For Brazilian Tax Calculation3TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
60J_1BTXJURTText Table For Brazilian Tax Jurisdiction Codes4TAXJURCODETax Jurisdiction Code For Brazilian Tax Calculationnvarchar150
TOPMaster Data
61EFISELField Selection Control for Address Data49TAXJURCODEJurisdiction for tax calculation - tax jurisdiction codenvarchar10
TOPMove-InOut
62ECAMIOPRADDRIS-U: Parked Document: Addresses (Business Partner)34TAXJURCODETax Jurisdictionnvarchar150
TOPWaste Management
63EPROP_ADRFLD_SELField Selection Control for Address Screen of Property49TAXJURCODEJurisdiction for tax calculation - tax jurisdiction codenvarchar10
64EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object49TAXJURCODEJurisdiction for tax calculation - tax jurisdiction codenvarchar10