SAP table S067 (Open deliveries/billing documents (KM))

SAP table S067 has 9 primary key fields being MANDT,SSOUR,VRSIO,KKBER,KNKLI,SPMON,SPTAG,SPWOC,SPBUP.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SSOUR Statistic(s) origin CHAR 4 0 SSOUR
VRSIO Version number in the information structure CHAR 3 0 VRSIO
KKBER Credit control area CHAR 4 0 T014 KKBER
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNA1 KNKLI
SPMON Period to analyze - month NUMC 6 0 SPMON
SPTAG Period to analyze - current date DATS 8 0 SPTAG
SPWOC Period to analyze - week NUMC 6 0 SPWOC
SPBUP Period to analyze - posting period NUMC 6 0 SPBUP
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
VWDAT Pointer to administrative data NUMC 10 0 VWDAT
CMWAE Currency key of credit control area CUKY 5 0 WAERS_CM
OLIKW Open delivery credit value CURR 19 2 MC_OLIKW
OFAKW Open billing document credit value CURR 19 2 MC_OFAKW
AOLIW Guaranteed open delivery value CURR 19 2 MC_OLIKWAA
AOFAW Guaranteed open billing values CURR 19 2 MC_OFAKWAA

S067 foreign key relationships

Table Field Check Table Check Field
0 S067 KKBER T014 Credit control areas KKBER
1 S067 KNKLI KNA1 General Data in Customer Master MANDT
1 S067 KNKLI KNA1 General Data in Customer Master KUNNR
0 S067 PERIV T009 Fiscal Year Variants MANDT
0 S067 PERIV T009 Fiscal Year Variants PERIV