SAP ABAP Table V_VPKAD01DLI (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | V_VPKAD01DLI | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | DLINR | AD01DLINR | AD01DLINR | NUMC | 20 | 0 | Number of the Dynamic Item | ||
3 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
4 | POPER | AD01PERIOD | JAHRPER | NUMC | 7 | 0 | Posting period | ||
5 | TWAER | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
6 | MEINH | CO_MEINH | MEINS | UNIT | 3 | 0 | Unit of Measure | T006 | |
7 | MANUAL | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
8 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | CSKA | |
9 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
10 | LSTAR | LSTAR | LSTAR | CHAR | 6 | 0 | Activity Type | CSLA | |
11 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
12 | STAGR | STAGR | STAGR | CHAR | 6 | 0 | Statistical key figure | TKA03 | |
13 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | FMFPO | |
14 | WRTTP | CO_WRTTP | CO_WRTTP | CHAR | 2 | 0 | Value Type | ||
15 | VERSN | VERSN | COVERSI | CHAR | 3 | 0 | Version | TKVS | |
16 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
17 | PRODU | PRODN | MATNR | CHAR | 18 | 0 | Product number | MARA | |
18 | FAKTF | FAKTF | FAKTF | CHAR | 2 | 0 | Billing Form | ||
19 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | TBMOT | |
20 | BELNR | CO_BELNR | CO_BELNR | CHAR | 10 | 0 | Document Number | ||
21 | BUZEI | CO_BUZEI | BUZEI | NUMC | 3 | 0 | Posting row | ||
22 | ARBPL | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
23 | AWERK | AD01AWERK | WERKS | CHAR | 4 | 0 | Plant of Work Center | T001W | |
24 | PRZNR | CO_PRZNR | CO_PRZNR | CHAR | 12 | 0 | Business Process | CBPR | |
25 | ASNUM | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | ASMD | |
26 | PERNR | HR_PERNR | PERNR | NUMC | 8 | 0 | Personnel Number | ||
27 | /CBAD/ORIG_OBJNR | /CBAD/ORIG_OBJNR | J_OBJNR | CHAR | 22 | 0 | CBAD Original Object Number | ||
28 | /CBAD/BILL_WBS | /CBAD/PS_POSNR | PS_POSNR | NUMC | 8 | 0 | CBAD WBS Element | ||
29 | PRS_WORK_PERIOD | PRS_WORK_PERIOD | PRS_WORK_PERIOD | NUMC | 7 | 0 | Work Period (Internal Representation) | ||
30 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | ||
31 | PARGB | PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | ||
32 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
33 | PPRCTR | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | ||
34 | ORDERED_PROD | CRMT_ORDERED_PROD_DB | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
35 | CATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
36 | AWSYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | ||
37 | SERV_AGENT_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | ||
38 | REF_OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
39 | REF_OBJECT_ITEM | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
40 | ORIG_OBJNR | DPICB_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number of Original Object | ||
41 | FAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | ||
42 | RGRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
43 | WBS_ELEMENT | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | ||
44 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | ||
45 | FUNDS_CTR | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | ||
46 | FUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | ||
47 | SPONSORED_PROG | GM_SPONSORED_PROG | GM_SPONSORED_PROG | CHAR | 20 | 0 | Sponsored Program | ||
48 | SPONSORED_CLASS | GM_SPONSORED_CLASS | GM_SPONSORED_CLASS | CHAR | 20 | 0 | Sponsored Class | ||
49 | GL_SIRID | GU_RECID | OBJNR | CHAR | 18 | 0 | Record number of the line item record | ||
50 | REFDOCNR | REFBELNR | BELNR | CHAR | 10 | 0 | Reference document number of an accounting document | ||
51 | REFDOCLN | REFBUZEI6 | BUZEI6 | NUMC | 6 | 0 | Six-digit number of the reference posting line | ||
52 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
53 | GM_VALUETYPE | GM_VALUETYPE | GM_VALUETYPE | CHAR | 2 | 0 | GM Value Type | ||
54 | ASSETMAINO | BF_ANLN1 | BF_ANLN1 | CHAR | 12 | 0 | Main Asset Number | ||
55 | ASSETSUBNO | BF_ANLN2 | BF_ANLN2 | CHAR | 4 | 0 | Asset Subnumber | ||
56 | DLISRC | AD01DLISRC | AD01DLISRC | CHAR | 4 | 0 | Dynamic Item Source | AD01SRC | |
57 | PROFNR | AD01PROFNR | AD01PROFNR | CHAR | 8 | 0 | Dynamic Item Processor Profile | AD01C_PROF | |
58 | TIMESTMP | RKE_HZSTMP | RKE_TSTMP | DEC | 16 | 0 | Time created (Greenwich Meantime) | ||
59 | VPKID | VPKID | VPKID | NUMC | 10 | 0 | Sales pricing document number | VPKHEAD | |
60 | POSNR | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | ||
61 | VWAER | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | ||
62 | MATNR_SD | VPK_MATNR_SD | MATNR | CHAR | 18 | 0 | Material number for determining the sales price | ||
63 | SO_WTGBTR | WTGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Transaction Currency | ||
64 | SO_WOGBTR | WOGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Object Currency | ||
65 | SO_WKGBTR | WKGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Controlling Area Currency | ||
66 | SO_MEGBTR | MEGXXX | MENGV8 | QUAN | 15 | 3 | Total Quantity | ||
67 | IN_WTGBTR | WTGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Transaction Currency | ||
68 | IN_WOGBTR | WOGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Object Currency | ||
69 | IN_WKGBTR | WKGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Controlling Area Currency | ||
70 | IN_MEGBTR | MEGXXX | MENGV8 | QUAN | 15 | 3 | Total Quantity | ||
71 | NO_WTGBTR | WTGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Transaction Currency | ||
72 | NO_WOGBTR | WOGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Object Currency | ||
73 | NO_WKGBTR | WKGXXX | WERTV8 | CURR | 15 | 2 | Total Value in Controlling Area Currency | ||
74 | NO_MEGBTR | MEGXXX | MENGV8 | QUAN | 15 | 3 | Total Quantity | ||
75 | NETVALUE | VPKNETVALUE | WERTV8 | CURR | 15 | 2 | Net value (price) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | V_VPKAD01DLI | ASNUM | ASMD | ASNUM | |||
2 | V_VPKAD01DLI | AWERK | T001W | WERKS | |||
3 | V_VPKAD01DLI | BEMOT | TBMOT | BEMOT | |||
4 | V_VPKAD01DLI | DLISRC | AD01SRC | DLISRC | KEY | 1 | CN |
5 | V_VPKAD01DLI | FIPOS | FMFPO | FIPOS | |||
6 | V_VPKAD01DLI | KOSTL | CSKS | KOSTL | |||
7 | V_VPKAD01DLI | KSTAR | CSKA | KSTAR | |||
8 | V_VPKAD01DLI | LSTAR | CSLA | LSTAR | |||
9 | V_VPKAD01DLI | MANDT | T000 | MANDT | KEY | 1 | CN |
10 | V_VPKAD01DLI | MATNR | MARA | MATNR | KEY | 1 | CN |
11 | V_VPKAD01DLI | MEINH | T006 | MSEHI | KEY | 1 | CN |
12 | V_VPKAD01DLI | OBJNR | ONR00 | OBJNR | KEY | 1 | CN |
13 | V_VPKAD01DLI | PRODU | MARA | MATNR | |||
14 | V_VPKAD01DLI | PROFNR | AD01C_PROF | PROFNR | KEY | 1 | CN |
15 | V_VPKAD01DLI | PRZNR | CBPR | PRZNR | |||
16 | V_VPKAD01DLI | STAGR | TKA03 | STAGR | |||
17 | V_VPKAD01DLI | TWAER | TCURC | WAERS | KEY | 1 | CN |
18 | V_VPKAD01DLI | VERSN | TKVS | VERSI | |||
19 | V_VPKAD01DLI | VPKID | VPKHEAD | VPKID | KEY | 1 | CN |
20 | V_VPKAD01DLI | WERKS | T001W | WERKS | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |