Scribd
Upload
8 views14 pages

ACDOCA+ +Session+Notes

The document outlines a hands-on session for SAC and ACDOCA data flow for CO, scheduled for January 10th. It details the ACDOCA-based CDS view data flow, including various setups for obtaining CO documents, AR/AP, material postings, and asset postings. Additionally, it provides technical changes in S4HANA for controlling and includes code blocks for ACDOCA CO flow.

Uploaded by

Bo Zhang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views14 pages

ACDOCA+ +Session+Notes

The document outlines a hands-on session for SAC and ACDOCA data flow for CO, scheduled for January 10th. It details the ACDOCA-based CDS view data flow, including various setups for obtaining CO documents, AR/AP, material postings, and asset postings. Additionally, it provides technical changes in S4HANA for controlling and includes code blocks for ACDOCA CO flow.

Uploaded by

Bo Zhang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

S24 - SAC Hands-on & ACDOCA Flow for CO

SAC Hands-on & ACDOCA 1. ACDOCA-based CDS View data flow. 10th Jan: 9:30 AM - 11:30 AM
Flow for CO 2. SAC - Hands on Demo
3. Q & A

Batch_3 Page 1
ACDOCA based flow

Batch_3 Page 2
SAP CO
November 4, 2020 5:24 PM

AC DOC A ACDOCA:
AC DOC P / COEP Universal Journal (0L) - Leading Ledger
AC DOC T 1. GL Posting
2. AR (Customer)
3. AP (Vendors)
4. Material Postings
5. Asset Accounting
6. CO PA
7. CO - Cost - Primary & Secondary cost elements data
8. Projects - WBS Elements hierarchy (Program - Project - WBS Element - Activity...)
Cost Element Types in ECC

In S4HANA

Primary Cost Element creation as GL Account Type


G/L Account in S4HANA GL Account Group

Cost Element Category:

Batch_3 Page 3
Secondary Cost Element creation GL Account Type
as G/L Account in S4HANA GL Account Group

Cost Element Category:

S4HANA Technical changes for CO

Reference Links 1. [Link]


SAP Tables [Link]

Batch_3 Page 4
Summary - ACDOCA Postings

From ACDOCA:

ECC : 0CO_OM_CCA_1 - Plan/Budget/Actuals (Summary - Full)


Earlier Stnd Ext 0CO_OM_CCA_9 - Actuals (Delta)
S4HANA C_*
CDS Views I_*
To get CO Docs This one varies from client to client:

Setup 1 Using accounting doc type


Field: BLART = CO

Setup 2 Using the GL Account Type


Field: GLACCOUNT_TYPE = P,S

Setup 3 Using reference document type


Field: AWTYP = COBK

To get AR/AP Common Using Financial Account Type


Setup Field: KOART

D: Customers (AR)
K: Vendors (AP)

To get Material Posting

Batch_3 Page 5
To get Material Posting Common Using Financial Account Type
Setup Field: KOART

M: Material Postings

To get Asset Postings Common Using Financial Account Type


Setup Field: KOART

A: Asset Postings

To get GL Postings Setup 1 Using Financial Account Type


Field: KOART

S: G/L accounts

Other Important
Fields
Accounting Document Blart will provide further details such as invoices, payments, credits, bad debt write offs etc
Type
Field: BLART
Accounting Document BSTAT gives us type of document for us to further put filters and restrictions
Category
Field: BSTAT

Value type for reporting e.g. if WRTTP is '01' the VTYPE will be '020', if WRTTP is '30' the VTYPE will be '070'
(0VTYPE) CASE I_WRTTP.
WHEN '01'. "Planned
E_VTYPE = '020'.
E_VTSTAT = '0'.

WHEN '04'. "Actual


E_VTYPE = '010'.
E_VTSTAT = '0'.

WHEN '05'. "Target (Budget/Forecast)


E_VTYPE = '030'.
E_VTSTAT = '0'.

WHEN '06'. "Target WIP


E_VTYPE = '080'. "Dummy!!!

Batch_3 Page 6
E_VTYPE = '080'. "Dummy!!!
E_VTSTAT = '0'.

WHEN '10'. "Planned stat.


E_VTYPE = '020'.
E_VTSTAT = '1'.

WHEN '11'. "Actual stat.


E_VTYPE = '010'.
E_VTSTAT = '1'.

when '3C'. "Control Costs


E_VTYPE = '090'.
E_VTSTAT = '0'.

