SAP ABAP View V_VPKAD01DLI (View of Dynamic Items in a Sales Pricing and Their Attribs)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ PS-REV (Application Component) Revenues and Earnings
⤷ VPK (Package) Resource-Related Billing / Sales Pricing
⤷ PS-REV (Application Component) Revenues and Earnings
⤷ VPK (Package) Resource-Related Billing / Sales Pricing
Basic Data
View Type | D | Database View |
Database View | V_VPKAD01DLI | |
Short Description | View of Dynamic Items in a Sales Pricing and Their Attribs | |
Root table | AD01DLI | Dynamic items (DI) |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | AD01DLI | AD01DLI | ||
2 | VPKDLI |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | AD01DLI | MANDT | JL | EQ | 0 | 0 | ||||
2 | VPKDLI | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | AD01DLI | DLINR | JL | EQ | 0 | 0 | ||||
4 | VPKDLI | DLINR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | * | AD01DLI | * | |||||
2 | MANDT | AD01DLI | MANDT | MANDT | Client | |||
3 | DLINR | AD01DLI | DLINR | AD01DLINR | Number of the Dynamic Item | |||
4 | OBJNR | AD01DLI | OBJNR | J_OBJNR | Object number | |||
5 | POPER | AD01DLI | POPER | AD01PERIOD | Posting period | |||
6 | TWAER | AD01DLI | TWAER | TWAER | Transaction Currency | |||
7 | MEINH | AD01DLI | MEINH | CO_MEINH | Unit of Measure | |||
8 | MANUAL | AD01DLI | MANUAL | XFELD | Checkbox | |||
9 | KSTAR | AD01DLI | KSTAR | KSTAR | Cost Element | |||
10 | KOSTL | AD01DLI | KOSTL | KOSTL | Cost Center | |||
11 | LSTAR | AD01DLI | LSTAR | LSTAR | Activity Type | |||
12 | MATNR | AD01DLI | MATNR | MATNR | Material Number | |||
13 | STAGR | AD01DLI | STAGR | STAGR | Statistical key figure | |||
14 | FIPOS | AD01DLI | FIPOS | FIPOS | Commitment Item | |||
15 | WRTTP | AD01DLI | WRTTP | CO_WRTTP | Value Type | |||
16 | VERSN | AD01DLI | VERSN | VERSN | Version | |||
17 | WERKS | AD01DLI | WERKS | WERKS_D | Plant | |||
18 | PRODU | AD01DLI | PRODU | PRODN | Product number | |||
19 | FAKTF | AD01DLI | FAKTF | FAKTF | Billing Form | |||
20 | BEMOT | AD01DLI | BEMOT | BEMOT | Accounting Indicator | |||
21 | BELNR | AD01DLI | BELNR | CO_BELNR | Document Number | |||
22 | BUZEI | AD01DLI | BUZEI | CO_BUZEI | Posting row | |||
23 | ARBPL | AD01DLI | ARBPL | ARBPL | Work center | |||
24 | AWERK | AD01DLI | AWERK | AD01AWERK | Plant of Work Center | |||
25 | PRZNR | AD01DLI | PRZNR | CO_PRZNR | Business Process | |||
26 | ASNUM | AD01DLI | ASNUM | ASNUM | Activity Number | |||
27 | PERNR | AD01DLI | PERNR | HR_PERNR | Personnel Number | |||
28 | /CBAD/ORIG_OBJNR | AD01DLI | /CBAD/ORIG_OBJNR | /CBAD/ORIG_OBJNR | CBAD Original Object Number | |||
29 | /CBAD/BILL_WBS | AD01DLI | /CBAD/BILL_WBS | /CBAD/PS_POSNR | CBAD WBS Element | |||
30 | PRS_WORK_PERIOD | AD01DLI | PRS_WORK_PERIOD | PRS_WORK_PERIOD | Work Period (Internal Representation) | |||
31 | GSBER | AD01DLI | GSBER | GSBER | Business Area | |||
32 | PARGB | AD01DLI | PARGB | PARGB | Trading partner's business area | |||
33 | PRCTR | AD01DLI | PRCTR | PRCTR | Profit Center | |||
34 | PPRCTR | AD01DLI | PPRCTR | PPRCTR | Partner Profit Center | |||
35 | ORDERED_PROD | AD01DLI | ORDERED_PROD | CRMT_ORDERED_PROD_DB | Product Name Entered | |||
36 | CATEGORY_ID | AD01DLI | CATEGORY_ID | COMT_CATEGORY_ID | Category ID | |||
37 | AWSYS | AD01DLI | AWSYS | AWSYS | Logical system of source document | |||
38 | SERV_AGENT_ID | AD01DLI | SERV_AGENT_ID | BU_PARTNER | Business Partner Number | |||
39 | REF_OBJECT_ID | AD01DLI | REF_OBJECT_ID | CRMT_OBJECT_ID_DB | Transaction ID | |||
40 | REF_OBJECT_ITEM | AD01DLI | REF_OBJECT_ITEM | CRMT_ITEM_NO | Item Number in Document | |||
41 | ORIG_OBJNR | AD01DLI | ORIG_OBJNR | DPICB_OBJNR | Object Number of Original Object | |||
42 | FAREA | AD01DLI | FAREA | FM_FAREA | Functional Area | |||
43 | RGRANT_NBR | AD01DLI | RGRANT_NBR | GM_GRANT_NBR | Grant | |||
44 | WBS_ELEMENT | AD01DLI | WBS_ELEMENT | PS_POSNR | WBS Element | |||
45 | ORDERID | AD01DLI | ORDERID | AUFNR | Order Number | |||
46 | FUNDS_CTR | AD01DLI | FUNDS_CTR | FISTL | Funds Center | |||
47 | FUND | AD01DLI | FUND | BP_GEBER | Fund | |||
48 | SPONSORED_PROG | AD01DLI | SPONSORED_PROG | GM_SPONSORED_PROG | Sponsored Program | |||
49 | SPONSORED_CLASS | AD01DLI | SPONSORED_CLASS | GM_SPONSORED_CLASS | Sponsored Class | |||
50 | GL_SIRID | AD01DLI | GL_SIRID | GU_RECID | Record number of the line item record | |||
51 | REFDOCNR | AD01DLI | REFDOCNR | REFBELNR | Reference document number of an accounting document | |||
52 | REFDOCLN | AD01DLI | REFDOCLN | REFBUZEI6 | Six-digit number of the reference posting line | |||
53 | SGTXT | AD01DLI | SGTXT | SGTXT | Item Text | |||
54 | GM_VALUETYPE | AD01DLI | GM_VALUETYPE | GM_VALUETYPE | GM Value Type | |||
55 | ASSETMAINO | AD01DLI | ASSETMAINO | BF_ANLN1 | Main Asset Number | |||
56 | ASSETSUBNO | AD01DLI | ASSETSUBNO | BF_ANLN2 | Asset Subnumber | |||
57 | DLISRC | AD01DLI | DLISRC | AD01DLISRC | Dynamic Item Source | |||
58 | PROFNR | AD01DLI | PROFNR | AD01PROFNR | Dynamic Item Processor Profile | |||
59 | TIMESTMP | AD01DLI | TIMESTMP | RKE_HZSTMP | Time created (Greenwich Meantime) | |||
60 | VPKID | VPKDLI | VPKID | VPKID | Sales pricing document number | |||
61 | POSNR | VPKDLI | POSNR | POSNR_VA | Sales Document Item | |||
62 | VWAER | VPKDLI | VWAER | WAERK | SD document currency | |||
63 | MATNR_SD | VPKDLI | MATNR_SD | VPK_MATNR_SD | Material number for determining the sales price | |||
64 | SO_WTGBTR | VPKDLI | SO_WTGBTR | WTGXXX | Total Value in Transaction Currency | |||
65 | SO_WOGBTR | VPKDLI | SO_WOGBTR | WOGXXX | Total Value in Object Currency | |||
66 | SO_WKGBTR | VPKDLI | SO_WKGBTR | WKGXXX | Total Value in Controlling Area Currency | |||
67 | SO_MEGBTR | VPKDLI | SO_MEGBTR | MEGXXX | Total Quantity | |||
68 | IN_WTGBTR | VPKDLI | IN_WTGBTR | WTGXXX | Total Value in Transaction Currency | |||
69 | IN_WOGBTR | VPKDLI | IN_WOGBTR | WOGXXX | Total Value in Object Currency | |||
70 | IN_WKGBTR | VPKDLI | IN_WKGBTR | WKGXXX | Total Value in Controlling Area Currency | |||
71 | IN_MEGBTR | VPKDLI | IN_MEGBTR | MEGXXX | Total Quantity | |||
72 | NO_WTGBTR | VPKDLI | NO_WTGBTR | WTGXXX | Total Value in Transaction Currency | |||
73 | NO_WOGBTR | VPKDLI | NO_WOGBTR | WOGXXX | Total Value in Object Currency | |||
74 | NO_WKGBTR | VPKDLI | NO_WKGBTR | WKGXXX | Total Value in Controlling Area Currency | |||
75 | NO_MEGBTR | VPKDLI | NO_MEGBTR | MEGXXX | Total Quantity | |||
76 | NETVALUE | VPKDLI | NETVALUE | VPKNETVALUE | Net value (price) | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |