SAP CRMST_QRESHIST_ERPIL table - ERP: Query Result Object - Order History details in SAP


SAP CRMST_QRESHIST_ERPIL table summary

Object Name: CRMST_QRESHIST_ERPIL
Dictionary Type: Structure
Description: ERP: Query Result Object - Order History


Field list for CRMST_QRESHIST_ERPIL table on an S/4 SAP system

Details
CRMST_QRESHIST_ERPIL-GUID table field - GUID of a CRM Order Object

Description: GUID of a CRM Order Object
Field Name: GUID
Data Element: CRMT_OBJECT_GUID
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: SYSUUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GUID

CRMST_QRESHIST_ERPIL-SD_DOC table field - Sales and Distribution Document Number

Description: Sales and Distribution Document Number
Field Name: SD_DOC
Data Element: VBELN
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: VBELN
MemoryID: AUN
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SD_DOC

CRMST_QRESHIST_ERPIL-ITM_NUMBER table field - Item number of the SD document

Description: Item number of the SD document
Field Name: ITM_NUMBER
Data Element: POSNR
Data Type: NUMC
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: POSNR
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ITM_NUMBER

CRMST_QRESHIST_ERPIL-MATERIAL table field - Material Number (18 Characters)

Description: Material Number (18 Characters)
Field Name: MATERIAL
Data Element: MATNR18
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine: MATN5
Domain Name: MATNR18
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: MATN5

See all SAP tables containing field MATERIAL

CRMST_QRESHIST_ERPIL-SHORT_TEXT table field - Short text for sales order item

Description: Short text for sales order item
Field Name: SHORT_TEXT
Data Element: ARKTX
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHORT_TEXT

CRMST_QRESHIST_ERPIL-DOC_TYPE table field - Sales Document Type

Description: Sales Document Type
Field Name: DOC_TYPE
Data Element: AUART
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine: AUART
Domain Name: AUART
MemoryID: AAT
AppClass: VA
SHLP:
SHLP Field:
ConvExit: AUART

See all SAP tables containing field DOC_TYPE

CRMST_QRESHIST_ERPIL-DOC_DATE table field - Document Date (Date Received/Sent)

Description: Document Date (Date Received/Sent)
Field Name: DOC_DATE
Data Element: AUDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOC_DATE

CRMST_QRESHIST_ERPIL-REQ_QTY table field - Cumulative order quantity in sales units

Description: Cumulative order quantity in sales units
Field Name: REQ_QTY
Data Element: KWMENG
Data Type: QUAN
length (Dec): 15(3)
Check table:
Conversion Routine:
Domain Name: MENG15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_QTY

CRMST_QRESHIST_ERPIL-REQ_DATE table field - Requested delivery date

Description: Requested delivery date
Field Name: REQ_DATE
Data Element: WLDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REQ_DATE

CRMST_QRESHIST_ERPIL-PURCH_NO table field - Customer Reference

Description: Customer Reference
Field Name: PURCH_NO
Data Element: BSTNK
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: BSTNK
MemoryID:
AppClass: VA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PURCH_NO

CRMST_QRESHIST_ERPIL-BATCH table field - Batch Number

Description: Batch Number
Field Name: BATCH
Data Element: CHARG_D
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHARG
MemoryID: CHA
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BATCH

CRMST_QRESHIST_ERPIL-VALID_FROM table field - Quotation or contract valid from

Description: Quotation or contract valid from
Field Name: VALID_FROM
Data Element: DATAB_VI
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALID_FROM

CRMST_QRESHIST_ERPIL-VALID_TO table field - Quotation or contract valid to

Description: Quotation or contract valid to
Field Name: VALID_TO
Data Element: DATBI_VI
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALID_TO

CRMST_QRESHIST_ERPIL-BILL_BLOCK table field - Billing Block in SD Document

Description: Billing Block in SD Document
Field Name: BILL_BLOCK
Data Element: FAKSK
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: FAKSP
MemoryID:
AppClass: VF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BILL_BLOCK

CRMST_QRESHIST_ERPIL-DLV_BLOCK table field - Delivery Block (Document Header)

Description: Delivery Block (Document Header)
Field Name: DLV_BLOCK
Data Element: LIFSK
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: LIFSP
MemoryID:
AppClass: VL
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DLV_BLOCK

CRMST_QRESHIST_ERPIL-SOLD_TO table field - Sold-to Party

Description: Sold-to Party
Field Name: SOLD_TO
Data Element: KUNAG
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: VAG
AppClass: V
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SOLD_TO

CRMST_QRESHIST_ERPIL-NAME table field - Name 1

Description: Name 1
Field Name: NAME
Data Element: NAME1_GP
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: NAME
MemoryID:
AppClass: VP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

