| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7QA17H | Sponsor ID | 6 | PRONR | Company Representative | nvarchar | 8 | 0 | | |
2 | ZPS1 | IDES Text Pools | 9 | PRONR | Project definition (internal) | nvarchar | 8 | 0 | | |
3 | ZPS1_OLD | IDES: Assign text pool to standard structure | 9 | PRONR | Project definition (internal) | nvarchar | 8 | 0 | | |
TOPDSD Connector |
4 | /DSD/ME_PRO_FBAM | MDSD Promotions - Feedback Amounts in Connector | 3 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
5 | /DSD/ME_PRO_FBFG | MDSD Promotions - Feedback Free Goods in Connector | 3 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
TOPGlobal Trade Services |
6 | /SAPSLL/CUIT | Customs Document: Item | 97 | PRONR | Project Number | nvarchar | 20 | 0 | | |
7 | /SAPSLL/LCLICJ | License - Projects | 4 | PRONR | Project Number | nvarchar | 20 | 0 | | |
8 | /SAPSLL/LCPRO | Project Master | 3 | PRONR | Project Number | nvarchar | 20 | 0 | | |
TOPHandheld Connectivity |
9 | /DSD/PR_ASGN | MDSD Promotions - Promotion Assignment | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
10 | /DSD/PR_FBAM | MDSD Promotions - Feedback Amounts | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
11 | /DSD/PR_FBFG | MDSD Promotions - Feedback Free Goods | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
12 | /DSD/PR_HEAD | MDSD Promotion - Promotion Header | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
13 | /DSD/PR_HEAD_T | MDSD Promotions - Promotion Description | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
14 | /DSD/PR_PCLN | MDSD Promotions - Promotion Precondition | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
15 | /DSD/PR_RSAM | MDSD Promotions - Promotion Result Amounts | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
16 | /DSD/PR_RSFG | MDSD Promotions - Promotion Result Free Goods | 2 | PRONR | DSD Deal Conditions - Deal Condition Number | nvarchar | 10 | 0 | | |
TOPImplementation Guide |
17 | TCUSP | Customizing: Implementation project profile | 1 | PRONR | Number of the implementation project in Customizing | nvarchar | 3 | 0 | | |
18 | TCUSP40 | Customizing: Implementation project profile | 1 | PRONR | Project number for Customizing project | nvarchar | 8 | 0 | | |
19 | TCUSP40T | Customizing: Implementation project profile | 2 | PRONR | Project number for Customizing project | nvarchar | 8 | 0 | | |
20 | TCUSPT | Customizing: Implementation project profile | 2 | PRONR | Number of the implementation project in Customizing | nvarchar | 3 | 0 | | |
21 | TCUSS | Customizing: Implementation project - name | 2 | PRONR | Number of the implementation project in Customizing | nvarchar | 3 | 0 | | |
TOPInformation System |
22 | DSKOP | Balance Audit Trail | 71 | PRONR | Project Number | nvarchar | 16 | 0 | | |
TOPMaterial |
23 | TCNIF | Assembly item/WBS element assignment BOM transfer | 2 | PRONR | Project definition (internal) | nvarchar | 8 | 0 | | |
24 | TCNIP01 | Control stock/account assignment for interface EBOM/PS | 2 | PRONR | Project Definition | nvarchar | 24 | 0 | | |
TOPProduction Orders |
25 | AFKO | Order Header Data PP Orders | 59 | PRONR | Project definition | nvarchar | 8 | 0 | | |
TOPProject System |
26 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 21 | PRONR | Project definition | nvarchar | 8 | 0 | | |
27 | PSHLP_HIER_DB | Local cache:Project/Independent Network hierarchy | 21 | PRONR | Project definition | nvarchar | 8 | 0 | | |
TOPRevenues and Earnings |
28 | VPKSDITEM | Sales Pricing Header Data (Specific to SD) | 5 | PRONR | Project definition (internal) | nvarchar | 8 | 0 | | |
TOPSimulation |
29 | VSAFKO_CN | Version: Order header data for PP orders | 60 | PRONR | Project definition | nvarchar | 8 | 0 | | |