SAP table RV45A (Data Fields for SAPMV45A)

Field Description Data Type Length Decimals Checktable Data Element
BSTNK Customer Reference as Matchcode Field CHAR 35 0 BSTKD_M
KUNNR Sold-to Party CHAR 10 0 * KUNAG
LFNKD Delivery CHAR 10 0 VBELN_VL
PSPID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
KDMAT Customer Material CHAR 35 0 KDMAT
KNREF Customer description of partner (plant, storage location) CHAR 30 0 KNREF
ABLAD Unloading Point CHAR 25 0 ABLAD
ABRVW Usage Indicator CHAR 3 0 * ABRVW
KTEXT Search term for product proposal CHAR 40 0 KTEXT_V
AMODE Activity mode CHAR 1 0 AMODE
ARKTX Short text for sales order item CHAR 40 0 ARKTX
AUBST Purchase requisition with delivery scheduling CHAR 1 0 AUBST
BANFN Purchase Requisition Number CHAR 10 0 BANFN
BEDAE Requirements type CHAR 4 0 T459A BEDAE
BNFPO Item number of purchase requisition NUMC 5 0 BNFPO
BASMN Base quantity QUAN 13 3 BASMN
BTGEW Total Weight QUAN 15 3 GSGEW
NTGEW Net weight QUAN 15 3 NTGEW_15
GEWEI Weight Unit UNIT 3 0 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 VOLEH
CUA_LONG Text of title line CHAR 60 0 CUA_TIT_TX
DRUCK Document was printed CHAR 1 0 DRUCK
DWERK Delivering Plant (Own or External) CHAR 4 0 DWERK_EXT
EWERT Expected Value CURR 15 2 EWERT
ETDAT Schedule Line Date CHAR 10 0 ETDAT
ETDATB Schedule Line Date CHAR 10 0 ETDAT
FORM1 Tag column CHAR 2 0 TDFORMAT
GRETD Schedule line date for the delivery group DATS 8 0 GRETD
GRMBD Material availability date for the delivery group DATS 8 0 GRMBD
KDKOP General business data from the header valid CHAR 1 0 KDKOP
KEDATU Requested delivery date DATS 8 0 KEDATU
KETDAT Requested Delivery Date of the Document CHAR 10 0 KETDAT
KNDNR Sold-to Party CHAR 10 0 KNA1 KUNAG
KMPMG Component Quantity QUAN 13 3 KMPMG
KPRGRS Default period CHAR 1 0 KPRGRS
KOEIN Condition Unit (Currency, Sales Unit, or %) CUKY 5 0 KOEIN
KPRGBZ Date Type of the Requested Delivery Date CHAR 1 0 TPRG KPRGBZ
KAPPL Application CHAR 2 0 T681A KAPPL
KNTTP Account Assignment Category CHAR 1 0 KNTTP
KTONR Number of an SD Business Partner CHAR 10 0 KTONR
KWMENG Cumulative order quantity in sales units QUAN 15 3 KWMENG
KWMENG_H Cumulative order quantity in sales units QUAN 15 3 KWMENG
KZLTX More Text Exists CHAR 1 0 LTXKZ
LTEXT Long Text CHAR 40 0 LTEXT
MATNR Material Number CHAR 40 0 MARA MATNR
MEINS1 Base Unit of Measure UNIT 3 0 T006 MEINS
NAME1 Name CHAR 30 0 NAME1
PO_MATNR Material Number CHAR 40 0 MATNR
PO_ARKTX Short text for sales order item CHAR 40 0 ARKTX
PO_KDMAT Customer Material CHAR 35 0 KDMAT
PART0 No business partners allowed CHAR 1 0 PART0
POSNR Item number of the SD document NUMC 6 0 POSNR
PREIS Price CURR 11 2 PREIS
PRGBZ External Date Type CHAR 1 0 TPRG PRGBZ
PRGBZB External Date Type CHAR 1 0 PRGBZ
PRSFD Carry out pricing CHAR 1 0 PRSFD
No pricing
A Pricing for empties
B Pricing for free goods (100% discount)
X Pricing standard
PSTYP Item category in purchasing document CHAR 1 0 PSTYP
PSTYV Sales document item category CHAR 4 0 PSTYV
SERNR_VOR BOM explosion number CHAR 8 0 SERNR
S_ABGRU Reason for Rejection of Sales Documents CHAR 2 0 TVAG ABGRU_VA
S_LIFSP Schedule Line Blocked for Delivery CHAR 2 0 TVLS LIFSP_EP
S_LIFSK Delivery Block (Document Header) CHAR 2 0 TVLS LIFSK
S_LPRIO Delivery Priority NUMC 2 0 TPRIO LPRIO
S_FAKSP Billing Block CHAR 2 0 TVFS FAKSP
S_FAKSK Billing Block in SD Document CHAR 2 0 TVFS FAKSK
S_PRGBZ Date type for new requested delivery date CHAR 1 0 TPRG S_PRGBZ
S_ETDAT New delivery date CHAR 10 0 S_ETDAT
S_WERKS Plant (Own or External) CHAR 4 0 WERKS_EXT
SPRAS Language Key LANG 1 0 T002 SPRAS
SPRAS_VOR Language Key LANG 1 0 T002 SPRAS
STTXT System status line CHAR 40 0 J_STEXT
TTEXT Short text CHAR 30 0 TDTEXT
TXT_ANGDT Date from which a quotation/inquiry is valid CHAR 20 0 TXT_ANGVO
TXT_BNDDT Date up to which a quotation/inquiry is valid CHAR 20 0 TXT_ANGBI
TXT_AUART Sales document type CHAR 20 0 TXT_AUART
TXT_SELKZ Selection indicator for list screens CHAR 1 0 SELKZ_LIST
TXT_TITCUA Name CHAR 20 0 VTXTK
TXT_TITEL Name CHAR 20 0 VTXTK
TXT_VBELN Document number CHAR 20 0 TXT_VBELN
TXT_VTRBER Sales Area CHAR 64 0 TXT_VTRBER
UEPOS Item number of the SD document NUMC 6 0 POSNR
VBAP_SELKZ Selection indicator for list screens CHAR 1 0 SELKZ_LIST
VBEP_SELKZ Selection indicator for list screens CHAR 1 0 SELKZ_LIST
VRKME1 Sales unit UNIT 3 0 T006 VRKME
VRKME2 Sales unit UNIT 3 0 T006 VRKME
VRKME3 Sales unit UNIT 3 0 T006 VRKME
VRKME4 Sales unit UNIT 3 0 T006 VRKME
VSMNG Delivered quantity in sales units QUAN 13 3 VSMNG
WAERS Currency Key CUKY 5 0 TCURC WAERS
WAERZ SD Document Currency CUKY 5 0 TCURC WAERK
WEMPF Ship-to Party CHAR 10 0 KNA1 KUNWE
WRKLG Plant/storage location CHAR 1 0 WRKLG
ZEILE_LEER Current line of the list layout is empty CHAR 1 0 DZEILE_LEE
ZIEME Target Quantity UoM UNIT 3 0 T006 DZIEME
ZIEME1 Target Quantity UoM UNIT 3 0 T006 DZIEME
ZMENG Target quantity in sales units QUAN 13 3 DZMENGV
ASTTX User Status CHAR 40 0 ASTTX
VBSN_SELKZ Selection indicator for list screens CHAR 1 0 SELKZ_LIST
AUFNO Order Number CHAR 12 0 AUFNR
PLANO Planned Order CHAR 10 0 PLNUM
VBELNTO Sales and Distribution Document Number CHAR 10 0 VBELN
AUARTTO Sales Document Type CHAR 4 0 TVAK AUART
KFREL Indicator for billing plan in header CHAR 1 0 KFREL
WAKTION Promotion CHAR 10 0 WAKH WAKTION
VKORG Sales Organization CHAR 4 0 TVKO VKORG
ABHOV Pick-Up Time TIMS 6 0 ABHOZ
ABHOB Pick-Up Time TIMS 6 0 ABHOZ
ABHOD Pick-Up Date DATS 8 0 ABHOD
AWERT Value of Value Contract Already Released CURR 17 2 ABRUFWERT
SKOPF Assortment module CHAR 18 0 WSOH W_SORTK
PRODH Product hierarchy CHAR 18 0 PRODH_D
ZWERT Target Value for Outline Agreement in Document Currency CURR 13 2 DZWERT
RKTIO Response on reaching release order value in value contract CHAR 1 0 RKTIO
No response if target value is exceeded
A Warning if target value is exceeded
B Error message if target value is exceeded
C First time target value is exceeded, permitted with warning
D As for 'A' but value contract is not blocked
ABGESP Percent rate of guaranteed value DEC 5 2 ABGESP
MONTBFLAG Assembly Procurement. For use in FV45EFMA CHAR 1 0 MONTBFLAG
DOCNUM IDoc number NUMC 16 0 EDI_DOCNUM
KEZEIT Requested delivery time TIMS 6 0 KEZEIT
SPART Division CHAR 2 0 SPART
PO_POSEX Item Number of the Underlying Purchase Order CHAR 6 0 POSEX
FFPRF Dynamic Item Processor Profile CHAR 8 0 AD01C_PROF AD01PROFNR
TXT_ABRUF_PART Short Text for Fixed Values CHAR 60 0 VAL_TEXT
RB_AUART Alternative sales document type CHAR 1 0 RB_AAUART
RB_AAUART1 Alternative sales document type CHAR 1 0 RB_AAUART
RB_AAUART2 Alternative sales document type CHAR 1 0 RB_AAUART
TXT_RB_AUART Alternative sales document type CHAR 20 0 TXT_AAUART
TXT_RB_AAUART1 Alternative sales document type CHAR 20 0 TXT_AAUART
TXT_RB_AAUART2 Alternative sales document type CHAR 20 0 TXT_AAUART
MONTAGE_INIT Assembly procurement. Initialization necessary CHAR 1 0 MONTAGE_INIT
KONFIG_INIT Configuration - Initialization needed CHAR 1 0 KONFIG_INIT
S_EZEIT New arrival time TIMS 6 0 S_EZEIT
TEXT_BESCHAFFUNG Procurement type text (purch. req., prod. or manuf. order) CHAR 35 0 TEXT_BESCHAFFUNG
MABNR Material Number CHAR 40 0 MATNR
MUEBS Characteristic Display CHAR 8 0 VBMUE MUEBS
MWERT01 Characteristic Value CHAR 70 0 ATWRT
MWERT02 Characteristic Value CHAR 70 0 ATWRT
MWERT03 Characteristic Value CHAR 70 0 ATWRT
MWERT04 Characteristic Value CHAR 70 0 ATWRT
MWERT05 Characteristic Value CHAR 70 0 ATWRT
MWERT06 Characteristic Value CHAR 70 0 ATWRT
MWERT07 Characteristic Value CHAR 70 0 ATWRT
MWERT08 Characteristic Value CHAR 70 0 ATWRT
MWERT09 Characteristic Value CHAR 70 0 ATWRT
MWERT10 Characteristic Value CHAR 70 0 ATWRT
MNAM01 Characteristic Name CHAR 30 0 ATNAM
MNAM02 Characteristic Name CHAR 30 0 ATNAM
MNAM03 Characteristic Name CHAR 30 0 ATNAM
MNAM04 Characteristic Name CHAR 30 0 ATNAM
MNAM05 Characteristic Name CHAR 30 0 ATNAM
MNAM06 Characteristic Name CHAR 30 0 ATNAM
MNAM07 Characteristic Name CHAR 30 0 ATNAM
MNAM08 Characteristic Name CHAR 30 0 ATNAM
MNAM09 Characteristic Name CHAR 30 0 ATNAM
MNAM10 Characteristic Name CHAR 30 0 ATNAM
MBEZ01 Characteristic description CHAR 30 0 ATBEZ
MBEZ02 Characteristic description CHAR 30 0 ATBEZ
MBEZ03 Characteristic description CHAR 30 0 ATBEZ
MBEZ04 Characteristic description CHAR 30 0 ATBEZ
MBEZ05 Characteristic description CHAR 30 0 ATBEZ
MBEZ06 Characteristic description CHAR 30 0 ATBEZ
MBEZ07 Characteristic description CHAR 30 0 ATBEZ
MBEZ08 Characteristic description CHAR 30 0 ATBEZ
MBEZ09 Characteristic description CHAR 30 0 ATBEZ
MBEZ10 Characteristic description CHAR 30 0 ATBEZ
BTN_FCODE Function code for procurement button CHAR 20 0 BTN_FCODE
BUKRSL Country/Region Key CHAR 3 0 LAND1
STAT01 Active/inactive status CHAR 1 0 STATUSFLAG
STAT02 Active/inactive status CHAR 1 0 STATUSFLAG
STAT03 Active/inactive status CHAR 1 0 STATUSFLAG
STAT04 Active/inactive status CHAR 1 0 STATUSFLAG
STAT05 Active/inactive status CHAR 1 0 STATUSFLAG
STAT06 Active/inactive status CHAR 1 0 STATUSFLAG
STAT07 Active/inactive status CHAR 1 0 STATUSFLAG
STAT08 Active/inactive status CHAR 1 0 STATUSFLAG
STAT09 Active/inactive status CHAR 1 0 STATUSFLAG
STAT10 Active/inactive status CHAR 1 0 STATUSFLAG
PVS01 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS02 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS03 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS04 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS05 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS06 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS07 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS08 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS09 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS10 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS11 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
PVS12 Column title (quantity from product proposal) CHAR 20 0 PVSTXT
CCODE Catalog code CHAR 4 0 W_PC_CCODE
CCODE_HEAD Product catalog code at header level in sales order CHAR 4 0 CCODE_HEAD
WMINR Product catalog at header level in sales order CHAR 10 0 WMINR_HEAD
MWSBK Tax Amount in Document Currency CURR 13 2 MWSBP
ENDBP Total amount of item CURR 15 2 ENDBP
ENDBK Total Amount of Document CURR 15 2 ENDBK
TXT_MABNR Material (order number) description CHAR 20 0 TXT_MABNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
VKONT Character Field of Length 12 CHAR 12 0 CHAR12
VKBEZ Data Element Type CHAR Length 35 CHAR 35 0 CHAR35
KZTLF_T Description CHAR 30 0 BEZEI30
VTREF Char 20 CHAR 20 0 CHAR20
VTBEZ Data Element Type CHAR Length 35 CHAR 35 0 CHAR35
TXTHOL Display text for Handover Loc (name, city, ctry/reg, street) CHAR 255 0 TXTHOL
REQUESTED_QTY Requested Quantity QUAN 15 3 REQD_QTY
REQUESTED_UOM Unit of the Requested Quantity UNIT 3 0 REQD_QTY_UNIT
MAKTX Material Description CHAR 40 0 MAKTX
S_VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
S_ROUTE Route CHAR 6 0 ROUTE
TXT_TRANSIT_PLANT Name CHAR 30 0 NAME1
FSHEXPAND Expand or Collapse CHAR 132 0 FSH_EXPCOLL
RFM_PRIORITY Priority NUMC 2 0 RFM_PRIORITY
RFM_SEASON_CATEGORY Season Category CHAR 5 0 RFM_SEASON_CATEGORY
MILL_SE_DYFCODE Display Criteria CHAR 40 0 MILL_SE_SCOPE
MILL_SE_ICON Configuration status CHAR 73 0 MILL_SE_ICON
MILL_SE_USER Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
RFM_REJECTION_QTY Cumulative order quantity in sales units QUAN 15 3 KWMENG
RFM_REJECTION_REASON Reason for rejection of quotations and sales orders CHAR 2 0 ABGRU
RFM_REJECTION_TYPE RFM rejection type for manage excess requirements CHAR 2 0 RFM_REJECTION_TYPE
01 Reject Open Quantity for Confirmation
02 Reject Open Quantity for Assignment
03 Reject Open Quantity for Delivery
04 Reject Open Quantity for Reference
05 Reject Open Quantity for Alignment
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
WRF_CHARSTC1_TXT Characteristic Description 1 CHAR 70 0 WRF_CHARSTC1_TEXT
WRF_CHARSTC2_TXT Characteristic Description 2 CHAR 70 0 WRF_CHARSTC2_TEXT
WRF_CHARSTC3_TXT Characteristic Description 3 CHAR 70 0 WRF_CHARSTC3_TEXT