WHEN '30'. "Scrab


E_VTYPE = '070'.
E_MEASTYPE = '001300'.
E_VTDETAIL = '41'.
E_VTSTAT = '0'.

WHEN '31'. "Variances


E_VTYPE = '070'.
E_MEASTYPE = '001300'.
E_VTDETAIL = I_ABKAT.
E_VTSTAT = '0'.

WHEN '32'. "Results Analysis and WIP Calculation


E_VTYPE = '080'.
E_VTSTAT = '0'.

From <[Link]

Currency Types in SAP

Accounting document AA Asset Posting


types (BLART) AB Journal Entry
AD Accruals/Deferrals
AF Depreciation Pstngs
AN Net Asset Posting
AP Periodic asset post
CC Sec. Cost CrossComp.
CH Contract Settlement
CL CL/OP FY Postings
CO Secondary Cost
DA Customer document
DG Customer credit memo
DR Customer invoice
DV Customer interests
DZ Customer Payment
ER Manual ExpenseTravel
EU Euro Rounding Diff.
EX External Number
KA Vendor Document
KG Vendor Credit Memo
KN Net vendors
KP Account maintenance
KR Vendor Invoice
KZ Vendor payment
M1 MCA Journal
M2 FX Swap
M3 P&L Lock
M4 P&L Close
M5 P&L Transformation
M6 FX Valuation
M7 MAR & Restatement
M8 IFX Correction
M9 Reversal
MD Data Load
ML ML Settlement
PR Price Change

Batch_3 Page 7
PR Price Change
RA [Link] Stlmt
RB Reserve for Bad Debt
RE Invoice - Gross
RK Invoice Reduction
RN Invoice - Net
RV Billing [Link]
SA G/L Account Document
SB G/L Account Posting
SC Transfer P&L to B/S
SE Inventory Postings
SK Cash Document
SU Intercomp./Clearing
TN
UE Data Transfer
WA Goods Issue
WE Goods Receipt
WI Inventory Document
WL Goods Issue/Delivery
WN Net Goods Receipt
WP Warranty Credit
WR Warranty Debit
WS
Y1 Invoice - Gross
ZP Payment Posting
ZR Bank reconciliation
ZS Payment by Check
ZV Payment Clearing
ZZ Billing [Link]

Batch_3 Page 8
Code Blocks - ACODCA - CO Flow
December 30, 2020 7:07 PM

S4H CDS View @[Link]: 'ZVACDOCACOACTCST'


@[Link]: true
@[Link]: true
@[Link]: #CHECK

@[Link]: 'Controlling - Actual Cost'

@[Link]: #XXL
@[Link]: #MIXED
@[Link]: #D
@[Link]: #SESSION_VARIABLE

@[Link]: #CUBE
@[Link]: true
@[Link]: 'LastChangeDateTime'
@[Link]: 300
@[Link]: true

define view ZI_ACDOCA_CO_ACT_COST as


select from I_GLAccountLineItemCube as a

left outer join I_GLAccountTypeText as b on [Link] = [Link]


and [Link] = 'E'
left outer join I_AccountingDocumentTypeText as c on [Link] =
[Link]
and [Link] = 'E'
left outer join I_FinancialAccountTypeText as d on [Link] =
[Link]
and [Link] = 'E'

{
key [Link],
key [Link],
key [Link],
key [Link],
key [Link],
key [Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],

Batch_3 Page 9
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
@[Link]: true
[Link], --Delta Field
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],
[Link],

Batch_3 Page 10
[Link],

@[Link]: true
[Link],
@[Link]: 'BaseUnit'
[Link],

@[Link]: true
[Link],
@[Link]: 'CompanyCodeCurrency'
[Link],

@[Link]: true
[Link],
@[Link]: 'TransactionCurrency'
[Link],

@[Link]: true
[Link],
@[Link]: 'GlobalCurrency'
[Link]
}

where
([Link] = 'P' or [Link] = 'S')
and ([Link] = '0L')
For Plan WRTTP = '05'
ADSO Keys

-------------------------------------------------------------------------------------------------
Chars and Keyfigures

Batch_3 Page 11
Infosource

TRFN (1st Level)

Batch_3 Page 12
TRFN (1st Level)
Datasource to Infosource

TRFN (2nd Level) -


Infosource to ADSO

Batch_3 Page 13
Infosource to ADSO

Report

Batch_3 Page 14

You might also like