P_ACMOpenContrQtyTotOnPrcLot

Open Contract Quantity on Price Lots | view: PTQTYASPRCLOT | 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, /ACCGO/T_PR_ASP, MARA, T001K, MARM, MARA, MARA, /ACCGO/T_CAKSTAT, /ACCGO/T_CPE_BRI, /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
📏 Base Unit of Measure (MaterialBaseUnit):
TradingContractItemQuantity null
TradingContrItemQtyInBaseUnit null
TotalContractTradeQuantity null
TotalContrTradeQtyInBaseUnit null
Column Name Description
DocumentDate Date on which the record was created
Column Name Description
Column Name Description Domain name
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
RelatedDocumentNumber Causing Document of Trading Contract Item CHAR18
RelatedDocumentItemNumber Causing Item of Trading Contract Item CHAR10
ContractIsMirrorContr null
client Client MANDT
QuantityConvToBaseNumerator Numerator for Conversion to Base Units of Measure UMBSZ
QuantityConvToBaseDenominator Denominator for conversion to base units of measure UMBSN
Master Data Relations Join Conditions
Commodity
  • Client
  • Commodity
Company Code
  • Company Code
  • Client
  • P_ACMOPENCONTRQTYTOTONPRCLOT.COMPANYCODE == T001.BUKRS
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == T001.MANDT
Check Material
  • Client
  • Material Number
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == MARA.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.CONTRACTMATERIAL == MARA.MATNR
Check Plant
  • Client
  • Plant
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == T001W.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.CONTRACTPLANT == T001W.WERKS
Check Customer Number
  • Sold-to Party
  • Client
  • P_ACMOPENCONTRQTYTOTONPRCLOT.CUSTOMERNAME == KNA1.KUNNR
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == KNA1.MANDT
Check Distribution Channel
  • Client
  • Distribution Channel
  • Sales Organization
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == TVKOV.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_ACMOPENCONTRQTYTOTONPRCLOT.SALESORGANIZATION == TVKOV.VKORG
Check Division
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == TVTA.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.DIVISION == TVTA.SPART
  • P_ACMOPENCONTRQTYTOTONPRCLOT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_ACMOPENCONTRQTYTOTONPRCLOT.SALESORGANIZATION == TVTA.VKORG
Unit of Measure
  • Client
  • Base Unit of Measure
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == T006.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MATERIALBASEUNIT == T006.MSEHI
Check Purchasing Group
  • Client
  • Purchasing Group
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == T024.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == T024E.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == TVKO.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.SALESORGANIZATION == TVKO.VKORG
Check Storage Location
  • Storage location
  • Client
  • Plant
  • P_ACMOPENCONTRQTYTOTONPRCLOT.STORAGELOCATION == T001L.LGORT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == T001L.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.CONTRACTPLANT == T001L.WERKS
Check Vendor
  • Client
  • Vendor's account number
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == LFA1.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.SUPPLIERNAME == LFA1.LIFNR
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACMOPENCONTRQTYTOTONPRCLOT.MANDT == TB2BE.MANDT
  • P_ACMOPENCONTRQTYTOTONPRCLOT.TRADINGCONTRACTTYPE == TB2BE.TCTYP