S066

Open orders: credit management | #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):
OEIKW Open sales order credit value (schedule lines)
AOEIW Guaranteed open order value (schedule lines)
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
  • S066.MANDT == T014.MANDT
  • S066.KKBER == T014.KKBER
Customer's Account Number with Credit Limit Reference
  • S066.MANDT == KNA1.MANDT
  • S066.KNKLI == KNA1.KUNNR
Client S066.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S066.PERIV == T009.PERIV
  • S066.MANDT == T009.MANDT