SAP ABAP Table S066 (Open orders: credit management)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S066	Table Relationship Diagram
Short Description	Open orders: credit management

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	KKBER	☑	KKBER	KKBER	CHAR	4	0	Credit control area	T014
5	KNKLI	☑	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
6	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
7	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
8	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
9	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
10	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
11	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
12	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	*
13	OEIKW	☐	MC_OEIKW	WERTV10	CURR	19	2	Open sales order credit value (schedule lines)
14	AOEIW	☐	MC_OEIKWAA	WERTV10	CURR	19	2	Guaranteed open order value (schedule lines)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S066	KKBER	T014	KKBER
2	S066	KNKLI	KNA1	KUNNR
3	S066	MANDT	T000	MANDT
4	S066	PERIV	T009	PERIV

History

Last changed by/on	SAP	20020219
SAP Release Created in	470