Life, SAP, Consulting, Programming, Coding, ASP.NET, Sharepoint, MVC, Javascript, PHP, WebDesign, CSS, HTML

Archive for the ‘SAP’ Category

Frequently use EPM Functions

Function Category

Description

DescriptionEVFunctions Deprecated)

Obsolete (supported as of BPC10 SP3)  EV functions

EPMFunctions

Delivered EPM functions

FPMXLClient.TechnicalCategory

System internal use

 

EPM Functions

Description

EPMSaveComment

Enables you to enter or modify a comment for a full set of members in a specified cell.

EPMDimensionOverride

Overrides the member selection for a specific report. You can calculate parameter and put in some cells. Use this function to dynamically display report by parameters.

EPMMemberID

Retrieves the unique name of a specified dimension member that is included in a report.

EPMUser

Retrieves the login for the specified connection.

EPMEnvDatabaseID

Retrieves the name of the environment or database for the specified connection.

EPMModelCubeID

Retrieves the name of the model or cube for the specified connection.

EPMAxisOverride

Overrides one or more dimensions (and their members) for a specified axis (row or column axis).

EPMCopyRange

Enables you to add and repeat the content of a range of cells until you reach the bottom (columns) or right side (rows) of a report.

EPMInsertCellsBeforeAfterBlock

Inserts cells before or after a block of members for a specified dimension.

EPMReportOptions

Overrides the options for one or more reports.

EPMDimensionProperty

Retrieves the properties of a specified dimension in a specified cell range.

=EPMMemberProperty(“OPEX”,$E$6,”TIMEID”)

This can be used to pass parameter in combination with EPMDimensionOverride

EPMMemberDesc

Retrieves the description of the specified dimension member.

EPMMemberOffset

Retrieves a member related to another member by specifying an offset from a given member to retrieve the previous or subsequent member.

EPMSelectMember

Retrieves a specified dimension member when you double-click the cell containing the function.

EPMScaleData

Retrieves data for a full set of members and scale the data.

EPMSaveData

Enables you to enter or modify a comment for a full set of members.

EPMWorkStatus

Retrieves information about the work status for a model and data intersection.

EPMComparison

Calculates variances with a sign dependent on the acctype property of the relevant account. For example, if the actual is above the plan value for a revenue account, the variance is positive.

EPMURL

Launches the specified web client component.

EPMBook

Retrieves a specified text. You can double-click to open a book published in the Planning and Consolidation web client.

EPMLink

Displays a specified text, which you can double-click to open a report contained in another file that is an Excel workbook, a Word document, or a PowerPoint presentation. When you double-click the link, the context is passed along.

EPMExecuteAPI

Enables you to execute the application programming interfaces (APIs) directly from a worksheet cell.

   
Advertisements

DMEE Aggregation field

How to create a aggregation field in DME file?

 
 

Follow the settings like below (Sample template: LUX_VIR2000)

 
 

Setup Sort fields: Sum by Vendor level + Value date in DME file.

 
 


 
 

 
 

1 segment contains lower level (2) data for aggregation field


 
 

Technical Field with Reference ID (N_P_VLUE)


 
 

 
 

Target field mapping is Aggregation, setup to N_PVLUE node.


 
 

Result (to test alternative payee with one payment in DME file):


 
 

Finally we have DME result:


 
 

Image

Yet another definition of SAP


Choosing between structured and unstructured mt940

Working with MT940, SAP (FF_5) support 3 option when uploading file.

  • G – MT940 automatic recognized
  • S – MT940 with filed 86 structured
  • I – MT940 with field 86 unstructured

So what is difference between structured and unstructured MT940?

 

Structured

Unstructured

Name

 

MT 940 Customer Statement Message

61/6

N or F + 3 SWIFT standard code

N or F + 3 SWIFT standard code

86

Field code Alphanumeric 4 :86: Batch ID Alphanumeric 35 /PREF/

End-to-End reference Alphanumeric 35 /EREF/

Counterparty Name Alphanumeric 70 /BENM//NAME/

Creditor ID Alphanumeric 70 /CSID/

End-to-End reference Alphanumeric 35 /EREF/

Settlement Date Alphanumeric 10 /ISDT/

Mandate Reference Alphanumeric 35 /MARF/

Counterparty Name Alphanumeric 70 /ORDP//NAME/

Counterparty Identification Alphanumeric /ORDP//ID/

