P_ACMOpenContrConvToBaseUnit

Conversionn to Base Unit | view: PCTRPRCASPQC | 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
ACMPrcgCndnFlatPrice Total Amount /ACCGO/CPE_D_TOTAL_PRICE
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_ACMOPENCONTRCONVTOBASEUNIT.COMPANYCODE == T001.BUKRS
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == T001.MANDT
Check Material
  • Client
  • Material Number
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == MARA.MANDT
  • P_ACMOPENCONTRCONVTOBASEUNIT.CONTRACTMATERIAL == MARA.MATNR
Check Plant
  • Plant
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.CONTRACTPLANT == T001W.WERKS
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == T001W.MANDT
Check Customer Number
  • Sold-to Party
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.CUSTOMERNAME == KNA1.KUNNR
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == KNA1.MANDT
Check Distribution Channel
  • Sales Organization
  • Distribution Channel
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.SALESORGANIZATION == TVKOV.VKORG
  • P_ACMOPENCONTRCONVTOBASEUNIT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == TVKOV.MANDT
Check Division
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.DIVISION == TVTA.SPART
  • P_ACMOPENCONTRCONVTOBASEUNIT.SALESORGANIZATION == TVTA.VKORG
  • P_ACMOPENCONTRCONVTOBASEUNIT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == TVTA.MANDT
Unit of Measure
  • Base Unit of Measure
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.MATERIALBASEUNIT == T006.MSEHI
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == T006.MANDT
Check Purchasing Group
  • Purchasing Group
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.PURCHASINGGROUP == T024.EKGRP
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == T024.MANDT
Check Purchasing Organization
  • Purchasing organization
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == T024E.MANDT
Check Sales Organization
  • Sales Organization
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.SALESORGANIZATION == TVKO.VKORG
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == TVKO.MANDT
Check Storage Location
  • Storage location
  • Plant
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.STORAGELOCATION == T001L.LGORT
  • P_ACMOPENCONTRCONVTOBASEUNIT.CONTRACTPLANT == T001L.WERKS
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == T001L.MANDT
Check Vendor
  • Vendor's account number
  • Client
  • P_ACMOPENCONTRCONVTOBASEUNIT.SUPPLIERNAME == LFA1.LIFNR
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == LFA1.MANDT
Check Trading Contract Type
  • Client
  • Trading Contract Type
  • P_ACMOPENCONTRCONVTOBASEUNIT.MANDT == TB2BE.MANDT
  • P_ACMOPENCONTRCONVTOBASEUNIT.TRADINGCONTRACTTYPE == TB2BE.TCTYP