RV45A foreign key relationships

Table Field Check Table Check Field
0 RV45A AUARTTO TVAK Sales Document Types MANDT
0 RV45A AUARTTO TVAK Sales Document Types AUART
1 RV45A BEDAE T459A External requirements types MANDT
0 RV45A FFPRF AD01C_PROF DIP profile: Usage MANDT
0 RV45A FFPRF AD01C_PROF DIP profile: Usage PROFNR
1 RV45A KAPPL T681A Conditions: Applications KAPPL
0 RV45A KNDNR KNA1 General Data in Customer Master MANDT
0 RV45A KNDNR KNA1 General Data in Customer Master KUNNR
1 RV45A KPRGBZ TPRG Date display format MANDT
1 RV45A KPRGBZ TPRG Date display format SPRAS
0 RV45A MATNR MARA General Material Data MANDT
0 RV45A MATNR MARA General Material Data MATNR
1 RV45A MEINS1 T006 Units of Measurement MANDT
0 RV45A MUEBS VBMUE Sales Document: Characteristic Overview MANDT
1 RV45A PRGBZ TPRG Date display format MANDT
1 RV45A PRGBZ TPRG Date display format SPRAS
0 RV45A SKOPF WSOH Assortment Modules SAP Retail MANDT
1 RV45A SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 RV45A SPRAS_VOR T002 Language Keys (Component BC-I18) SPRAS
1 RV45A S_ABGRU TVAG Sales Documents: Rejection Reasons MANDT
1 RV45A S_ABGRU TVAG Sales Documents: Rejection Reasons ABGRU
0 RV45A S_FAKSK TVFS Billing: Reasons for Blocking FAKSP
1 RV45A S_FAKSP TVFS Billing: Reasons for Blocking FAKSP
0 RV45A S_LIFSK TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 RV45A S_LIFSK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 RV45A S_LIFSP TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 RV45A S_LIFSP TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 RV45A S_LPRIO TPRIO Customers: Delivery Priorities LPRIO
1 RV45A S_PRGBZ TPRG Date display format MANDT
1 RV45A S_PRGBZ TPRG Date display format SPRAS
0 RV45A VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 RV45A VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 RV45A VRKME1 T006 Units of Measurement MANDT
0 RV45A VRKME2 T006 Units of Measurement MANDT
1 RV45A VRKME3 T006 Units of Measurement MANDT
0 RV45A VRKME4 T006 Units of Measurement MANDT
1 RV45A WAERS TCURC Currency Codes MANDT
1 RV45A WAERS TCURC Currency Codes WAERS
0 RV45A WAERZ TCURC Currency Codes MANDT
0 RV45A WAERZ TCURC Currency Codes WAERS
1 RV45A WAKTION WAKH Promotion Header Data, IS-R MANDT
1 RV45A WAKTION WAKH Promotion Header Data, IS-R AKTNR
0 RV45A WEMPF KNA1 General Data in Customer Master MANDT
0 RV45A WEMPF KNA1 General Data in Customer Master KUNNR
1 RV45A ZIEME T006 Units of Measurement MANDT
0 RV45A ZIEME1 T006 Units of Measurement MANDT