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

156 columns | Print definition?ERP 6.0  | STATU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)23STATUnvarchar10
2/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)24STATUnvarchar10
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line23STATUnvarchar10
4/SMERP/STG_PM006Data staging - Equip List Set - Classifications - Cmplx Tab15STATUClassification statusnvarchar10
5/SMERP/STG_PM011Data staging - Func Loc. LSet - Classifications - Cmplx Tab15STATUClassification statusnvarchar10
6HRP1654Table BD pour infotype 165419STATUStatutnvarchar40
7KSSK_CONVAllocation Table: Object to Class8STATUClassification statusnvarchar10
8P08P1CLSCLASS CPX INTERFACE Snapshot Table12STATUCLASS CPX INTERFACE Statusnvarchar10
9P2NZ_LVACCPayroll Result: Leave Accruals LVACC - NZ9STATULVACC record status for NZ payrollnvarchar10
10PA0863Infotype 086325STATUStatutnvarchar40
11PA3311HR Master Record: Infotype 331132STATUPension Service Duration Statusnvarchar10
12PA3336HR Master Record: Infotype 333632STATUPension Service Duration Statusnvarchar10
13PDPBSZVADM_RSPI Confirmation: Administration Table13STATUNotification Block Status, DATUEV-ZVEnvarchar20
14PDPBSZVLOG_RSPI Confirmation: Log Table4STATUNotification Block Status, DATUEV-ZVEnvarchar20
15T020FI/AM Transaction Control6STATUProgram Status at Start of Transactionnvarchar80
16T5FPBSD10Clasification statut pour décisions2STATUStatutnvarchar40
17T5FPBSD10TLibellés classification statuts pour décisions3STATUStatutnvarchar40
18T5FPBSD4Statuts de décision par modificateur3STATUStatutnvarchar40
19T5H81TRegistered employment relationships (multiple employer)3STATUnvarchar10
20T5H82TRegistered employment relationships (multiple employer)3STATUnvarchar10
21T5RPDPersonnel Data Deletion Log4STATUStatus for Destroying Personnel Numbersnvarchar20
22T5RPLPersonnel Data Deletion Log4STATUStatus for Destroying Personnel Numbersnvarchar20
23T7INDA_STATUSStatus for DA Process3STATUStatus of the Disciplinary Actionnvarchar30
24T7INDA_STATUSTStatus text for DA4STATUStatus of the Disciplinary Actionnvarchar30
25T7RU53Employee Group/Subgroup Russia attributes4STATUEmployee Grouping for Reportingnvarchar10
26T7RU53STStatus for PSG - reporting3STATUEmployee Grouping for Reportingnvarchar10
27TCA43Automatic selection of task lists (alternatives)6STATUStatusnvarchar30
28TCLCClassification Status3STATUClassification statusnvarchar10
29TKSB0Transaction control CO7STATUProgram Status at Start of Transactionnvarchar80
30YIT_PROCIDA: Processes in IDES13STATUIDA: status of script, process, trainingnvarchar40
31YIT_STATUIDA: Status1STATUIDA: status of script, process, trainingnvarchar40
32YIT_STATULIDA: Status1STATUIDA: status of script, process, trainingnvarchar40
TOPAssortment Maintenance
33WRS1Assortment3STATUStatus of assortmentnvarchar10
TOPAustria
34PA0367HR Master Record: Infotype 0367 (SI Notification Suppl. A)26STATUStatus Information for ELDAnvarchar10
35PA0467HR Master Record: Infotype 0467 (Add'l SI Notif. f.Comp A)26STATUStatus Information for ELDAnvarchar10
36PA0526HR Master Record: Infotype 052626STATUStatus Information for ELDAnvarchar10
37T5A1OELDA: Data Records Created7STATUELDA: Status of Data Recordnvarchar10
38T5A1QELDA: Confirmed Data Records7STATUELDA: Status of Data Recordnvarchar10
TOPBasic Data
39P44VPlanning Versions15STATULIS version statusnvarchar10
TOPBasic Functions
40T852GSubgroup companies12STATUCompany statusnvarchar10
41TVBSTSD Documents: Processing Status: Texts5STATUGeneral SD statusnvarchar10
TOPChina
42PA0528HR Master Record: Infotype 0528 (Family information)40STATUJob statusnvarchar20
43T7CN65Occupation status for family member2STATUJob statusnvarchar20
44T7CN6XOccoupation status text3STATUJob statusnvarchar20
TOPClasses
45INOBLink between Internal Number and Object9STATUClassification statusnvarchar10
46KLAHClass Header Data5STATUClass statusnvarchar10
47KSSKAllocation Table: Object to Class8STATUClassification statusnvarchar10
TOPClinical System
48N1PRFALIS-H*MED: PATREG: Fälle8STATUIS-H: Olgu durumunvarchar10
49N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle50STATUIS-H: Hasta durumunvarchar10
50N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle51STATUIS-H: Hasta durumunvarchar10
51N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal51STATUIS-H: Hasta durumunvarchar10
52N2DOCFALIS-H*MED: Case Data for Archived Documents16STATUIS-H: Case Statusnvarchar10
TOPContract Accounts Receivable and Payable
53DFKKDEFREV_HEADHeader Table (Event-Based Deferred Revenues)5STATUStatus of Event-Based Deferred Revenuesnvarchar10
TOPCross-Application Component CA Enhancements
54MILL_CLPROFPProfile for Selection by Characteristics: Items18STATUYes/No (X/ )nvarchar10
TOPCross-Application Components
55FRE_MC_MCH_NODEMerchandise Category and MC-Hier. Node sent to F&R4STATUClass statusnvarchar10
TOPDefense Forces and Public Security
56/ISDFPS/ZEBANCopy of EBAN8STATUProcessing status of purchase requisitionnvarchar10
TOPDistribution Requirements Planning
57MDRP_DRUNDeployment run15STATUStatus of background jobnvarchar10
TOPEngineering Configuration Order BOM
58CUOBOM_CHANGEManually Changed Items in the Order BOM12STATUChange status of an item in the order BOMnvarchar10
TOPEnvironment
59LKLAHClass Header (Special Objects)5STATUClass statusnvarchar10
60LKSSKAllocation Table: Object to Class8STATUClassification statusnvarchar10
TOPExternal personnel administration
61HRWFD_HEADHCM - WFD Main interface table9STATUStatus for HCM - WFD interfacenvarchar10
TOPFlow Manufacturing
62LDLBHLine balance/planned rate header record4STATUStatus of line balancenvarchar10
TOPFrance
63HRT1680Table Part Infotype 16804STATUTraining Need Status Codenvarchar40
64T77TNM_RETable Training Needs Status Reason3STATUTraining Need Status Codenvarchar40
65T77TNM_RETTable Training Needs Status Reason Text4STATUTraining Need Status Codenvarchar40
66T77TNM_STTable Training Needs Status3STATUTraining Need Status Codenvarchar40
67T77TNM_STTTable Training Needs Status Text4STATUTraining Need Status Codenvarchar40
TOPInventory Controlling
68PROPForecast parameters43STATULIS version statusnvarchar10
TOPMaterials Management
69/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions13STATUProcessing status of purchase requisitionnvarchar10
TOPNetherlands
70T5N1TNSI: Created Data Records (Retroactive)6STATUNSI: Status of Data Recordnvarchar10
71T5N5DNSI: Created Data Records7STATUNSI: Status of Data Recordnvarchar10
TOPOwnership
72OIUOW_ORP_TWBORP test workbench comparison history6STATUCHAR01 data element for SYSTnvarchar10
TOPPatient Accounting
73NFAPIS-H: Items for CASE selection billing6STATUIS-H: Status of case after billing (E)rror (W)arning (S)uccenvarchar10
TOPPatient Management
74NAPPIS-H: Provisional Appointments for Visit Scheduling10STATUIS-H: Internal Status of Outpatient Visitnvarchar20
75NBEWIS-H: Movements for Case10STATUIS-H: Internal Status of Outpatient Visitnvarchar20
76NFALIS-H: Cases16STATUIS-H: Case Statusnvarchar10
77NPAEIS-H: Patient Master Data (Institution-Related)7STATUPatient Statusnvarchar10
78NPATIS-H: Patient Master Data (General)41STATUPatient Statusnvarchar10
TOPPayroll
79PA0730Personál.kmen.záznam Infotyp 073038STATUStatus výpoctu (Zkuš.doba,Výsluha,Jmenování,Tarif,Místo... )nvarchar10
80PB0730Personál.kmen.záznam Infotyp 073038STATUStatus výpoctu (Zkuš.doba,Výsluha,Jmenování,Tarif,Místo... )nvarchar10
81T5H81Registered employment relationships3STATUnvarchar10
82T5H81MRegistered employment relationships -- for comm. contracts3STATUnvarchar10
83T5H82Registered employment relationships - sent statuses3STATUnvarchar10
84T5H82MRegistered employment relationships -- for comm. contracts3STATUnvarchar10
85T7RO1PInsurance result table - Person 1:1 with RGDIR5STATUSingle-Character Indicatornvarchar10
86T7ROA2Insurance result table - Person 1:1 with RGDIR5STATUSingle-Character Indicatornvarchar10
87T7SKDNPHR Cluster with simulated bases for DNP calc. in 1/20107STATUInternal Usenvarchar10
88T7SKRLHR Cluster 27STATUInternal Usenvarchar10
89T7SKRZZPHR Cluster 28STATUStatus field list (supplementary insurance -Public Sector)nvarchar100
TOPPersonnel Administration
90HRPAD_DELPNStatus Table for Destruction of Data in Live Systems4STATUStatus for Destroying Personnel Numbers in Live Systemsnvarchar20
91T582LInfotypes - country-specific settings5STATUStatus for country dependency in infotypesnvarchar10
TOPProduct Safety
92TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions72STATUYes/No (X/ )nvarchar10
TOPProduction Optimization Interface POI
93TCLOI2Status Filter for Task List Selection3STATUStatusnvarchar30
TOPPublic Sector
94PA0794HR Master Record Infotype 079425STATUStatus Information for ELDAnvarchar10
95PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure11STATUNotification Block Status, DATUEV-ZVEnvarchar20
96PDPBSZVLOGLog Table for ZVE-PBS Notification Procedure10STATUNotification Block Status, DATUEV-ZVEnvarchar20
97PDPBSZVSUMTotals Record (Record Type 90), SPI20STATUNotification Block Status, DATUEV-ZVEnvarchar20
98T5D5GSupplementary Pension Public Sector: Combination Table19STATUStatus Field String (Supplementary Pension - Public Sector)nvarchar100
TOPPurchasing
99EBANPurchase Requisition8STATUProcessing status of purchase requisitionnvarchar10
100EKKOPurchasing Document Header8STATUStatus of Purchasing Documentnvarchar10
101EKPB"Material Provided" Item in Purchasing Document6STATUIndicator: Firm or Trade-Off Zonenvarchar10
102EKPOPurchasing Document Item5STATURFQ statusnvarchar10
103MEREQXPurchase Requisition Change Parameter8STATUUpdated information in related user data fieldnvarchar10
104WDFR_POSPerishables Planninng Item56STATURFQ statusnvarchar10
TOPRecruitment
105T750XVacancy18STATUStaffing statusnvarchar10
TOPResourcen Management
106MRTRST_HDRRMS-MRTRS : MR Transformation Header26STATUStatusnvarchar30
107RMXTC_T18TMS-API: Cust.: Status of Insp. Plans Copied w. Stab. Study3STATUStatusnvarchar30
TOPReuse Services for Country Development
108PA0860HR Master Record: Infotype 086024STATUStatusnvarchar40
109PA0861HR Master Record: Infotype 086132STATUStatusnvarchar40
110T5F99A4Status3STATUStatusnvarchar40
111T5F99A4TStatus Texts4STATUStatusnvarchar40
112T5F99P1Status3STATUStatusnvarchar40
113T5F99P1TStatus Text4STATUStatusnvarchar40
TOPRouting
114PLKOTask list - header17STATUStatusnvarchar30
TOPSales Plan
115LISPLBackground Job for LIS Planning17STATUStatus of background jobnvarchar10
116LISPLFPlanning Entries Table for Background Planning in LIS7STATUProcessing status: step carried out in the backgroundnvarchar10
117P445GParameters for PLOB Version_Key Figure7STATUIndicator of origin for stocknvarchar10
118P445SPossible Version Statuses2STATULIS version statusnvarchar10
119P445TVersion Status Text3STATULIS version statusnvarchar10
120P445VSales and Operations Planning: Versions16STATULIS version statusnvarchar10
121P445XLIS Planning Versions Table14STATULIS version statusnvarchar10
122PGANProportional Factors per Planning Object Relation (SOP/LIS)9STATULIS branch statusnvarchar10
123PGMIProduct Group/Member Allocation12STATULIS branch statusnvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
124NAKR1IS-H AT: LKF - Grunddaten4STATUIS-H: LKF - Satzartnvarchar10
125TNLZR2IS-H NL:LAZR Afspraaksoort4STATUIS-H: Interne status van een poliklinisch bezoeknvarchar20
TOPShipping
126LIPSPOLIPS Reference Data Purchase Order12STATUStatus field stringnvarchar100
127TVSLTDeliveries: Texts Processing Status4STATUGeneral SD statusnvarchar10
TOPSimulation
128VSEBAN_CNVersion: Purchase requisition9STATUProcessing status of purchase requisitionnvarchar10
TOPSouth Africa
129PA3202HR Master Record: Infotype 320225STATUStatus/Level of Labour Relations Interventionnvarchar30
130T5W64SARS Interface : Employee Status5STATUSARS Interface: Employee Statusnvarchar20
131T5W9OOutcome Types of Labour Relations Interventions3STATUStatus/Level of Labour Relations Interventionnvarchar30
132T5W9OTText - Outcome Types Labour Relations Interventions4STATUStatus/Level of Labour Relations Interventionnvarchar30
133T5W9PRRole responsibilities4STATUStatus/Level of Labour Relations Interventionnvarchar30
134T5W9SStatus/Level of a Labour Relation intervention process3STATUStatus/Level of Labour Relations Interventionnvarchar30
135T5W9STText - Status/Level of a Lab. Relation intervention process4STATUStatus/Level of Labour Relations Interventionnvarchar30
TOPStandard Network
136TCA41Default values for standard networks and profiles25STATUStatusnvarchar30
TOPTaiwan
137T7TW1LLast rported data of LI/NHI reports10STATUInsurance statusnvarchar20
TOPTax Reporter
138T5UYYTR Monitor6STATU30 Charactersnvarchar300
TOPTravel Expenses
139PTRV_CHANGEChange to Trip17STATUStatus of Travel Expense Posting Runsnvarchar20
140PTRV_VERSIONHistory Table21STATUStatus of Travel Expense Posting Runsnvarchar20
TOPTravel Management
141FITV_REJECTRejected Trips17STATUStatus of Travel Expense Posting Runsnvarchar20
TOPTreasury
142TZC37Financial Assets Management status definition4STATUContract statusnvarchar20
TOPUSA
143PA0672FMLA Event Infotype27STATUApproval Statusnvarchar10
TOPVehicle Management System
144CVLC02VELO : Vehicle Status2STATUVehicle Statusnvarchar40
145CVLC02TVELO : Text for CVLC023STATUVehicle Statusnvarchar40
TOPWarehouse Management
146LEINStorage unit header records10STATUStatus of Storage Unitnvarchar10
147LL01Whse Activity Monitor: Critical Transfer Order Items14STATUWarehouse activity monitor: processing statusnvarchar10
148LL02Whse Activity Monitor: Critical Transfer Requirement Items15STATUWarehouse activity monitor: processing statusnvarchar10
149LL03Whse Activity Monitor: Critical Posting Change Documents11STATUWarehouse activity monitor: processing statusnvarchar10
150LL04Whse Activity Monitor: Critical Deliveries11STATUWarehouse activity monitor: processing statusnvarchar10
151LL05Whse Activity Monitor: Critical Stocks11STATUWarehouse activity monitor: processing statusnvarchar10
152LL06Whse Activity Monitor: Critical Storage Bins11STATUWarehouse activity monitor: processing statusnvarchar10
153LL07Whse Activity Monitor: Critical Production Orders11STATUWarehouse activity monitor: processing statusnvarchar10
154LRF_WKQUAssignment User ->Queue5STATUIndicator: Status Usernvarchar10
155LTBKTransfer requirement header4STATUHeader Status of Transfer Requirementnvarchar10
156LUBUPosting Change Document4STATUStatus of Posting Changenvarchar10