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

90 columns | Print definition?ERP 6.0  | COUNTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_CHKSTATTable to temporarily hold the check status values60COUNTYCountynvarchar400
2/FLDQ/HNACLNSOUTDQM for SAP output table for transactional cleanse TASK61COUNTYCountynvarchar400
3/FLDQ/HNACLNSTSKDQM for SAP input table for transactional cleanse TASK61COUNTYCountynvarchar400
4ADRCOUNTYTCounty (long texts)6COUNTYCountynvarchar400
5BBP_PCPOSProcurement Card Statement: Position Data77COUNTYCountynvarchar400
6BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses60COUNTYCountynvarchar400
7BBP_TMP_ZA_ORGTemporary: Request 'Bidder', Company Address60COUNTYCountynvarchar400
8HRP1660DB Table for Infotype 166021COUNTYDuty Station Countynvarchar30
9OIUX3_TX_LEASE_DTax Reporting - Texas Lease Description3COUNTYTexas County Identifiernvarchar30
10PIQDB_DE_TRHTranscript Header5COUNTYCounty Codenvarchar30
11T7PIQ_DE_COUNTYValue Table for Counties4COUNTYCounty Codenvarchar30
12T7PIQ_DE_COUNTYTText Table for Counties5COUNTYCounty Codenvarchar30
13T7PIQ_DE_MTCNTPCMapping Table County to Postal Code3COUNTYCounty Codenvarchar30
14PIQDB_NL_ADDRMaintain GBA Address62COUNTYCountynvarchar400
15T7PIQ_GB_COUNTYMGB: Mapping table SAP country & county codes to UCAS/HESA3COUNTYRegion (State, Province, County)nvarchar30
16T7PIQ_GB_SCHOOLUCAS: Schools31COUNTYDescriptionnvarchar200
TOPAddress ManagementBusiness Address
17ADRCAddresses (Business Address Services)94COUNTYCountynvarchar400
18ADRCSShadow Table: Addresses (Business Address Services)95COUNTYCountynvarchar400
19ADRCS2Shadow Table 2: Addresses (Business Address Services)93COUNTYCountynvarchar400
20SADRAddress Management: Company Data51COUNTYCountynvarchar400
TOPClaims Management
21ICLCCEVENTRClaim Bundle - Region - Assignment6COUNTYCounty Codenvarchar30
22ICLLITITEMLitigation Level19COUNTYVenue: Countynvarchar30
23ICSCCEVENTRClaim Bundle - Region - Assignment6COUNTYCounty Codenvarchar30
24ICSLITITEMLitigation Levels19COUNTYVenue: Countynvarchar30
TOPContract Accounts Receivable and Payable
25FKKVKPContract Account Partner-Specific70COUNTYCounty Codenvarchar30
TOPGlobal Trade Services
26/SAPSLL/PREVDAUDSLL: Preference: Vend.Decl. for Customer Purp.: Audit75COUNTYCountynvarchar400
27/SAPSLL/SPLAUDLegal Control - SPL - Audit108COUNTYCountynvarchar400
TOPLocalization
28J_1BNFCPDNota Fiscal one-time accounts88COUNTYCountynvarchar400
TOPMaster Data
29EFISELField Selection Control for Address Data70COUNTYDistrict (US: County)nvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
30TFICA_DEFSamples for Contract Account Types45COUNTYCounty Codenvarchar30
TOPSales Promotions
31SADLSTRECBDynamic Part of Address List (Record Body)49COUNTYCountynvarchar400
TOPTax Reporting
32OIUX3Y_TX_MASTERTax Reporting - Texas Master Data PPN13COUNTYTexas County Identifiernvarchar30
33OIUX3_TX_CNTXRFTax Reporting - Texas County XRef1COUNTYTexas County Identifiernvarchar30
34OIUX3_TX_MASTERTax Reporting - Texas Master Data12COUNTYTexas County Identifiernvarchar30
35OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History37COUNTYTexas County Identifiernvarchar30
36OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions37COUNTYTexas County Identifiernvarchar30
37OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below38COUNTYTexas County Identifiernvarchar30
38OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental38COUNTYTexas County Identifiernvarchar30
39OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax38COUNTYTexas County Identifiernvarchar30
40OIUX3_TX_RPGDTTax Reporting - Texas Gas Report Details7COUNTYTexas County Identifiernvarchar30
41OIUX3_TX_RPGDTETax Reporting - Texas Gas Report Details Errors7COUNTYTexas County Identifiernvarchar30
42OIUX3_TX_RPODTTax Reporting - Texas Oil Report Details6COUNTYTexas County Identifiernvarchar30
43OIUX3_TX_RPODTETax Reporting - Texas Oil Report Details Errors6COUNTYTexas County Identifiernvarchar30
44OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions37COUNTYTexas County Identifiernvarchar30
45OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging37COUNTYTexas County Identifiernvarchar30
46OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions37COUNTYTexas County Identifiernvarchar30
47OIUX5Y_OK_MASTERTax 2.0 - Oklahoma Master Data PPN15COUNTYTax 2.0 - Oklahoma Countynvarchar30
48OIUX5_OK_CONFLTax 2.0 - Oklahoma Exempt Decimal Conflict6COUNTYTax 2.0 - Oklahoma Countynvarchar30
49OIUX5_OK_MASTERTax 2.0 - Oklahoma Master Data14COUNTYTax 2.0 - Oklahoma Countynvarchar30
50OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History58COUNTYTax 2.0 - Oklahoma Countynvarchar30
51OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions58COUNTYTax 2.0 - Oklahoma Countynvarchar30
52OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions60COUNTYTax 2.0 - Oklahoma Countynvarchar30
53OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count62COUNTYTax 2.0 - Oklahoma Countynvarchar30
54OIUX5_OK_RPDTTax 2.0 - Oklahoma Gross Prod Report Detail6COUNTYTax 2.0 - Oklahoma Countynvarchar30
55OIUX5_OK_RPSMTax 2.0 - Oklahoma Gross Prod Report Summary6COUNTYTax 2.0 - Oklahoma Countynvarchar30
56OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History58COUNTYTax 2.0 - Oklahoma Countynvarchar30
57OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties60COUNTYTax 2.0 - Oklahoma Countynvarchar30
58OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging58COUNTYTax 2.0 - Oklahoma Countynvarchar30
59OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions58COUNTYTax 2.0 - Oklahoma Countynvarchar30
60OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties60COUNTYTax 2.0 - Oklahoma Countynvarchar30
61OIUX5_OK_ZVOLTax 2.0 - Oklahoma Zero Volume Reporting Master5COUNTYTax 2.0 - Oklahoma Countynvarchar30
62OIUX6Y_WY_MASTERTax 2.0 - Wyoming Master Data PPN12COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
63OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist30COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
64OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions30COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
65OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions32COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
66OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History30COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
67OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging30COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
68OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions30COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
69OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
70OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
71OIUX6_WY_MASTERTax 2.0 - Wyoming Master Data11COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
72OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
73OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
74OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions52COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
75OIUX6_WY_SRPDTDTTax 2.0 - Wyoming Severance Tax Report Detail Detail8COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
76OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
77OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
78OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
79OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions50COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
80OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History49COUNTYTax 2.0 - Wyoming County Identifiernvarchar30
TOPTransaction Tax Engine
81TTED_ACQUISI_COMAcquisition11COUNTYCountynvarchar300
82TTED_PARTNER_COMPartner17COUNTYCountynvarchar300
83TTED_PARTN_O_COMPartner in OutputDocument17COUNTYCountynvarchar300
84TTEPD3_PARTNERPartner16COUNTYCountynvarchar300
85TTEPDT_ITEMPARTPersistency TTE Document item partner8COUNTYCountynvarchar300
86TTEPDT_PARTNERPersistency TTE Document business partner6COUNTYCountynvarchar300
87TTESDT_ITEMPARTDocument item partner8COUNTYCountynvarchar300
88TTESDT_PARTNERDocument business partner6COUNTYCountynvarchar300
TOPWaste Management
89EPROP_ADRFLD_SELField Selection Control for Address Screen of Property70COUNTYDistrict (US: County)nvarchar10
90EROB_ADDRFLD_SELField Selection Control for Add. Screen of Cleaning Object70COUNTYDistrict (US: County)nvarchar10