SAP CRMST_QUERY_RESULT_ERPIL table - CRMST_QUERY_RESULT_ERPIL details in SAP


SAP CRMST_QUERY_RESULT_ERPIL table summary

Object Name: CRMST_QUERY_RESULT_ERPIL
Dictionary Type: Structure
Description: CRMST_QUERY_RESULT_ERPIL


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

Details
CRMST_QUERY_RESULT_ERPIL-VBELN table field - Sales and Distribution Document Number

Description: Sales and Distribution Document Number
Field Name: VBELN
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 VBELN

CRMST_QUERY_RESULT_ERPIL-TRVOG table field - Transaction Group

Description: Transaction Group
Field Name: TRVOG
Data Element: TRVOG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: TRVOG
MemoryID: VTV
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRVOG

CRMST_QUERY_RESULT_ERPIL-AUART table field - Sales Document Type

Description: Sales Document Type
Field Name: AUART
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 AUART

CRMST_QUERY_RESULT_ERPIL-AUARTT table field - Description

Description: Description
Field Name: AUARTT
Data Element: BEZEI20
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 AUARTT

CRMST_QUERY_RESULT_ERPIL-KUNNR table field - Sold-to Party

Description: Sold-to Party
Field Name: KUNNR
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 KUNNR

CRMST_QUERY_RESULT_ERPIL-ERDAT table field - Date on which the record was created

Description: Date on which the record was created
Field Name: ERDAT
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 ERDAT

CRMST_QUERY_RESULT_ERPIL-AUDAT table field - Document Date (Date Received/Sent)

Description: Document Date (Date Received/Sent)
Field Name: AUDAT
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 AUDAT

CRMST_QUERY_RESULT_ERPIL-BSTKD table field - Customer Reference

Description: Customer Reference
Field Name: BSTKD
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 BSTKD

CRMST_QUERY_RESULT_ERPIL-ZPAVW table field - Partner Function

Description: Partner Function
Field Name: ZPAVW
Data Element: PARVW
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine: PARVW
Domain Name: PARVW
MemoryID: PAR
AppClass: VP
SHLP:
SHLP Field:
ConvExit: PARVW

See all SAP tables containing field ZPAVW

CRMST_QUERY_RESULT_ERPIL-ZPERS table field - Person responsible

Description: Person responsible
Field Name: ZPERS
Data Element: DZPERS
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: PERNR
MemoryID:
AppClass: PB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ZPERS

CRMST_QUERY_RESULT_ERPIL-ERNAM table field - Name of Person Responsible for Creating the Object

Description: Name of Person Responsible for Creating the Object
Field Name: ERNAM
Data Element: ERNAM
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: USNAM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERNAM

CRMST_QUERY_RESULT_ERPIL-VKORG table field - Sales Organization

Description: Sales Organization
Field Name: VKORG
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 VKORG

CRMST_QUERY_RESULT_ERPIL-VTWEG table field - Distribution Channel

Description: Distribution Channel
Field Name: VTWEG
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 VTWEG

CRMST_QUERY_RESULT_ERPIL-SPART table field - Division

Description: Division
Field Name: SPART
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 SPART

CRMST_QUERY_RESULT_ERPIL-VKBUR table field - Sales office

Description: Sales office
Field Name: VKBUR
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 VKBUR

CRMST_QUERY_RESULT_ERPIL-VKGRP table field - Sales group

Description: Sales group
Field Name: VKGRP
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 VKGRP

CRMST_QUERY_RESULT_ERPIL-WAERK table field - SD Document Currency

Description: SD Document Currency
Field Name: WAERK
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 WAERK

CRMST_QUERY_RESULT_ERPIL-NETWR table field - Net Value of the Sales Order in Document Currency

Description: Net Value of the Sales Order in Document Currency
Field Name: NETWR
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 NETWR

CRMST_QUERY_RESULT_ERPIL-AWAHR table field - Sales probability

Description: Sales probability
Field Name: AWAHR
Data Element: AWAHR_AK
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: AWAHR
MemoryID:
AppClass: VA
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AWAHR

CRMST_QUERY_RESULT_ERPIL-DATAB table field - Quotation or contract valid from

Description: Quotation or contract valid from
Field Name: DATAB
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 DATAB

CRMST_QUERY_RESULT_ERPIL-DATBI table field - Quotation or contract valid to

Description: Quotation or contract valid to
Field Name: DATBI
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 DATBI

CRMST_QUERY_RESULT_ERPIL-NAME_ZPERS table field - Name 1 of a partner

Description: Name 1 of a partner
Field Name: NAME_ZPERS
Data Element: NAME1_VP
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_ZPERS

CRMST_QUERY_RESULT_ERPIL-KUNAG_T table field - Display text for partners (name, city, ctry/reg., street)

Description: Display text for partners (name, city, ctry/reg., street)
Field Name: KUNAG_T
Data Element: TXTPA
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: TXTPA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field KUNAG_T

CRMST_QUERY_RESULT_ERPIL-AUGRU table field - Order Reason (Reason for the Business Transaction)

Description: Order Reason (Reason for the Business Transaction)
Field Name: AUGRU
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 AUGRU

CRMST_QUERY_RESULT_ERPIL-PRSDT table field - Date for Pricing and Exchange Rate

Description: Date for Pricing and Exchange Rate
Field Name: PRSDT
Data Element: PRSDT
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 PRSDT

CRMST_QUERY_RESULT_ERPIL-INCO1 table field - Incoterms (Part 1)

Description: Incoterms (Part 1)
Field Name: INCO1
Data Element: INCO1
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INCO1
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INCO1

CRMST_QUERY_RESULT_ERPIL-INCO2 table field - Incoterms (Part 2)

Description: Incoterms (Part 2)
Field Name: INCO2
Data Element: INCO2
Data Type: CHAR
length (Dec): 28(0)
Check table:
Conversion Routine:
Domain Name: INCO2
MemoryID:
AppClass: V
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INCO2

CRMST_QUERY_RESULT_ERPIL-ERP_ORDER_SRCHRES_DUMMY table field - Dummy function in length 1

Description: Dummy function in length 1
Field Name: ERP_ORDER_SRCHRES_DUMMY
Data Element: DUMMY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DUMMY
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ERP_ORDER_SRCHRES_DUMMY

CRMST_QUERY_RESULT_ERPIL-KETDAT table field - Requested Delivery Date

Description: Requested Delivery Date
Field Name: KETDAT
Data Element: EDATU_VBAK
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 KETDAT


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table