Tables in SAP Just a list of tables that come in handy. Sales orders Name | Description | Uses | LIKP | Shipped Lines header | | LIPS | Shipped Lines detail | | VBAK | Order header | Every order (unless archiving) | VBAP | Table fields | Every line item (unless archiving) | VBBE | Open sales order line items | Great file, but be careful. Contents don't reflect orders that do not affect purchasing (go figure). | VBEP | Schedule line item | | VBFA | Document flow | Let's you move from order to shipping document to invoice. | VBUK | Order status | | VBUP | Line item detail status | | VBFK | Invoicing header | | VBFP | Invoicing detail | | Material Management Name | Description | Uses | MARA | Inventory Master | | MARC | Plant Data | | MARD | Current Inventory | | MAKT | Descriptions | | MBEW | Material Valuation | | T179 | Product Hierarchy | | MVKE | Sales data (materials) | | MKPF | Material document | Status code 'R' in VBFA | Purchasing Name | Description | Uses | EINA | Purchasing inforecord | by MATNR/LIFNR contains things like vendor material number and access key for EINE | EINE | Purchasing inforecord detail | Contains minimum purchase, group, currency | EKPO | Purchase orders | | EKET | Scheduled lines | | EKES | Vendor confirmed lines | | | | | Forecasting Name | Description | Uses | MAPR | | | PROP | | | PROW | | | Classification Name | Description | Uses | KSSK | Material number to class | | KLAS | Class description | | KSML | Characteristic name | | CABN/CABNT | Characteristic name description | | CAWN/CAWNT | Characteristic name | | AUSP | Numeric values | | Name | Description | Uses | CAUFV | Service order header | | AFPO | Service order line | Holds items that will create "reservations" | RESB | SM Reservations | Materials needed for line | Customer Data KNA1 | Customer Master | | KNVV | Sales information | | KNVP | Partners (ship-to, etc) | | | | | | | | | | | System tables Name | Description | Uses | DD02T | Table texts | | DD03L | Table fields | Lists the fields in a table | DD04T | Data element texts | | USR02 | Valid user names | | Config tables (normally begin with "T") Name | Description | Uses | T001 | Client table | | T002 | Languages | | T005 | Region (Country) | | TCURR | Currency and exchange rates | | TVAK | Order type | | TVSB | Shipping condition | | TVAGT | Rejected reason for order line | | Other tables Name | Description | Uses | STXH | Text header | | STXL | Text detail | |
|
I'm totally printing this, I just know I'm going to thank myself for doing so someday (and you, of course). I'd love it if you uploaded so more useful things, thanks!
ReplyDelete