/SCMTMS/C_SCAITM

Scale Item | #masterdata | Component: Charge Management
Column Name Description
CLIENT Client
SCAID FK Scale Template
SCAITM Scale Item
Column Name Description
💲 Currency (CURRENCY):
QTY_VALUE_CUR Amount
Column Name Description
📏 Unit of Measure (UOM):
QTY_VALUE_NUM Quantity
SCAVAL_UNIT Scale Value: Number of Units
Column Name Description
SCAVAL_DATE Date
Column Name Description
SCAVAL_INDICATOR Indicator Show values
SCAVAL_ITEM_CAT Item Category Show values
SCAVAL_OWNERSHIP_TYPE Ownership Type Show values
SCAVAL_PAYER Payer Show values
SCAVAL_WEEKDAY Weekday Show values
Column Name Description Domain name
SCAVAL_AIR_CODE IATA Airline Code /SCMTMS/AIRLC
SCAVAL_CITY City TEXT40
SCAVAL_RESTYPE Equipment Type
SCAVAL_FLIGHTCODE Airline Code and Flight Number /SCMTMS/FLIGHT_CODE
SCAVAL_CHAR Freight Term
SCAVAL_NOTE TACT Note /SCMTMS/TACT_NOTE
SCAVAL_SHFSHT General Note
SCAVAL_ORG Organizational Unit /SCMTMS/ORG_EXT_ID
SCAVAL_PSTL_CD City postal code CHAR10
SCAVAL_PRODUCTID Product MATNR
SCAVAL_DATE_TS Date stored in timestamp TZNTSTMPS
SCAVAL_LOCID_EXT Internal Location
SCAVAL_TRNS_ZN_EXT Transportation Zone
Master Data Relations Join Conditions
Currency
  • /SCMTMS/C_SCAITM.CLIENT == TCURC.MANDT
  • /SCMTMS/C_SCAITM.CURRENCY == TCURC.WAERS
Scale Template
  • Scale Template
  • Client
Charge Type
International Air Transport Association: City
Commodity Code
  • ?
  • Commodity Code
  • Client
Air Waybill Type
  • Air Waybill Type
  • Client
Country/Region
  • Country/Region
  • Client
  • /SCMTMS/C_SCAITM.SCAVAL_COUNTRY == T005.LAND1
  • /SCMTMS/C_SCAITM.CLIENT == T005.MANDT
Equipment Group
Handling Code
International Air Transport Association: Location
Incoterm
  • Incoterm
  • Client
  • /SCMTMS/C_SCAITM.SCAVAL_INCOTERM == TINC.INCO1
  • /SCMTMS/C_SCAITM.CLIENT == TINC.MANDT
United Nations Code for Trade and Transport Locations
  • United Nations Code for Trade and Transport Locations
  • Client
Transportation Mode Code
  • /SCMTMS/C_SCAITM.CLIENT == TVTR.MANDT
  • /SCMTMS/C_SCAITM.SCAVAL_MODETR == TVTR.VKTRA
Means of Transport /SCMTMS/C_SCAITM.CLIENT == /SAPAPO/TRTYPE.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • /SCMTMS/C_SCAITM.SCAVAL_PARTNER_EXT == BUT000.PARTNER
  • /SCMTMS/C_SCAITM.CLIENT == BUT000.CLIENT
Packaging Material Type
  • /SCMTMS/C_SCAITM.CLIENT == TVTY.MANDT
  • /SCMTMS/C_SCAITM.SCAVAL_PKGTYP == TVTY.TRATY
Charge-Relevant Product Freight Group
  • Charge-Relevant Product Freight Group
  • Client
  • /SCMTMS/C_SCAITM.SCAVAL_PRDFRTCD == TMFG.MFRGR
  • /SCMTMS/C_SCAITM.CLIENT == TMFG.MANDT
Transportation Group
  • /SCMTMS/C_SCAITM.CLIENT == TTGR.MANDT
  • /SCMTMS/C_SCAITM.SCAVAL_PRDTRNGRP == TTGR.TRAGR
Region (State, Province, or County)
  • Country/Region
  • Region (State, Province, or County)
  • /SCMTMS/C_SCAITM.CLIENT == T005S.MANDT
  • /SCMTMS/C_SCAITM.SCAVAL_COUNTRY == T005S.LAND1
  • /SCMTMS/C_SCAITM.SCAVAL_REGIO == T005S.BLAND
Service Type
Stage Type
Rate Type for Unit Load Device
  • Rate Type for Unit Load Device
  • Client
Unit of Measure
  • /SCMTMS/C_SCAITM.CLIENT == T006.MANDT
  • /SCMTMS/C_SCAITM.UOM == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Name of Condition
  • Name of Condition
  • Client
  • ?