SAP Table VPKHEAD
Sales Pricing Header Data
VPKHEAD (Sales Pricing Header Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VPKHEAD to other SAP tables.
VPKHEAD table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
VPKID | Sales pricing document number | VPKID | NUMC | 10 | 0 | |||||||||||||||
AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||
VBELN | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||||||||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | 0 | |||||||||||||||
KNUMV_G | Number of the document condition | KNUMV | CHAR | 10 | 0 | |||||||||||||||
VPKUS | Sales pricing usage | VPKUS | NUMC | 2 | 0 |
Possible values
|
||||||||||||||
PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR | 8 | 0 | ||||||||||||||
PROFUS | Usage of the DI profile | AD01USAGE | AD01C_PROF | NUMC | 2 | 0 | ||||||||||||||
FAKTF | Billing form | FAKTF | CHAR | 2 | 0 |
Possible values
|
||||||||||||||
VPKSTEXT | Sales pricing short text | VPKSTEXT | CHAR | 40 | 0 | |||||||||||||||
ERNAME | User Name | SYUNAME | CHAR | 12 | 0 | |||||||||||||||
ERDAT | System Date | SYDATUM | DATS | 8 | 0 | |||||||||||||||
ERZEIT | System Time | SYUZEIT | TIMS | 6 | 0 | |||||||||||||||
AENAME | User Name | SYUNAME | CHAR | 12 | 0 | |||||||||||||||
AEDAT | System Date | SYDATUM | DATS | 8 | 0 | |||||||||||||||
AEZEIT | System Time | SYUZEIT | TIMS | 6 | 0 | |||||||||||||||
PERIODFROM | From Period | VPKPERIODFROM | NUMC | 3 | 0 | |||||||||||||||
YEARFROM | From Fiscal Year | VPKYEARFROM | NUMC | 4 | 0 | |||||||||||||||
DATETO | Posting date to | VPKDATETO | DATS | 8 | 0 | |||||||||||||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | 0 | |||||||||||||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | 0 | |||||||||||||||
ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | 0 | |||||||||||||||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | 0 | |||||||||||||||
VPKPLERL | Indicator: sales pricing planned revenus written | VPKPLERL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
SDAUART | Sales Document Type | AUART | TVAK | CHAR | 4 | 0 | ||||||||||||||
SDAUARG | Sales Document Type for Credit Memo Request | AUARG | TVAK | CHAR | 4 | 0 | ||||||||||||||
TIMESTAMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC | 16 | 0 | |||||||||||||||
PRSDT | Pricing date | VPKPRSDT | DATS | 8 | 0 | |||||||||||||||
PERIOD_RA | Results Analysis Period | VPKPERIOD_RA | NUMC | 3 | 0 | |||||||||||||||
YEAR_RA | Results Analysis Fiscal Year | VPKYEAR_RA | NUMC | 4 | 0 |
VPKHEAD foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
VPKHEAD | AUFNR | VPKHEAD | MANDT | AUFK | Order master data | MANDT |
VPKHEAD | AUFNR | VPKHEAD | AUFNR | AUFK | Order master data | AUFNR |
VPKHEAD | MANDT | VPKHEAD | MANDT | T000 | Clients | MANDT |
VPKHEAD | PROFNR | VPKHEAD | MANDT | AD01C_PROF | DIP profile: Usage | MANDT |
VPKHEAD | PROFNR | VPKHEAD | PROFNR | AD01C_PROF | DIP profile: Usage | PROFNR |
VPKHEAD | PROFNR | VPKHEAD | PROFUS | AD01C_PROF | DIP profile: Usage | DPUS |
VPKHEAD | PROFUS | VPKHEAD | PROFNR | AD01C_PROF | DIP profile: Usage | PROFNR |
VPKHEAD | PROFUS | VPKHEAD | PROFUS | AD01C_PROF | DIP profile: Usage | DPUS |
VPKHEAD | PROFUS | VPKHEAD | MANDT | AD01C_PROF | DIP profile: Usage | MANDT |
VPKHEAD | SDAUARG | VPKHEAD | SDAUARG | TVAK | Sales Document Types | AUART |
VPKHEAD | SDAUARG | VPKHEAD | MANDT | TVAK | Sales Document Types | MANDT |
VPKHEAD | SDAUART | VPKHEAD | MANDT | TVAK | Sales Document Types | MANDT |
VPKHEAD | SDAUART | VPKHEAD | SDAUART | TVAK | Sales Document Types | AUART |
VPKHEAD | VBELN | VPKHEAD | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
VPKHEAD | VBELN | VPKHEAD | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |