S067 is a standard SAP Table which is used to store Open deliveries/billing documents (KM) data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP S067 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
MANDT | MANDT | CLNT | 3 | T000 | Client | |
SSOUR | SSOUR | CHAR | 4 | Statistic(s) origin | ||
VRSIO | VRSIO | CHAR | 3 |
* | Version number in the information structure | |
KKBER | KKBER | CHAR | 4 | T014 | Credit control area | |
KNKLI | KNKLI | CHAR | 10 | KNA1 | Customer's account number with credit limit reference | ALPHA |
SPMON | SPMON | NUMC | 6 | Period to analyze - month | PERI | |
SPTAG | SPTAG | DATS | 8 | Period to analyze - current date | ||
SPWOC | SPWOC | NUMC | 6 | Period to analyze - week | PERI | |
SPBUP | SPBUP | NUMC | 6 | Period to analyze - posting period | PERI | |
PERIV | PERIV | CHAR | 2 | T009 | Fiscal Year Variant | |
VWDAT | VWDAT | NUMC | 10 | Pointer to administrative data | ||
CMWAE | WAERS_CM | CUKY | 5 |
* | Currency key of credit control area | |
OLIKW | MC_OLIKW | CURR | 19(2) | Open delivery credit value | ||
OFAKW | MC_OFAKW | CURR | 19(2) | Open billing document credit value | ||
AOLIW | MC_OLIKWAA | CURR | 19(2) | Guaranteed open delivery value | ||
AOFAW | MC_OFAKWAA | CURR | 19(2) | Guaranteed open billing values |
Key field | |
Non-key field |