SAP TABLES | Logistics - General | Logistics Information System (LIS) | Data Collection(LO-LIS-DC) SAP LO

S067 SAP Open deliveries/billing documents (KM) Table and data

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

SAP S067 Table fields within data Dictionary

FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
SSOURSSOURCHAR4 Statistic(s) origin
Version number in the information structure
KKBERKKBERCHAR4 T014Credit control area
KNKLIKNKLICHAR10 KNA1Customer's account number with credit limit referenceALPHA
SPMONSPMONNUMC6 Period to analyze - monthPERI
SPTAGSPTAGDATS8 Period to analyze - current date
SPWOCSPWOCNUMC6 Period to analyze - weekPERI
SPBUPSPBUPNUMC6 Period to analyze - posting periodPERI
PERIVPERIVCHAR2 T009Fiscal Year Variant
VWDATVWDATNUMC10 Pointer to administrative data
Currency key of credit control area
OLIKWMC_OLIKWCURR19(2) Open delivery credit value
OFAKWMC_OFAKWCURR19(2) Open billing document credit value
AOLIWMC_OLIKWAACURR19(2) Guaranteed open delivery value
AOFAWMC_OFAKWAACURR19(2) Guaranteed open billing values

Key field
Non-key field