八 05
有时候用SM37来搜索Job感觉很慢，查了一下，可以直接用SE16进下面几个table找Job，更准确且快！
TBTCS: Job Status Overview Table
TBTCO: Batch Schedule Table
TBTCP: Batch Job Step Overview
TRDIRT: Title Texts For Program in TRDIR
四 22
Entities
| Accounting Accounting documents Bill Of Material Capacity planning Classification Classification class types, classifiable objects Classification characteristics Configurator Cost elements centers and activities Customer Equipment Equipment status system status / user status Function location and reference function location General ledger accounts Goods movement Inventory document Maintenance Order PM order Material Material document Notifications |
Orders Purchase orders Personel Production resource tools PRTs Project Purchase Requisition Purchasing document Purchasing Info record Reservation Sales document Invoice, delivery, partners, contacts Sales requirements Storage locations and stocks Tasklist General ~, function location ~ or equipment ~ Transfer requirement User data Vendor master Warehouse Management transfer |
If the information above is not sufficient, this bit could be interesting to you:
The search for functional tables
Table overview
| Accounting | BSAD Accounting: Secondary index for customers (cleared items) BSID Accounting: Secondary index for customers BSIW Index table for customer bills of exchange used BSIX Index table for customer bills of exchange used BSAK Accounting: Secondary index for vendors (cleared items) BSIK Accounting: Secondary index for vendors BSIP Index for vendor validation of double documents BSAS Accounting: Secondary index for G/L accounts (cleared items) Logical databases: - |
| Accounting documents | BKPF Accounting document header BSEG Accounting document segment BSET Tax data document segment BSEC One-time account data document segment Logical databases: BRM |
| Bill Of Material | MAST Material to BOM Link EQST Equipment to BOM Link STAS BOMs header STKO BOM header STPN BOM follow-Up control STPO BOM item STPU BOM sub-item STST Standard BOM link STVB Bills of material – Serialization of posting STZU Permanent BOM data Logical databases: - |
| Bill Of Material | KBED Capacity requirements record Logical databases: POH |
| Classification | CABS Result of the Statistical Analysis of Table AUSP CUFM Customizing: Class/Config: Screendesigner Form TCME Validity for Global Characteristics KLAH Class Header Data KLAT Classes: long texts KSML Characteristics of a Class AUSP Characteristic values SWOR Classification System: Catchwords KSSK Allocation Table: Object to Class TCLG Class groups TCLO Key Fields of Objects TCLS Classes: Organizational areas TCLST Classes: Org. Areas (Texts) TCLU Class Status COCC PP-PI attributes for characteristics COFV Process management – process instr. charact. in ctrl. recipe COME Process management – message characteristics CORE Process mgmt.- display characteristics of the eval. version PLFV PI Characteristics/Sub-Operation Parameter Values Logical databases: - Matchcodes: CLAS, MERK en KLSW |
| Classification | TCLA Class Types TCLAT Class Type Texts TCLT Classifiable Objects LTCLTT Classifiable Objects: Texts Logical databases: - |
| Classification characteristics | CABN Characteristic CAWN Characteristic values Logical databases: - |
| Configurator | CUCO Additional Data for Configurable Objects CUCVRNT Variants of Constraints CUEX Dependency Storage – Compilation CUFM Customizing: Class/Config: Screendesigner Form CUKB Administrative Information for Dependency Maintenance CUKBT Text Table for Dependency Maintenance Admin. Information CUKN Dependency Storage – Variants/Configuration CUOB Link between Object and Dependency CUPE Extension to BOM Item for Variants CURSADD Dependency Net Additional Data CUVT Variant Table CUXREF Object Dependency Cross References Logical databases: - |
| Cost elements, centers, activities | CSKA Cost elements (data dependent on chart of accounts) CSKB Cost elements (data dependent on controlling area) CSKS Cost center master CSKT Cost center texts CSKU Cost element texts CSLA Activity master CSLT Activity type texts CSSK Cost center /cost element CSSL Cost center / activity Logical databases: - |
| Customer | KNA1 General Data in Customer Master KNAS Customer master (VAT registration numbers general section) KNB1 Customer master (company code) KNB4 Customer payment history KNB5 Customer master (dunning data) (aanmaangegevens) KNBK Customer master (bank details) KNC1 Customer master (transaction figures) KNC3 Customer master (special G/L transaction figures) KNKA Customer master credit management: Central data KNKK Customer master credit management: Control area data KNMT Customer-Material Info Record Data Table KNMTK Customer-Material Info Record Header Table KNVA Customer Master Loading Points KNVD Customer master record sales request form KNVI Customer Master Tax Indicator KNVK Customer Master Contact Partner KNVL Customer Master Licenses KNVP Customer Master Partner Functions KNVS Customer Master Shipping Data KNVT Customer Master Record Texts for Sales KNVV Customer Master Sales Data Logical databases: DDF |
| Equipment | EQUI Equipment master data EQKT Equipment short texts EQUZ Equipment time segment EAPL Allocation of Task Lists to Pieces of Equipment Logical databases: EQI |
| Equipment status | EQUI Equipment master data JSTO Status object information JEST Object status TJ30 User status TJ30T Texts for user status TJ02 System status TJ02T Texts for system status Logical databases: - |
| Function location | IFLOT Functional Location (Table) IFLOTX Functional location: short texts IRLOTX Reference functional location: short texts TAPL Allocation of task lists to functional locations Customizing tables T370R Reference functional location category Logical databases: - |
| General ledger accounts | SKA1 G/L accounts master (chart of accounts) SKAS G/L account master (chart of accounts: key word list) SKAT G/L account master record (chart of accounts: description) SKB1 G/L account master (company code) SKM1 Sample G/L accounts SKMT Sample account names SKPF Header Data: Inventory Sampling Logical databases: - |
| Goods movement | AUFM Goods movements for order AFFW Goods movements with errors from confirmations SER03 Doc.header f.serial numbers for goods movements Customizing T440C Planning file entries for goods movements Logical databases: - |
| Inventory document | IKPF Header: Physical Inventory Document ISEG Physical Inventory Document Items LINK Inventory document header in WM LINP Inventory document item in WM LINV Inventory data per quant |
Maintenance Order |
AFIH Maintenance Order Header AFKO Order header data PP orders AFPO Order item (not used much) AFRU Order completion confirmations AFVC Operation within an order AFVV Order position data CRCO Assignment of work center to cost center OBJK Plant Maintenance Object List CRHD Work Center Header PLAF Planned order HIKO Order master data history HIVG PM order history: operations Logical databases: CNJ |
| Material | MARA Material Master: General Data MARC Material Master: C Segment MARD Material Master: Storage Location/Batch Segment MAKT Material Descriptions MAPL Allocation of task lists to materials MARV Material Control Record MARM Units of Measure MBEW Material Valuation MOFF Outstanding Material Master Records MSTA Material Master Status MVER Material consumption MVKE Material Master: Sales Data MAPR Material Index for Forecast PROP Forecast parameters Logical databases: MSM |
| Material document | MKPF Header: Material Document MSEG Document Segment: Material BSIM Secondary Index, Documents for Material Logical databases: - |
| Notifications | QMEL Quality notification QMIH Quality message – maintenance data excerpt Logical databases: - |
| Orders | AUFK Order master data AFKO Order header data PP orders AFPO Order item JSTO Status object information JEST Object status Logical databases: ODK |
| Personel | PCL5 HR/RP Cluster 5; HR Planning Usage PREL HR Master Data (Version 3.0: Old Version !) PTXT Texts for HR Master Data …. table PREL has been changed to PA0000 HR Master Record: Infotype 0000 (Events) PA0001 HR Master Record: Infotype 0001 (Org. Assignment) PA0002 HR Master Record: Infotype 0002 (Personal Data) PA0003 HR Master Record: Infotype 0003 (Payroll Status) PA0004 HR Master Record: Infotype 0004 (Challenge) PA0005 HR Master Record: Infotype 0005 (Leave Entitlement) PA0006 HR Master Record: Infotype 0006 (Addresses) PA0007 HR Master Record: Infotype 0007 (Work Schedule) PA0008 HR Master Record: Infotype 0008 (Basic Pay) PA0009 HR Master Record: Infotype 0009 (Bank Details) PA0010 HR Master Record: Infotype 0010 (Capital Formation) PA0011 HR Master Record: Infotype 0011 (Ext.Bank Transfers) PA0012 HR Master Record: Infotype 0012 (Fiscal Data Germany) PA0013 Infotype Social Insurance – Germany PA0014 HR Master Record: Infotype 0014 (Recurr. Bens/Deducs) PA0015 HR Master Record: Infotype 0015 (Additional Payments) PA0016 HR Master Record: Infotype 0016 (Contract Elements) … and up to PA00281 and PA0900 is available ! Logical databases: PNP |
| Production resource tools | AFFH PRT assignment data for the work order CRVD_A Link of PRT to Document CRVD_B Link of Document to PRT CRVE_A Assignment PRT data – equipment CRVE_B Assignment equipment – PRT data CRVM_A Link of PRT data to a material CRVS_A Relationship of PRT internal number to PRT external number CRVS_B Relationship of PRT external number to PRT internal number Customizing tables: TCF02 PRT categories TCF03 Texts for the production resources/tools category TCF04 Status of the PRT master TCF05 Language-dependent text table for PRT status TCF06 Field groups in the PRT master for reference TCF07 Language-dependent texts for field groups in PRT master TCF08 Assignment of PRT master fields to field groups TCF10 PRT control key TCF11 Language-dependent text table for PRT control keys TCF12 PRT group key TCF13 Language-dependent text table for PRT group keys Logical databases: - |
| Project | PROJ Project definition PRPS WBS (Work Breakdown Structure) Element Master Data PRTE Scheduling Data for Project Item Logical databases: CNJ, PSJ, IMA |
| Purchase Requisition | EBAN Purchase Requisition EBKN Purchase Requisition Account Assignment EBUB Index for Stock Transport Requisitions for Material Logical databases: BAM, BKM, BBM |
| Purchasing document | EKAN Vendor Address: Purchasing Document EKBE History of Purchasing Document EKBZ History of Purchasing Document – Delivery Costs EKET Delivery Schedules EKKN Account Assignment in Purchasing Document EKKO Purchasing Document Header EKPO Purchasing Document Item EKPB “Material Provided” Item in Purchasing Document EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item Logical databases: - |
| Purchasing info record | EINA Purchasing Info Record – General Data EINE Purchasing Info Record – Purchasing Organization Data EIPA Order Price History, Info Record EIKP Export/import header data EIPO Export/Import Item Data KONH Conditions (Header) KONP Conditions (Item) KONM Conditions (1 Dimensional Quantity Scales) KONW Conditions (1 Dimensional Value Scales) Logical databases: IFM, ILM |
| Reservation | RKPF Document Header: Reservation RESB Reservation/dependent requirements Logical databases: RKM, RNM, POH |
| Sales Document | VBAK Header Data VBAP Item Data VBAG Release Data by Schedule Line in Sch.Agrmt. VBUK Header Status and Administrative Data VBUP Item Status VBRL SD Document: Invoice List VBPA partner VBKD Business Data VBKA Sales activities VBEP Schedule Line Data VBRK Billing: Header Data (invoice) VBRP Billing: Item Data (invoice) VBFA Sales Document Flow LIKP Delivery Header Data LIPS Delivery: Item data Logical databases: AAV, AKV, ARV, VFV |
| Sales requirements | VBBE Sales Requirements: Individual Records VBBS Sales Requirement Totals Record Logical databases: - |
| Storage locations and stocks | LAGP Storage bins LEIN Storage unit header records LQUA Quants LQUAB Total quant counts for certain strategies MEIK Make-to-Order Stock for Customer Order MSCA Sales Orders on Hand with Vendor MSKA Sales Order Stock MBPR Stock at Production Storage Bin MLGN Material Data per Warehouse Number MLGT Material Data per Storage Type SLGH Elements of Stock Population Logical databases: S1L, S2L |
| Tasklist |
PLKO Task list – header PLAS Task list – selection of operations/activities PLPO Task list – operation/activity PLKZ Task list: main header PLWP Allocation of Maintenance Packages to Task List Operations PLAB Relationships PLFH Task list – production resources/tools PLFL Task list – sequences PLFT Process instructions PLFV PI Characteristics/Sub-Operation Parameter Values PLMZ Allocation of bill of material items to operations (component list) PLPR Log collector for task lists MAPL Allocation of task lists to materials EAPL Allocation of task lists to pieces of equipments TAPL Allocation of task lists to functional locations Logical databases: - |
| Transfer requirement | LTBK Transfer requirement header LTBP Transfer requirement item Logical databases: R1L, RBL, RUL |
| User data | USR01User master record (run-time data) USR02 Logon data USR03 User address data USR04 User master authorizations USR05 User Master Parameter ID USR06 Additional data per user USR07 Object/values of last failed authorization check USR08 Table for user menu entries USR09 Entries for user menus (work areas) USR10 User master authorization profiles USR11 User Master Texts for Profiles (USR10) USR12 User master authorization values USR13 Short Texts for Authorizations USR14 Surchargeable language versions per user USR15 External User Name USR20 Date of last user master reorganization USR30 Additional Information for User Menu USR40 Table for illegal passwords USR41 User master: Additional data USRCOBJ Object Filters for Exploding Product Structures USRM0 Material Master User Settings: User Screen Reference USRM1 Material Master User Settings: Organizational Levels USRM2 Material Master User Settings: Logical Screens USRMM User settings: material master |
| Vendor master | LFA1 General section LFAS VAT registration numbers general section LFB1 Company code LFB5 Dunning data LFBK Bank details LFC1 Transaction figures LFC3 Special G/L transaction figures LFM1 Record purchasing organization data Logical databases: KDF |
| WM transfer | LTAK WM transfer order header LTAP WM transfer order item LUBU Posting change document Logical databases: R0L, RTL |
一 18
SAP table 有三种类型：transparent, cluster and pool;
1.What is transparent, cluster and pool table? where and when we use these tables?
透明表同时存在于dictionary 和database中, 且具有完全相同的结构，相同的数据与栏位。
Pooled table 是一种逻辑表，在定义它的同时必须要将其分配到 一个 table pool中去。而pooled table则是用来存储control data的。几个pooled table是可以被整合到一个table pool中的。这些pooled table的数据会于同一个database table 中更新。
簇表则是在定义的时候必须要分配到一个table cluster中去的。也是用来存储control data的。他们用来存储临时的数据和文本，例如文档。
2.What’s the major difference between standard tables, Pooled tables and Clustered tables?
透明表是用来直接存储数据的，也即物理的。你可以在系统以外用例如SQL语句来直接读取db的数据。
透明表是一对一的表，例如当你创建一个透明表的同时，完全相同的一个表将会被创建在DB中，主要用于存储交易数据。
而cluster和pooled表是不能从外部访问的，因为其数据都是被聚合和汇集到一个栏位中的。
原因之一是他们的数据于长度和构造上的不同。ABAP于数据库层面的操作亦受限。
但是pool和cluster表是多对一的关系表。这意味着很多的pool表可以被存储到一个table pool中。
所有的pool table于table pool中存储都是不需要foreign key的，但是cluster table是要的。而且这两种table都是用于存储应用数据的。
一个table pool可以包含10到1000个每个可以有10到100笔数据的小的pool table，而cluster table则只可以包含1到10个但超大的cluster table。
对于pool和cluster table，你既可以使用secondary index和select distinct，group，也可以使用native SQL语句。
Structure 是没有数据的table。它只在程式逻辑中需要它的那一刻装入数据。
而View只是一种看待table中内容的方式。它只是改变了table中数据的表现方式而已。你实际调用的仍然是下面的table。
Recent Comments