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
01 Billing
11 Creating Quotations: Sales Pricing for Projects
12 Sales Pricing for Projects with Project Builder
21 Res.Anyls w/o Res.Simultn for WIP, WIP = Costs to be Billed
22 Res.Anyls with Res.Simultn for WIP, WIP = Costs to be Billed
23 Res.Anyls with Res.Simultn, WIP = Simulated Revenue
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
01 Fixed rate
02 Costs
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
X Yes
NULL No
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