P_ACMOpenContrPrcLotWthNtRsrvd

Open Contracts: Pricing lots with un reserved lot | view: POPENCTRPRASPWNR | 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
ACMPricingAspect Pricing Aspect
ACMPricingAspectValue Pricing Aspect Counter
Column Name Description
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
TradingContractItemQuantity null
TradingContrItemQtyInBaseUnit null
ContractTradeQuantity null
ContractTradeQtyInBaseUnit 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
TrdgContrPrcgAspectSrceLotID Source Lot ID /ACCGO/D_PRICINGLOT_ID
PricingConditionTerm CPE Term - Number in Formula NUMC5
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
  • Commodity
  • Client
Company Code
  • Company Code
  • Client
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.COMPANYCODE == T001.BUKRS
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == T001.MANDT
Check Material
  • Client
  • Material Number
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == MARA.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.CONTRACTMATERIAL == MARA.MATNR
Check Plant
  • Client
  • Plant
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == T001W.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.CONTRACTPLANT == T001W.WERKS
Check Customer Number
  • Sold-to Party
  • Client
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.CUSTOMERNAME == KNA1.KUNNR
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == KNA1.MANDT
Check Distribution Channel
  • Client
  • Sales Organization
  • Distribution Channel
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == TVKOV.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.SALESORGANIZATION == TVKOV.VKORG
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Check Division
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.DIVISION == TVTA.SPART
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == TVTA.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.SALESORGANIZATION == TVTA.VKORG
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Unit of Measure
  • Base Unit of Measure
  • Client
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MATERIALBASEUNIT == T006.MSEHI
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == T006.MANDT
Check Purchasing Group
  • Client
  • Purchasing Group
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == T024.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.PURCHASINGGROUP == T024.EKGRP
Check Purchasing Organization
  • Client
  • Purchasing organization
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == T024E.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.PURCHASINGORGANIZATION == T024E.EKORG
Check Sales Organization
  • Client
  • Sales Organization
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == TVKO.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.SALESORGANIZATION == TVKO.VKORG
Check Storage Location
  • Storage location
  • Client
  • Plant
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.STORAGELOCATION == T001L.LGORT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == T001L.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.CONTRACTPLANT == T001L.WERKS
Check Vendor
  • Vendor's account number
  • Client
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.SUPPLIERNAME == LFA1.LIFNR
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == LFA1.MANDT
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.MANDT == TB2BE.MANDT
  • P_ACMOPENCONTRPRCLOTWTHNTRSRVD.TRADINGCONTRACTTYPE == TB2BE.TCTYP