Using with SAP PCM

Home/Using with SAP PCM

Using with SAP PCM

If you already have a SAP PCM client installed on the server or PC with which you are using Excel, the PCM ribbon will automatically appear, allowing you to connect to PCM models.

Note: You will not see the SAP PCM ribbon if you do not have the PCM client installed on your PC.

In order to ensure model access and rights are consistent across all PCM usage scenarios, PlaidXL leverages the same PCM security model that is used by all aspects of PCM.

This is a list of all the Model Builder functions divided into two types: Retrieve and WriteBack. Retrieve functions are updated by the Retrieving data ribbon options. WriteBack functions are updated by the Saving data ribbon options. Notice each Retrieve function has a hashtag code, and the WriteBack has only the #WB. The hashtag code is used when no value has been retrieved from PCM.

Retrieve Functions WriteBack Functions
ActivityDriverValue (#ADV)
ActivityCostObjectValue (#ACOV)
ActivityDriverDataValue (#ADDV)
ActivityLineItemValue (#ALIV)
ActivityValue (#AV)
CostObjectValue (#COV)
DataRevenue (#DR)
DataUnitPrice (#DUP)
DataUnitsSold (#DUS)
DirectCostObjectValue (#DCOV)
ExternalActivityValue (#EAV)
ExternalCostObjectValue (#ECOV)
LineItemValue (#LIV)
LineItemCostObjectValue (#LICOV)
LineItemDataValue (#LIDV)
LineItemDetailDataValue (#LIDDV)
LineItemDetailValue (#LIDV)
ResourceDriverDataValue (#RDDV)
ResourceDriverDataSplit (#RDDS)
ResourceDriverPctSplit (#RDPS)
ResourceDriverSplit (#RDS)
ResourceDriverValue (#RDV)
Revenue (#REV)
SetPCMModelNameSpreadDataValue (#SDV)
SummaryActivityValue (#SAV)
SummaryCostObjectValue (#SCOV)
TargetCostObjectValue (#TCOV)
UnitPrice (#UP)
UnitsSold (#US)
WorksheetDataValue (#WDV)
WorksheetValue (#WV)
LineItemValue (#LIV)
LineItemDetailValue (#LIDV)
ResourceDriverValue (#RDV)
ResourceDriverSplit (#RDS)
ActivityDriverValue (#ADV)
ExternalActivityValue (#EAV)
ExternalCostObjectValue (#ECOV)
Revenue (#REV)
PropertyValue (#PV)
Memo(#MEM)

Reassignment Value Functions Model Information Functions
ReassignSplitValue (#RSV)
ReassignSplitPostValue (#RSPV)
ReassignSplitInValue (#RSIV)
ReassignSplitOutValue (#RSOV)
ReassignActivityLineItemValue (#RALIV)
SourceActivityLineItemValue (#SALIV)
SourceActivityLineItemFixedValue (#SALIFV)
SourceActivityLineItemVariableValue (#SALIVV)
ReassignedInValue (#RIV)
ReassignedOutValue (#ROV)
ReassignedFinalValue (#RFV)
ReassignedMoveValue (#RMV)
PostReassignLineItemValue (#PRLIV)
PostReassignLineItemFixedValue (#PRLIFV)
PostReassignLineItemVariableValue (#PRLIVV)
GetAlias
GetPCMModelName
GetRetrieveTime
GetParent
GetParentBelowParent
GetMemo
GetProperty
GetParentBelowGroup

Go to Top