| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000187000 | PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item) | 7 | BSART | | nvarchar | 4 | 0 | | |
2 | /BIC/B0000188000 | PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header) | 10 | BSART | | nvarchar | 4 | 0 | | |
3 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 7 | BSART | | nvarchar | 4 | 0 | | |
4 | /OPT/VIM_2HEAD | Additional Fields for Table /OPT/VIM_1HEAD | 11 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
5 | FSH_OS_MM | Table for MM Season customizing | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
6 | FSH_OS_STO | Document type customizing for STO's | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
7 | P2B2_PT | HCM Declustering B2 - Time Event Pairs | 14 | BSART | Time event pair start | nvarchar | 3 | 0 | | |
8 | S520E | S520 - Strukturinformationen | 11 | BSART | Bestellart | nvarchar | 4 | 0 | | |
9 | SGT_SEGVAL | Segmentation Value for Supplying Plants | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
10 | SGT_SEGVAL_PR | Segmentation Value for Supplying Plants | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
11 | T160 | SAP Transaction Control, Purchasing | 6 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
12 | T161B | Default Business Transaction Type for Import | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
13 | T161R | REORG Control, Purchasing | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
14 | T161V | Shipping-Specific Data for Stock Tfr. for Purch. Doc. Type | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
15 | T161Z | Additional Checks for Outline Agreements on Reorganization | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
16 | T166U | Headings in Purchasing Document Printout | 5 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
17 | TMKSU | Calculation Schema: Purchasing: for Stock Transfer | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
18 | TMS_C_PAG | Ext. TMS: Settings for Int. of MM Scheduling Agreements | 2 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
19 | ZEIM_VBEP | Sales Document: Schedule Line Data | 23 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPAccount Determination |
20 | TVKO | Organizational Unit: Sales Organizations | 18 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPAdditionals Management |
21 | TWTCTRL | Control table for procedures for additionals | 8 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPAllocation |
22 | AUBSI | Worklist for PO (Follow-on Document Generation) | 25 | BSART | Order type in allocation table (for external vendor) | nvarchar | 4 | 0 | | |
23 | AUPO | Allocation Table Document Item | 47 | BSART | Order type in allocation table (for external vendor) | nvarchar | 4 | 0 | | |
24 | T621 | Item Categories for Allocation Tables | 10 | BSART | Order type in allocation table (for external vendor) | nvarchar | 4 | 0 | | |
TOPBasic Functions |
25 | T161SN | Assignment of Serial Number Profile to Item Category | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
26 | T163LV | Determination of Confirmation Control Key | 3 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
27 | TVEP | Sales Document: Schedule Line Categories | 9 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPConditions |
28 | B025 | Purchasing Output Determination: Doc.Type/Purch.Org/Vendor | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
29 | B026 | Purchasing Output Determination: Document Type | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
30 | B100 | Output Determination: DocumentType/Purch.Org./Material Group | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPConsumption-Based Planning See Also PP-MRP |
31 | EDMMS | Assignment of EDI partner to purchasing org. and plant | 8 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
32 | TMDRD_DOCTP | Delivery Relationshp: Document Types per Document Category | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
33 | TWDRD_DOCTP | Delivery Relationshp: Document Types per Document Category | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
34 | FRE_DOC_CAT_SENT | Relevant Document Categories and Types for Outbound Interf | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
35 | FRE_DOC_CAT_TYPE | Relevant Document Categories and Types for Outbound Interf | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
36 | FRE_OP_PO_KEY | Key-Completion F&R Order Proposal <-> R/3 Purchase Order | 9 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
37 | VVBEP | Sales Document: Schedule Line Data | 23 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPCustomer Bill of Services |
38 | TBOSSC01 | Subcontracting: Assignment of Conditions (MM, SD) | 3 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
39 | TBOSSC02 | Subcontracting: Assignment of Conditions (MM, SD) | 3 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPData Collection |
40 | S520 | Test | 16 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
41 | TXW_S_EKKO | Retrieve EKKO from archive | 6 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPDefense Forces and Public Security |
42 | /ISDFPS/ZEBAN | Copy of EBAN | 4 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
TOPDistributor-Reseller-Management |
43 | /SAPHT/DRMCT161 | DRM relevant settings for Purchase order type | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPDown Payment Chains |
44 | /SAPPCE/T_PODPC | Customization table for assigning PO to DPC | 2 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPExchanges |
45 | OIA03 | Exchange item data - purchasing side | 5 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPExternal Services |
46 | T165A | Condition Schema for Services | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
47 | FMFG_UO_OBL_MMDT | SO Adjustmnt Prog: Pur Doc Types to exclude from Obligations | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPFunds Management |
48 | FMFGTOLDCTYP | Document types for US Federal MM tolerances | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPImplementation of Organizational Flexibility in Logistics |
49 | /ISDFPS/CRELSTY | Relocation Step Type | 5 | BSART | OrderType Relocat. | nvarchar | 4 | 0 | | |
TOPIndustry Solution Oil |
50 | TOI0_REL_MM_RANK | Ranking of MM relevance fields | 4 | BSART | Order Type Set Up | nvarchar | 4 | 0 | | |
TOPKANBAN |
51 | TPK02 | Key for Controlling Control Cycle: External Replenishment | 11 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPLocalization |
52 | ESFMC_EXCL_EFD | Exception for Budget Control | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
53 | J_3RFMM_RATE_CLC | Enable Down Payments in FC Function for MM Documents | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPLogistics - General |
54 | TB2BC | Trading Contract: Purchasing Grouping | 4 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
55 | WBHD | Trading Contract: Commercial Data | 55 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPMarketing, Accounting and Pricing |
56 | OIC_FORM_ATTRIB | Attributes of Business Context for F&A Formula | 19 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPMaster Data |
57 | T438M | Control Parameter for MRP -Material Level- | 35 | BSART | MRP:doc.type purchase requisitions for standard purchase ord | nvarchar | 4 | 0 | | |
TOPMaterials Management |
58 | /ISDFPS/ADVCODE2 | Advice Code with Document Type | 2 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
59 | /ISDFPS/CADVCODE | Advice Code - Table Obsolete - Do Not Use Anymore | 2 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
60 | /ISDFPS/CREBSART | Order Types Relevant for Return Delivery | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
61 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 9 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
62 | /ISDFPS/MMRLT161 | Customizing: Purchasing Doc Types for Rtn Delivery Process | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
63 | /ISDFPS/PRPLCNTL | Subsequent Processing for Prioritized Materials Planning | 6 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
TOPMedia Product Sales and Distribution |
64 | TJKSDPORDERBSART | Order Types for IS-M Purchase Orders | 8 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
65 | TJKSDPORDERPOS | Item Categories for Purchase Order | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPMobile Materials Management |
66 | /ISDFPS/MEMMT161 | Customizing: Purchasing Document Types Change Pointers (ME) | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPPerishables Procurement |
67 | FIP_D_ORDER_LINE | Order lines for FIP | 22 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
68 | FIP_D_SP_VENDOR | Relationship Supply Plants and Vendors for FIP | 6 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPPOS Interface |
69 | WVFB | DRS Interface, Intermediate Buffer, Order Item FM | 8 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPPurchasing |
70 | EBAN | Purchase Requisition | 4 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
71 | EKKO | Purchasing Document Header | 5 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
72 | MEREQX | Purchase Requisition Change Parameter | 4 | BSART | Updated information in related user data field | nvarchar | 1 | 0 | | |
73 | T161 | Purchasing Document Types | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
74 | T161C | Settings for Documents from CRM/BBP | 3 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
75 | T161P | Check of Document Type, Document Category, Item Category | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
76 | T161T | Texts for Purchasing Document Types | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
77 | T161VN | Shipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
78 | T161W | Order Types for Stock Transfer | 5 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
79 | T166A | Supplement Text in Purchasing Document Printouts | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
80 | T166K | Header Texts in Purchasing Document Printouts | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
81 | T166P | Item Texts in Purchasing Document Printouts | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
82 | T16CA | DCM Control Table: Change Management | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
83 | T16CE | Output Control: Display of Change Documents in Purchasing | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
84 | T16CR | Version-Relevant Fields of Purchase Requisition | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
85 | WDFR_DISP | Perishables Planning Header | 107 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
86 | WDFR_POS | Perishables Planninng Item | 84 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
87 | WRFT_OTB_CHECK | Customizing OTB Check | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
88 | WRFT_POHF_GROUP | Control Table for Grouping | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
89 | WRFT_POHF_INBD | Order List Settings Document Types | 2 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
90 | WRF_POHF_POL | Order list | 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
91 | WRF_POTB_DB1 | Worklist OTB Procurement | 10 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
92 | WRF_PRCT_WL_ITEM | Original Table for Worklist Items | 7 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
93 | WRF_PRCT_WL_SHDW | Shadow Table for Worklist Items | 10 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPPurchasing Information System |
94 | MCEKS | R/2 PURCHIS Data (Status: Last Data Transmission) | 29 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPSales |
95 | VBEP | Sales Document: Schedule Line Data | 23 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPSelf-Service Procurement |
96 | /SRMERP/C_FODTP | Follow on Document Types | 5 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
97 | /SRMERP/D_SC_ITM | Shopping Cart Item | 50 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPSerial Numbers |
98 | SER08 | Document Header for Purchase Order Item Serial Numbers | 7 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
99 | SER09 | Doc. Header for Serial Numbers for Purchase Requisition Item | 7 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPShipping |
100 | LIPSPO | LIPS Reference Data Purchase Order | 9 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPSimulation |
101 | VSEBAN_CN | Version: Purchase requisition | 5 | BSART | Purchase Requisition Document Type | nvarchar | 4 | 0 | | |
102 | VSVBEP_CN | Version: Sales document: Schedule line data | 24 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPStructures Workbench |
103 | /ISDFPS/MATSPPLN | Materials Planned for Force Element | 46 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPSupply Chain Management |
104 | TCM_C_PUR_MAP | Mapping TM Organizational Unit to Purchasing Organisation | 14 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPTariffs, Duties and Permits |
105 | OIH08 | Default values for external procurement functions | 4 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
106 | OIH08A | Default values for external procurement functions | 7 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPTraders and Schedulers Workbench |
107 | OIJBRDDOC | Rundown item / document X-ref table for Batch - WILL EXPIR | 18 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
108 | OIJRDDOC | Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE | 18 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
109 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 22 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
110 | S431 | PURCHIS: (OIL-TSW) Purchasing document stats by TSW object | 33 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
111 | TOI0_REL_MM | Relevance customizing for MM Documents | 4 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
112 | TOIJ_EL_INCOMP | IS-OIL TSW: Activate incompletion for sales and purchasing | 4 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
113 | TOIJ_EL_INC_F | IS-OIL TSW: specify incompletion fields | 5 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
114 | TOIJ_EL_MVSCEN | TSW: Define Movement scenarios | 10 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPTransportation Management Integration |
115 | TMS_C_PUR | Ext. Transport Manag.: Determination of Transfer Relev. PUR | 4 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
TOPVehicle Management System |
116 | CVLC23 | VELO : Assign Organization Data to VMS Roles | 13 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |
117 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 14 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | | |
TOPWaste Management |
118 | EHSWAC_ENTAMBW | Parameters for Purchasing Management | 4 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | | |