SAP ABAP Table QPACV (Logical data base QAM (QPAC and QPCT))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QA (Package) QM master data

Basic Data

Table Category	INTTAB	Structure
Structure	QPACV	Table Relationship Diagram
Short Description	Logical data base QAM (QPAC and QPCT)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	KATALOGART	☑	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
4	AUSWAHLMGE	☑	QAUSWAHLMG	QAUSWAHLMG	CHAR	8	0	Selected Set	QPAM
5	CODEGRUPPE	☑	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	QPGR
6	CODE	☑	QCODE	QCODE	CHAR	4	0	Code	QPCD
7	VERSIONAM	☑	QVERSNRAM	QVERSNR	CHAR	6	0	Version Number of the Selected Set Record
8	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
9	VERSIONCD	☐	QVERSNRCD	QVERSNR	CHAR	6	0	Version Number of the Code Record
10	MASSNAHME	☐	QMASSKTEXT	QKURZTEXT	CHAR	40	0	Short Text for Task
11	LTEXTMASSV	☐	QLTEXTMS	QKZ	CHAR	1	0	Long Text Exists for the Task
12	AUSWIRKUNG	☐	QAUSWKTEXT	QKURZTEXT	CHAR	40	0	Short Text About Effect
13	LTEXTAUSWV	☐	QLTEXTAW	QKZ	CHAR	1	0	Long Text Exists for the Effect
14	BEWERTUNG	☐	QBEWERTUNG	QBEWERTUNG	CHAR	1	0	Code Valuation
15	FEHLKLASSE	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	TQ17
16	WAEHRUNG	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	FKOSTEN	☐	QFKOSTEN	QFKOSTEN	CURR	10	2	Nonconformity Costs
18	MUSSTEXTKZ	☐	QMUSSTKZ	QKZ	CHAR	1	0	Text Must Be Entered when Results Are Confirmed
19	AENDERKZ	☐	QAENKZ	QKZ	CHAR	1	0	Create Change Documents
20	ERSTELLER	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
21	E_DATUM	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
22	AENDERER	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
23	A_DATUM	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
24	GELOESCHT	☐	QGELOESCHT	QKZ	CHAR	1	0	Data Record Was Deleted
25	QKENNZAHL	☐	QKENNZ	QKENNZ	INT4	10	0	Quality Score
26	FOLGEAKTI	☐	QFOLGEAKTI	QFOLGEAKTI	CHAR	8	0	Follow-Up Action	TQ07
27	SPRACHE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
28	KURZTEXT	☐	QKURZTEXT	QKURZTEXT	CHAR	40	0	Short Text
29	LTEXTV	☐	QLTEXTCODE	QKZ	CHAR	1	0	Long Text Exists for the Code
30	INAKTIV	☐	QINAK	QKZ	CHAR	1	0	Status of Code Group or Code Record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QPACV	AUSWAHLMGE	QPAM	AUSWAHLMGE	KEY	1	CN
2	QPACV	CODE	QPCD	CODE	KEY	1	CN
3	QPACV	CODEGRUPPE	QPGR	CODEGRUPPE	KEY	1	CN
4	QPACV	FEHLKLASSE	TQ17	FEHLKLASSE	REF	C	CN
5	QPACV	FOLGEAKTI	TQ07	FOLGEAKTI
6	QPACV	KATALOGART	TQ15	KATALOGART	KEY	1	CN
7	QPACV	MANDT	T000	MANDT	KEY	1	CN
8	QPACV	SPRACHE	T002	SPRAS	REF	1	CN
9	QPACV	WAEHRUNG	TCURC	WAERS	REF	C	CN
10	QPACV	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in