CRMST_QRESHIST_ERPIL-EXCHG_RATE table field - Directly quoted exchange rate for pricing and statistics

Description: Directly quoted exchange rate for pricing and statistics
Field Name: EXCHG_RATE
Data Element: KURSK_P
Data Type: DEC
length (Dec): 9(5)
Check table:
Conversion Routine:
Domain Name: PKURS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCHG_RATE

CRMST_QRESHIST_ERPIL-DLV_QTY table field - Actual quantity delivered (in sales units)

Description: Actual quantity delivered (in sales units)
Field Name: DLV_QTY
Data Element: LFIMG
Data Type: QUAN
length (Dec): 13(3)
Check table:
Conversion Routine:
Domain Name: MENG13
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DLV_QTY

CRMST_QRESHIST_ERPIL-BASE_UOM table field - Base Unit of Measure

Description: Base Unit of Measure
Field Name: BASE_UOM
Data Element: MEINS
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field BASE_UOM

CRMST_QRESHIST_ERPIL-NET_PRICE table field - Net Price

Description: Net Price
Field Name: NET_PRICE
Data Element: NETPR
Data Type: CURR
length (Dec): 11(2)
Check table:
Conversion Routine:
Domain Name: WERTV6
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NET_PRICE

CRMST_QRESHIST_ERPIL-COND_P_UNT table field - Condition Pricing Unit

Description: Condition Pricing Unit
Field Name: COND_P_UNT
Data Element: KPEIN
Data Type: DEC
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: KPEIN
MemoryID:
AppClass: VF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COND_P_UNT

CRMST_QRESHIST_ERPIL-COND_UNIT table field - Condition Unit

Description: Condition Unit
Field Name: COND_UNIT
Data Element: KMEIN
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field COND_UNIT

CRMST_QRESHIST_ERPIL-NET_VAL_HD table field - Net Value of the Sales Order in Document Currency

Description: Net Value of the Sales Order in Document Currency
Field Name: NET_VAL_HD
Data Element: NETWR_AK
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: WERTV8
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NET_VAL_HD

CRMST_QRESHIST_ERPIL-NET_VALUE table field - Net Value of the Sales Order in Document Currency

Description: Net Value of the Sales Order in Document Currency
Field Name: NET_VALUE
Data Element: NETWR_AK
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: WERTV8
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NET_VALUE

CRMST_QRESHIST_ERPIL-DIVISION table field - Division

Description: Division
Field Name: DIVISION
Data Element: SPART
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: SPART
MemoryID: SPA
AppClass: V
SHLP: C_SPART
SHLP Field: SPART
ConvExit:

See all SAP tables containing field DIVISION

CRMST_QRESHIST_ERPIL-DOC_STATUS table field - Document status

Description: Document status
Field Name: DOC_STATUS
Data Element: STATS
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOC_STATUS

CRMST_QRESHIST_ERPIL-SALES_GRP table field - Sales group

Description: Sales group
Field Name: SALES_GRP
Data Element: VKGRP
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: VKGRP
MemoryID: VKG
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_GRP

CRMST_QRESHIST_ERPIL-SALES_OFF table field - Sales office

Description: Sales office
Field Name: SALES_OFF
Data Element: VKBUR
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: VKBUR
MemoryID: VKB
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_OFF

CRMST_QRESHIST_ERPIL-SALES_ORG table field - Sales Organization

Description: Sales Organization
Field Name: SALES_ORG
Data Element: VKORG
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: VKORG
MemoryID: VKO
AppClass: MG
SHLP: C_VKORG
SHLP Field: VKORG
ConvExit:

See all SAP tables containing field SALES_ORG

CRMST_QRESHIST_ERPIL-SALES_UNIT table field - Sales unit

Description: Sales unit
Field Name: SALES_UNIT
Data Element: VRKME
Data Type: UNIT
length (Dec): 3(0)
Check table:
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field SALES_UNIT

CRMST_QRESHIST_ERPIL-SHIP_POINT table field - Shipping Point / Receiving Point

Description: Shipping Point / Receiving Point
Field Name: SHIP_POINT
Data Element: VSTEL
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: VSTEL
MemoryID: VST
AppClass: VV
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SHIP_POINT

CRMST_QRESHIST_ERPIL-DISTR_CHAN table field - Distribution Channel

Description: Distribution Channel
Field Name: DISTR_CHAN
Data Element: VTWEG
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: VTWEG
MemoryID: VTW
AppClass: MG
SHLP: C_VTWEG
SHLP Field: VTWEG
ConvExit:

See all SAP tables containing field DISTR_CHAN

CRMST_QRESHIST_ERPIL-GI_DATE table field - Goods Issue Date

Description: Goods Issue Date
Field Name: GI_DATE
Data Element: WADAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GI_DATE

CRMST_QRESHIST_ERPIL-CURRENCY table field - SD Document Currency

Description: SD Document Currency
Field Name: CURRENCY
Data Element: WAERK
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID: FWS
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY

CRMST_QRESHIST_ERPIL-PLANT table field - Plant

Description: Plant
Field Name: PLANT
Data Element: WERKS_D
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: WERKS
MemoryID: WRK
AppClass: MG
SHLP: H_T001W_C
SHLP Field: WERKS
ConvExit:

See all SAP tables containing field PLANT

CRMST_QRESHIST_ERPIL-STORE_LOC table field - Storage location

Description: Storage location
Field Name: STORE_LOC
Data Element: LGORT_D
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: LGORT
MemoryID: LAG
AppClass: MG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STORE_LOC

CRMST_QRESHIST_ERPIL-ORD_REASON table field - Order Reason (Reason for the Business Transaction)

Description: Order Reason (Reason for the Business Transaction)
Field Name: ORD_REASON
Data Element: AUGRU
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: AUGRU
MemoryID:
AppClass: VA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORD_REASON

CRMST_QRESHIST_ERPIL-REASON_REJ table field - Reason for rejection of quotations and sales orders

Description: Reason for rejection of quotations and sales orders
Field Name: REASON_REJ
Data Element: ABGRU
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: ABGRU
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REASON_REJ

CRMST_QRESHIST_ERPIL-B_UOM_ISO table field - Base unit of measure in ISO code

Description: Base unit of measure in ISO code
Field Name: B_UOM_ISO
Data Element: MEINS_ISO
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ISOCD_UNIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field B_UOM_ISO

CRMST_QRESHIST_ERPIL-CD_UNT_ISO table field - Condition unit of measure in UoM

Description: Condition unit of measure in UoM
Field Name: CD_UNT_ISO
Data Element: KVMEI_ISO
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ISOCD_UNIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CD_UNT_ISO

CRMST_QRESHIST_ERPIL-S_UNIT_ISO table field - Sales unit in ISO code

Description: Sales unit in ISO code
Field Name: S_UNIT_ISO
Data Element: VRKME_ISO
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ISOCD_UNIT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field S_UNIT_ISO

CRMST_QRESHIST_ERPIL-CURR_ISO table field - ISO code currency

Description: ISO code currency
Field Name: CURR_ISO
Data Element: WAERS_ISO
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: ISOCD
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURR_ISO

CRMST_QRESHIST_ERPIL-PURCH_NO_C table field - Customer Reference

Description: Customer Reference
Field Name: PURCH_NO_C
Data Element: BSTKD
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: BSTKD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PURCH_NO_C

CRMST_QRESHIST_ERPIL-EXCHG_RATE_V table field - Indirectly quoted exchange rate for pricing and statistics

Description: Indirectly quoted exchange rate for pricing and statistics
Field Name: EXCHG_RATE_V
Data Element: KURSK_V
Data Type: DEC
length (Dec): 9(5)
Check table:
Conversion Routine:
Domain Name: PKURS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXCHG_RATE_V

CRMST_QRESHIST_ERPIL-MAT_EXT table field - Long Material Number for MATERIAL Field

Description: Long Material Number for MATERIAL Field
Field Name: MAT_EXT
Data Element: MGV_MATERIAL_EXTERNAL
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine: MATNL
Domain Name: MATNR_EXT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: MATNL

See all SAP tables containing field MAT_EXT

CRMST_QRESHIST_ERPIL-MAT_GUID table field - External GUID for MATERIAL Field

Description: External GUID for MATERIAL Field
Field Name: MAT_GUID
Data Element: MGV_MATERIAL_GUID
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: MATNR_EGUID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAT_GUID

CRMST_QRESHIST_ERPIL-MAT_VERS table field - Version Number for MATERIAL Field

Description: Version Number for MATERIAL Field
Field Name: MAT_VERS
Data Element: MGV_MATERIAL_VERSION
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: MATNW
Domain Name: MATNR_VERS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: MATNW

See all SAP tables containing field MAT_VERS

CRMST_QRESHIST_ERPIL-CREATION_DATE table field - Date on which the record was created

Description: Date on which the record was created
Field Name: CREATION_DATE
Data Element: ERDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATION_DATE

CRMST_QRESHIST_ERPIL-CREATION_TIME table field - Entry time

Description: Entry time
Field Name: CREATION_TIME
Data Element: ERZET
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATION_TIME

CRMST_QRESHIST_ERPIL-MATNR_LONG table field - Material No.

Description: Material No.
Field Name: MATNR_LONG
Data Element: MATNR40
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine: MATN1
Domain Name: MATNR40
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: MATN1

See all SAP tables containing field MATNR_LONG


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table