P_ACMOpenContrPrepareData

Prepare Open Contract Quantity Data | view: POPENCTRPREPD | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management
Column Name Description
ContractNum FK Trading Contract
TradingContractItem Item Number of Trading Contract
ContractSubItem Sub-Item Number of Trading Contract
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (TrdgContractItemUnitOfMeasure):
TradingContractItemQuantity Cumulative Order Quantity in Sales Units
Column Name Description
DocumentDate Date on which the record was created
FromDateForFilterInUserTZ null
FromTimeForFilterInUserTZ null
ToDateForFilterInUserTZ null
ToTimeForFilterInUserTZ null
FromDateInSystemTimeZone null
FromTimeInSystemTimeZone null
ToDateInSystemTimeZone null
ToTimeInSystemTimeZone null
TradingContrCreatedOnDate Date on which the record was created
TradingContrCreatedOnTime Time at Which Record Was Added
TradingContrChangedOnDate Last Changed On
TradingContrChangedOnTime Time of Change
Column Name Description
Column Name Description Domain name
RelatedDocumentNumber Causing Document of Trading Contract Item CHAR18
RelatedDocumentItemNumber Causing Item of Trading Contract Item CHAR10
DocumentSide null
TradingContrCreatedOnDateTime Trading Contract Creation Timestamp TZNTSTMPS
TradingContrChangedOnDateTime Trading Contract Change Timestamp TZNTSTMPS
TradingContractCreatedBy Name of Person Responsible for Creating the Object USNAM
PricingDocument Number of the Document Condition KNUMV
PricingProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
ApplItemCreatedOnDateTime null
ApplItemChangedOnDateTime null
FromDateTimeInUTC null
ToDateTimeInUTC null
Master Data Relations Join Conditions
Commodity
  • Client
  • Commodity
Company Code
  • Client
  • Company Code
  • P_ACMOPENCONTRPREPAREDATA.MANDT == T001.MANDT
  • P_ACMOPENCONTRPREPAREDATA.COMPANYCODE == T001.BUKRS
Check Material
  • Client
  • Material Number
  • P_ACMOPENCONTRPREPAREDATA.MANDT == MARA.MANDT
  • P_ACMOPENCONTRPREPAREDATA.CONTRACTMATERIAL == MARA.MATNR
Check Plant
  • Client
  • Plant
  • P_ACMOPENCONTRPREPAREDATA.MANDT == T001W.MANDT
  • P_ACMOPENCONTRPREPAREDATA.CONTRACTPLANT == T001W.WERKS
Check Customer Number
  • Client
  • Sold-to Party
  • P_ACMOPENCONTRPREPAREDATA.MANDT == KNA1.MANDT
  • P_ACMOPENCONTRPREPAREDATA.CUSTOMERNAME == KNA1.KUNNR
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • P_ACMOPENCONTRPREPAREDATA.MANDT == TVKOV.MANDT
  • P_ACMOPENCONTRPREPAREDATA.SALESORGANIZATION == TVKOV.VKORG
  • P_ACMOPENCONTRPREPAREDATA.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Check Division
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • P_ACMOPENCONTRPREPAREDATA.MANDT == TVTA.MANDT
  • P_ACMOPENCONTRPREPAREDATA.DIVISION == TVTA.SPART
  • P_ACMOPENCONTRPREPAREDATA.SALESORGANIZATION == TVTA.VKORG
  • P_ACMOPENCONTRPREPAREDATA.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Check Purchasing Group
  • Client
  • Purchasing Group
  • P_ACMOPENCONTRPREPAREDATA.MANDT == T024.MANDT
  • P_ACMOPENCONTRPREPAREDATA.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • P_ACMOPENCONTRPREPAREDATA.MANDT == T024E.MANDT
  • P_ACMOPENCONTRPREPAREDATA.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACMOPENCONTRPREPAREDATA.MANDT == TVKO.MANDT
  • P_ACMOPENCONTRPREPAREDATA.SALESORGANIZATION == TVKO.VKORG
Check Storage Location
  • Client
  • Storage location
  • Plant
  • P_ACMOPENCONTRPREPAREDATA.MANDT == T001L.MANDT
  • P_ACMOPENCONTRPREPAREDATA.STORAGELOCATION == T001L.LGORT
  • P_ACMOPENCONTRPREPAREDATA.CONTRACTPLANT == T001L.WERKS
Check Vendor
  • Vendor's account number
  • Client
  • P_ACMOPENCONTRPREPAREDATA.SUPPLIERNAME == LFA1.LIFNR
  • P_ACMOPENCONTRPREPAREDATA.MANDT == LFA1.MANDT
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACMOPENCONTRPREPAREDATA.MANDT == TB2BE.MANDT
  • P_ACMOPENCONTRPREPAREDATA.TRADINGCONTRACTTYPE == TB2BE.TCTYP