/ACCGO/T_SPOTDTL

Spot/Accumulate & Own Contract requests details | #transactional | Component: SAP Agricultural Contract Management
Column Name Description
MANDT Client
SPOT_ID Spot Unique Identifier
Column Name Description
Column Name Description
Column Name Description
DELIVERY_DATE Delivery Date
Column Name Description
APPL_STATUS Application Status Show values
SPOT_SCENARIO Spot Scenario Show values
READY_TO_PRICE Ready to Price Show values
PRICED Accumulate & Own Contract Priced Status Show values
READY_TO_PR_APPR Ready to Price Approval Show values
PRICE_STATUS Spot Price Type Show values
MSG_STATUS Inventory DB CSL Indicator Show values
HEDGABLE Hedgings Show values
PRICE_TYPE Price Type Show values
Column Name Description Domain name
TPOSN Item Number of Trading Contract TPOSN
TPOSN_SUB Sub-Item Number of Trading Contract TPOSN
QUANTITY Applied Quantity WLF_QUANTITY
TSW_LOC TSW Location OIJ_LOCID
DPQS_ID Value Schedule ID /ACCGO/D_SCHEDULE_ID
MOT LDC Mode of Transport (MoT) VKTRA
MEANS_OF_TRANS Means of Transport ID TRAID
MSG_GUID Message GUID SYSUUID_X16
CON_MATERIAL Contract Material MATNR
CREATED_ON Created On /ACCGO/D_TZNTSTMPS
CHANGED_ON Changed On /ACCGO/D_TZNTSTMPS
TEMPLATE Template TKONN
ITEM Item Number of Trading Contract TPOSN
TCP_PARTNER Transacting counter party BU_PARTNER
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • /ACCGO/T_SPOTDTL.MATERIAL == MARA.MATNR
  • /ACCGO/T_SPOTDTL.MANDT == MARA.MANDT
Plant
  • /ACCGO/T_SPOTDTL.MANDT == T001W.MANDT
  • /ACCGO/T_SPOTDTL.PLANT == T001W.WERKS
Account Number of Supplier
  • /ACCGO/T_SPOTDTL.MANDT == LFA1.MANDT
  • /ACCGO/T_SPOTDTL.VENDOR == LFA1.LIFNR