P_ACMOpenContrFilterData

Filter Contract Data | view: PCTRFILTERDATA | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management
Tables used: /ACCGO/T_APPDATA, /ACCGO/T_CAS_CAH, /ACCGO/T_CAS_CAI, /ACCGO/T_WASH_I, JEST, WBHD, WBHI, WBHK, T001K, MARA, /ACCGO/T_CAKSTAT, /ACCGO/T_CAK_TYP
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
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
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
Master Data Relations Join Conditions
Commodity
  • Commodity
  • Client
Company Code
  • Company Code
  • Client
  • P_ACMOPENCONTRFILTERDATA.COMPANYCODE == T001.BUKRS
  • P_ACMOPENCONTRFILTERDATA.MANDT == T001.MANDT
Check Material
  • Material Number
  • Client
  • P_ACMOPENCONTRFILTERDATA.CONTRACTMATERIAL == MARA.MATNR
  • P_ACMOPENCONTRFILTERDATA.MANDT == MARA.MANDT
Check Plant
  • Plant
  • Client
  • P_ACMOPENCONTRFILTERDATA.CONTRACTPLANT == T001W.WERKS
  • P_ACMOPENCONTRFILTERDATA.MANDT == T001W.MANDT
Check Customer Number
  • Sold-to Party
  • Client
  • P_ACMOPENCONTRFILTERDATA.CUSTOMERNAME == KNA1.KUNNR
  • P_ACMOPENCONTRFILTERDATA.MANDT == KNA1.MANDT
Check Distribution Channel
  • Distribution Channel
  • Client
  • Sales Organization
  • P_ACMOPENCONTRFILTERDATA.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_ACMOPENCONTRFILTERDATA.MANDT == TVKOV.MANDT
  • P_ACMOPENCONTRFILTERDATA.SALESORGANIZATION == TVKOV.VKORG
Check Division
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • P_ACMOPENCONTRFILTERDATA.DIVISION == TVTA.SPART
  • P_ACMOPENCONTRFILTERDATA.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_ACMOPENCONTRFILTERDATA.MANDT == TVTA.MANDT
  • P_ACMOPENCONTRFILTERDATA.SALESORGANIZATION == TVTA.VKORG
Check Purchasing Group
  • Purchasing Group
  • Client
  • P_ACMOPENCONTRFILTERDATA.PURCHASINGGROUP == T024.EKGRP
  • P_ACMOPENCONTRFILTERDATA.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • P_ACMOPENCONTRFILTERDATA.PURCHASINGORGANIZATION == T024E.EKORG
  • P_ACMOPENCONTRFILTERDATA.MANDT == T024E.MANDT
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACMOPENCONTRFILTERDATA.MANDT == TVKO.MANDT
  • P_ACMOPENCONTRFILTERDATA.SALESORGANIZATION == TVKO.VKORG
Check Storage Location
  • Plant
  • Storage location
  • Client
  • P_ACMOPENCONTRFILTERDATA.CONTRACTPLANT == T001L.WERKS
  • P_ACMOPENCONTRFILTERDATA.STORAGELOCATION == T001L.LGORT
  • P_ACMOPENCONTRFILTERDATA.MANDT == T001L.MANDT
Check Vendor
  • Vendor's account number
  • Client
  • P_ACMOPENCONTRFILTERDATA.SUPPLIERNAME == LFA1.LIFNR
  • P_ACMOPENCONTRFILTERDATA.MANDT == LFA1.MANDT
Check Trading Contract Type
  • Trading Contract Type
  • Client
  • P_ACMOPENCONTRFILTERDATA.TRADINGCONTRACTTYPE == TB2BE.TCTYP
  • P_ACMOPENCONTRFILTERDATA.MANDT == TB2BE.MANDT