Format Description SWIFT MT940 21

Remittance Information Alphanumeric 140 /REMI/

In case of unstructured remittance information, which don’t contain any subfields and in particular no slashes.

Creditor Reference Type Code Alphanumeric 4 /REMI//CD/

Remittance information. All available transaction descriptions

Pros

Structured information in field 86

All in one

Cons

Less space

More space => Longer notes

 

Looking at these format as SAP perspective, I would prefer structured format. With more details, I am easier to deal with complicated requirement from customer. I can combine with Search string to look up specific information, update posting rule, or make necessary replacement of data.

Comparing to Multicash format, I don’t see the same benefit. If I use Unstructured format, then there is not much benefit comparing to multicash format.

SAP DME file missing record

If you are working with SAP DMEE, for some payment run some instruction records are missing any you don’t know why.

You have 2 items in payment proposal with same information, bank, and payment method.

But only one record is sent out to bank.

 

If you encounter the same issue. Firstly you need to check the sorting/key field setting DMEE file.

Here is setting in my system

FPAYH-HKTID ==> ID for Account Details

FPAYHX-WAERS ==> ISO currency code

FPAYH-KOINH ==> Account Holder Name

FPAYHX-UBKNT ==> Our Account Number at the Bank

FPAYH-ZBNKN ==> Bank Account Number of the Payee

So if you pay to the same vendor in one payment run, the key field will be duplicate so it would be one record remained.

The fix for this? I don’t have access to test, however, it may be okay if you add sequential number of each item:

FPAYH-LFDNR Sequential Payment Number

If you have tested it, please let me know if comment section :-). Pls!

How to display vendor name on the header of FBL1N

The standard report vendor/customer open items in SAP support to display additional information.

By default, you can switch between ALV list and Basic list. ALV is more excel oriented, which you can easily extract and work within Excel. Basic list give some additional information, this layout is convenient for print out. Sometimes, instead of what you need, you see basic list just give asterisk symbols.

No vendor name

 

The secret setting is to change the sort field and control break (Don’t forget this *):

Change sort order

You can add more field for sorting, but remember to keep “Company code” and “Account” at highest level.

After click “Copy” button, you’ll get what you need. Of course, the same step can be applied for customer line item report.
Result

K_PCAR_REP Summary and line item reports

Thanks to the article on SCN, it saved my day!

This technique is to assign authorization for user at in Profit center accounting at company code level.

https://help.sap.com/saphelp_46c/helpdata/en/17/f12c7dd435d1118b3f0060b03ca329/content.htm

K_PCAR_REP Summary and line item reports

Definition

This authorization object lets you protect the following in Profit Center Accounting:

1. Company codes, profit centers and cost elements in the information system.
2. The functions for creating, changing and displaying profit centers
3. In actual postings, the functions for creating and displaying profit center documents and statistical key figures.

Defined Fields

The object contains the following fields:

  • Company code: Specifies which company codes the user can work with.
  • Profit center: Specifies which profit centers the user can work with. Here you enter the key for the profit center.
  • Cost element: Specifies which cost elements a user can work with. Here you enter the key for the cost element.
  • Activity: Specifies which functions the user is authorized to carry out.
  • Reporting summary records (activity = 27)
  • Reporting line items (activity = 28)
  • Display saved data (activity = 29)
  • Create document (activity = 76)
  • Display document (activity = 03)

In master data maintenance, only the fields “Profit center” and “Activity” (01 = Create, 02 = Change and 03 = Display) are checked.

Examples

User A has authorization to report on profit center 4711 in company code 0100, but only for monthly values, not line items. Authorizations:

  • Company code ‘0100’
  • Profit center ‘0000004711’
  • Cost element ‘*’
  • Activity ’27

User B has authorization to call up reports on all the profit centers for the cost elements in group 5 in company code 0400 (including line items):

  • Company code ‘0400’
  • Profit center ‘*’
  • Cost element ‘00005*’
  • Activity ‘27,28’

User C can report on all profit centers and cost elements in company code TEST:

  • Company code ‘TEST’
  • Profit center ‘*’
  • Cost element ‘*’
  • Activity ‘*’

User D has authorization to call up reports for all previously selected and saved data on profit centers and cost elements in company code 0500:

  • Company code ‘0500’
  • Profit center ‘0000004711’
  • Cost element ‘*’
  • Activity ’29’