SAP /SCMTMS/S_CLC_QUERY table - CLC:Query structure details in SAP

  


SAP /SCMTMS/S_CLC_QUERY table summary

Object Name: /SCMTMS/S_CLC_QUERY
Dictionary Type: Structure
Description: CLC:Query structure


Field list for /SCMTMS/S_CLC_QUERY table on an S/4 SAP system

Details
/SCMTMS/S_CLC_QUERY-SEGMENT_ID table field - Credit Segment ▼

Description: Credit Segment
Field Name: SEGMENT_ID
Data Element: /SCMTMS/CLC_SEGMENT_ID
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/CLC_SEGMENT_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEGMENT_ID

/SCMTMS/S_CLC_QUERY-AMOUNT table field - Amount ▼

Description: Amount
Field Name: AMOUNT
Data Element: /SCMTMS/AMOUNT
Data Type: CURR
length (Dec): 28(6)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AMOUNT

/SCMTMS/S_CLC_QUERY-CURRENCY table field - Credit Limit Check Currency ▼

Description: Credit Limit Check Currency
Field Name: CURRENCY
Data Element: /SCMTMS/CLC_CURRENCY
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY

/SCMTMS/S_CLC_QUERY-TRQ_ID table field - ID of Forwarding Order/Quotation or Trsp. Reqt ▼

Description: ID of Forwarding Order/Quotation or Trsp. Reqt
Field Name: TRQ_ID
Data Element: /SCMTMS/TRQ_ID
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/TRQ_ID
MemoryID:
AppClass:
SHLP: /SCMTMS/SH_TRQ_ID
SHLP Field: TRQ_ID
ConvExit: ALPHA

See all SAP tables containing field TRQ_ID

/SCMTMS/S_CLC_QUERY-TRQ_ITEM table field - ▼

Description:
Field Name: TRQ_ITEM
Data Element: /SCMTMS/S_CLC_QUERY_ORDERITEMS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRQ_ITEM

/SCMTMS/S_CLC_QUERY-ITEM_ID table field - Item ▼

Description: Item
Field Name: ITEM_ID
Data Element: /SCMTMS/ITEM_ID
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: /SCMTMS/ITEM_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ITEM_ID

/SCMTMS/S_CLC_QUERY-BP table field - ▼

Description:
Field Name: BP
Data Element: /BOFU/S_BUPA_ROOT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BP

/SCMTMS/S_CLC_QUERY-PARTNER table field - Business Partner Number ▼

Description: Business Partner Number
Field Name: PARTNER
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field PARTNER

/SCMTMS/S_CLC_QUERY-PARTNER_GUID table field - Business Partner GUID ▼

Description: Business Partner GUID
Field Name: PARTNER_GUID
Data Element: BU_PARTNER_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 PARTNER_GUID

/SCMTMS/S_CLC_QUERY-TYPE table field - Business Partner Category ▼

Description: Business Partner Category
Field Name: TYPE
Data Element: BU_TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BU_TYPE
MemoryID: BPY
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

/SCMTMS/S_CLC_QUERY-DESCRIPTION table field - Short name of business partner ▼

Description: Short name of business partner
Field Name: DESCRIPTION
Data Element: BU_DESCRIP
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: BU_TEXT50
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCRIPTION

/SCMTMS/S_CLC_QUERY-LIFE_CYCLE_STATUS_CODE table field - Business Partner Life Cycle Status Code ▼

Description: Business Partner Life Cycle Status Code
Field Name: LIFE_CYCLE_STATUS_CODE
Data Element: /BOFU/BUPA_LC_STATUS_CD
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /BOFU/BUPA_LC_STATUS_CD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIFE_CYCLE_STATUS_CODE

/SCMTMS/S_CLC_QUERY-BO_KEY table field - Business Object ▼

Description: Business Object
Field Name: BO_KEY
Data Element: /BOBF/OBM_BO_KEY
Data Type: RAW
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: /BOBF/CONF_KEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BO_KEY

/SCMTMS/S_CLC_QUERY-BP table field - ▼

Description:
Field Name: BP
Data Element: /BOFU/S_BUPA_ROOT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BP

/SCMTMS/S_CLC_QUERY-PARTNER table field - Business Partner Number ▼

Description: Business Partner Number
Field Name: PARTNER
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field PARTNER

/SCMTMS/S_CLC_QUERY-PARTNER_GUID table field - Business Partner GUID ▼

Description: Business Partner GUID
Field Name: PARTNER_GUID
Data Element: BU_PARTNER_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 PARTNER_GUID

/SCMTMS/S_CLC_QUERY-TYPE table field - Business Partner Category ▼

Description: Business Partner Category
Field Name: TYPE
Data Element: BU_TYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: BU_TYPE
MemoryID: BPY
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

/SCMTMS/S_CLC_QUERY-DESCRIPTION table field - Short name of business partner ▼

Description: Short name of business partner
Field Name: DESCRIPTION
Data Element: BU_DESCRIP
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: BU_TEXT50
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DESCRIPTION

/SCMTMS/S_CLC_QUERY-LIFE_CYCLE_STATUS_CODE table field - Business Partner Life Cycle Status Code ▼

Description: Business Partner Life Cycle Status Code
Field Name: LIFE_CYCLE_STATUS_CODE
Data Element: /BOFU/BUPA_LC_STATUS_CD
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: /BOFU/BUPA_LC_STATUS_CD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LIFE_CYCLE_STATUS_CODE

/SCMTMS/S_CLC_QUERY-SALES_ORG table field - ▼

Description:
Field Name: SALES_ORG
Data Element: /SCMTMS/S_ORG_UNIT_SALES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_ORG

/SCMTMS/S_CLC_QUERY-SALES_ORG_ID table field - Sales Organization ▼

Description: Sales Organization
Field Name: SALES_ORG_ID
Data Element: /SCMTMS/SALES_ORG_ID
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: HROBJID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_ORG_ID

/SCMTMS/S_CLC_QUERY-SALES_OFF_ID table field - Sales Office ▼

Description: Sales Office
Field Name: SALES_OFF_ID
Data Element: /SCMTMS/SALES_OFF_ID
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: HROBJID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_OFF_ID

/SCMTMS/S_CLC_QUERY-SALES_GROUP_ID table field - Sales Group ▼

Description: Sales Group
Field Name: SALES_GROUP_ID
Data Element: /SCMTMS/SALES_GRP_ID
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: HROBJID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SALES_GROUP_ID

/SCMTMS/S_CLC_QUERY-VALUATION_DATE table field - Field of type DATS ▼

Description: Field of type DATS
Field Name: VALUATION_DATE
Data Element: DATS
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALUATION_DATE

/SCMTMS/S_CLC_QUERY-LOGSYS table field - Logical System (Sending System) ▼

Description: Logical System (Sending System)
Field Name: LOGSYS
Data Element: /SCMTMS/LOGSYS_SENDING
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: LOGSYS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field LOGSYS

/SCMTMS/S_CLC_QUERY-OLD_AMOUNT table field - Amount ▼

Description: Amount
Field Name: OLD_AMOUNT
Data Element: /SCMTMS/AMOUNT
Data Type: CURR
length (Dec): 28(6)
Check table:
Conversion Routine:
Domain Name: /SCMTMS/AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OLD_AMOUNT

/SCMTMS/S_CLC_QUERY-OLD_CURRENCY table field - Credit Limit Check Currency ▼

Description: Credit Limit Check Currency
Field Name: OLD_CURRENCY
Data Element: /SCMTMS/CLC_CURRENCY
Data Type: CUKY
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OLD_CURRENCY


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table