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

85 columns | Print definition?ERP 6.0  | POSNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing39POSNOOrder Itemnvarchar60
2AIS_LAYOUT_MRTABKey Figures on CfaR Tab for Std Rep. on RDB (Period ALV)4POSNODisplay Sequence of Key Figuresnvarchar20
3AIS_LAYOUT_MRTB2Key Figures on CfaR Tab for Std Rep. on RDB (Period ALV)4POSNODisplay Sequence of Key Figuresnvarchar20
4BKK_OPD_IT_EXTExternal Item Selection Table - Outgoing Payment Dispatcher4POSNOItem in Payment Ordernvarchar50
5BKK_SEPA_LIM_EVEvent Table for Mandate Limits6POSNOPosition in Itemnvarchar30
6BKK_SEPA_LIM_HISHistory Table for Mandate Limits7POSNOPosition in Itemnvarchar30
7PA3366HR Master Record: Infotype 336627POSNOPost box or private bag numbernvarchar80
8PB3366Applicant data infotype 3366 (model)27POSNOPost box or private bag numbernvarchar80
9TNWAT_FREQULeistungsgenerierung für ambulante Besuche9POSNOIS-H: Positionsnummernvarchar40
10TNWCHSDRG03Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte Medikamente10POSNOIS-H CH: Positionsnummernvarchar40
11TNWCH_ADDCHARGELeistungsregel: Altersprüfung bei Zusatzentgelten9POSNOIS-H CH: Positionsnummernvarchar40
12TNWCH_ATC_RELStatistikrelevante ATC-Codes5POSNOIS-H CH: Positionsnummernvarchar40
TOPAccount Management
13BKKITNTCNotice: Payment Item with Notice Lock Period > 06POSNOPosition in Itemnvarchar30
TOPAerospace Defence Industry Solution
14DIT434PStock determination: FS item table5POSNOStock determination: Item numbernvarchar30
TOPALE Integration Technology
15EDISYNSyntax Description for Extended Basic Types3POSNOSequential Number of Segment in IDoc Typenvarchar40
16EDSYNIDoc syntax after 3.02POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPBank Customer Accounts
17BKKCORRITEMAuxiliary Table: Payment Items for Adjustments4POSNOPosition in Itemnvarchar30
18BKK_PRENOTEPrenotes36POSNOPosition in Itemnvarchar30
TOPChina
19PA0536HR Master Record: Infotype 0536 (Administration)41POSNOPosition numbernvarchar10
TOPConfiguration management
20IBSTCMIB: Conf.Mang.:Structure12POSNOIB: Item numbernvarchar40
TOPCustomer Bill of Services
21BOSPS_ATTRBOSBOS PS Object link attribute references3POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPCustomer Contact
22BPCTPOSFORMObject Relationships for BP Contact: Attribute Values3POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPGeneral Object Relations
23SRABRELSDObject relationship: attribute position assignment logistics3POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPGL transfer
24BKKC12_ITEMGL: New Balances for Balance Sheet Preparation (Items)4POSNOPosition in Itemnvarchar30
25BKKCNOITGLTable of Items not Updated on the Account4POSNOPosition in Itemnvarchar30
26BKKITGLGen. Ledger: Payment Item Data4POSNOPosition in Itemnvarchar30
TOPInformation System
27AIS_LAYOUT_BTTABKey Figs for Backtesting Tab Page in Std Report for RDB4POSNODisplay Sequence of Key Figuresnvarchar20
28AIS_LAYOUT_FLTABKey Figures on PA Flow Tab for Standard Reporting on RDB4POSNODisplay Sequence of Key Figuresnvarchar20
29AIS_LAYOUT_MATABKey Figures on Mat. Band Tab for Standard Reporting on RDB4POSNODisplay Sequence of Key Figuresnvarchar20
30AIS_LAYOUT_PHFRMKey Figures in PH Frame for Standard Reporting on the RDB4POSNODisplay Sequence of Key Figuresnvarchar20
31AIS_LAYOUT_RHTABKey Figures on RH Tab for Standard Reporting on the RDB4POSNODisplay Sequence of Key Figuresnvarchar20
32AIS_LAYOUT_SSTABKey Figures on Line Items Tab for Standard Rep. on RDB4POSNODisplay Sequence of Key Figuresnvarchar20
TOPInstalled Base
33IBSTIB: Installation Component - Structure12POSNOIB: Item numbernvarchar40
34T371YIBase: Tabstrip Control2POSNOIB: Item numbernvarchar40
TOPLogistics - General
35CRMVBREF2SD Object Link to Item References3POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPLogistics Basic Data
36T434PStock determination: FS item table5POSNOStock determination: Item numbernvarchar30
TOPMaster Data
37BCA_US_HLD2RELHold Records which have not been released - Dual Control22POSNOPosition in Itemnvarchar30
38BCA_US_HOLDHold Amounts Which Affect Available Balance21POSNOPosition in Itemnvarchar30
TOPMedia Product
39JPTTTLLNKATTRAttributes for Generic Title Object Relationship3POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPOffer and Rental Request
40TIVORHMATTRAAccommodation Attributes5POSNOPosition Numbernvarchar20
41TIVORHMATTRPPersonnel Attributes5POSNOPosition Numbernvarchar20
TOPPatient Accounting
42TNRS2_CTIS-H: Check Procedure for Rules - Case Category Restriction7POSNOIS-H: Item Numbernvarchar40
TOPPayment Item
43BKKI3Turnover Items Not Posted for Last Bank Statement4POSNOPosition in Itemnvarchar30
44BKKITPayment Item4POSNOPosition in Itemnvarchar30
45BKKITADRPayment Item: Address of Transferring Party4POSNOPosition in Itemnvarchar30
46BKKITAIInfo Items for Interest Penalty at Balancing4POSNOPosition in Itemnvarchar30
47BKKITENQBlocked Payment Items4POSNOPosition in Itemnvarchar30
48BKKITPREParked Payment Items6POSNOPosition in Itemnvarchar30
49BKKITRELPayment Item4POSNOPosition in Itemnvarchar30
50BKKITTMPPlanned Payment Items4POSNOPosition in Itemnvarchar30
51BKKITTMP_DELPlanned Payment Items - Completed4POSNOPosition in Itemnvarchar30
52BKKNTPurpose4POSNOPosition in Itemnvarchar30
53BKKNTTMPPayment Notes of Planned Payment Items4POSNOPosition in Itemnvarchar30
TOPPayment Order
54BKKPOITItem in Payment Order4POSNOItem in Payment Ordernvarchar50
55BKKPOIT_TMPItems in Planned Payment Order4POSNOItem in Payment Ordernvarchar50
56BKKPOIT_TMP_DELItems in Planned Payment Order4POSNOItem in Payment Ordernvarchar50
57BKKPONTPayment Order, Application of Funds4POSNOItem in Payment Ordernvarchar50
58BKKPONT_TMPPlanned Payment Order, Payment Details4POSNOItem in Payment Ordernvarchar50
59BKKPONT_TMP_DELPlanned Payment Order, Payment Details4POSNOItem in Payment Ordernvarchar50
TOPReport Selection for Product Costing
60TKKR4Hierarchy Summarization (Summarized Object Types)10POSNOSequence for Summarization Object Typenvarchar20
TOPRisk Analysis
61JBRRMBMAssignment of Characteristics to Analysis Structures5POSNORM: Position of Characteristic in Characteristics Entrytinyint30
TOPSales
62VBREFSD Object Link to Item References3POSNOSequential Number of Segment in IDoc Typenvarchar40
TOPSAP Business Partner
63TB040FBDT: Selection and Display Fields of Evaluation6POSNOBP: Item no. on selection screen in relation to section no.nvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
64/ISHFR/NVVW_TDAIndividual Contract Scheme Item Data - Time-Dependent5POSNOIS-H: Item Numbernvarchar40
65/ISHFR/TN16P_TDAItems for Contract Schemes - Time-Dependent4POSNOIS-H: Item Numbernvarchar40
66/ISHFR/TNGAPPIS-H FR: Supplements (Item Data)10POSNOIS-H: Item Numbernvarchar40
67/ISHFR/TNWFR_F10IS-H FR: Per Diem Fee13POSNOItem Numbernvarchar40
68NCH40IS-H CH: Service Rules Billability/Flat Rate Consolidation16POSNOIS-H CH: Item numbernvarchar40
69NCH43IS-H CH: Leistungsregeln Zuschlagsleistungen15POSNOIS-H CH: Numero posizionenvarchar40
70NCH43AIS-H CH: Rollenumschlüsselung für Arztzuordnungen14POSNOIS-H CH: Numero posizionenvarchar40
71NCH44IS-H CH: Leistungsregeln OPS14POSNOIS-H CH: Numero posizionenvarchar40
72NCH44AIS-H CH: Rollenumschlüsselung für Arztzuordnungen13POSNOIS-H CH: Numero posizionenvarchar40
73NCH45IS-H CH: Leistungsregeln Radiologie6POSNOIS-H CH: Numero posizionenvarchar40
74NVVWIS-H: Individual Contract Schemes Item Data5POSNOIS-H: Item Numbernvarchar40
75TN16PIS-H SG: Contract Scheme Items4POSNOIS-H: Item Numbernvarchar40
76TNA40SIS-H AT: Leistungsregeln Höchstwertstaffelung7POSNOIS-H CH: Positionsnummernvarchar40
77TNA40VIS-H AT: Leistungsregeln Abrechenbarkeit/Pauschalierung12POSNOIS-H CH: Positionsnummernvarchar40
78TNAUMLEIIS-H AT: Umschlüsselung Leistung16POSNOIS-H CH: Positionsnummernvarchar40
79TNCH51IS-H CH: Billing Agreement Items4POSNOIS-H CH: Item numbernvarchar40
80TNWAT_SCOEWKOMMIS-H AT: Scoring - Std-Kommentar für akzept. Errors/Warnings4POSNOIS-H AT: Positionsnummernvarchar40
81TNWCHSDRG02Swiss-DRG - Leistungsregeln DRG-Zusatzentgelte generieren11POSNOIS-H CH: Positionsnummernvarchar40
82TNWCH_AL_EXTRAIS-H CH: ANALYSE - Leistungsregeln Zuschlagsleistungen16POSNOIS-H CH : numéro de postenvarchar40
TOPSCM Basis
83CIFERRLOGError Recording in Enhanced CIF Error Handling27POSNOItem Number of Document (Purchasing, Sales...)nvarchar60
TOPTransportation and Distribution
84OIGSMSTD Material Samples on a Shipment4POSNOSequential Number of Segment in IDoc Typenvarchar40
85OIGSVCSTD Vehicle Seals on Transport Units5POSNOItem number (2 digits)nvarchar20