S067

Open deliveries/billing documents (KM) | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
KKBER FK Credit control area
KNKLI FK Customer's Account Number with Credit Limit Reference
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
Column Name Description
💲 Currency key of credit control area (CMWAE):
OLIKW Open delivery credit value
OFAKW Open billing document credit value
AOLIW Guaranteed open delivery value
AOFAW Guaranteed open billing values
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Credit control area
  • S067.MANDT == T014.MANDT
  • S067.KKBER == T014.KKBER
Customer's Account Number with Credit Limit Reference
  • S067.MANDT == KNA1.MANDT
  • S067.KNKLI == KNA1.KUNNR
Client S067.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S067.PERIV == T009.PERIV
  • S067.MANDT == T009.MANDT