Query Category

OQCN

Category Name

Tools → Queries → Query Manager → Manage Categories

All Methods

Yes

Query

OUQR

Category Name + Query Name

OQCN

Tools → Queries → Query Manager or Tools → Queries → Query Generator

All Methods

Yes

User Defined Field

CUFD

TableID + FieldID

UDT

Tools → Customization Tools → User-Defined Fields Management

All Methods

Yes

User Defined Table

OUTB

TableName

Tools → Customization Tools → User-Defined Tables Setup

All Methods

Yes

User Defined Object

OUDO

Code

UDT, UDF

Tools → Customization Tools → Objects Registration Wizard

All Methods

Yes

The contents of the UDO are not copied.

FMS/UDV

CSHS

FormID + ItemID

OUQR

Select field and press Alt + Shift + F2

All Methods

Yes

Language

OLNG

Short Name

Administration → Setup → General → Languages

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

System language is not deleted.

Document Type

RTYP

Name

Access via DI API

All Methods

No

Report & Layout

RDOC

DocType + DocName

RTYP, OLNG

Administration → Setup → General → Report and Layout Manager

All Methods

Yes

Projects

OPRJ

Project Code

Administration → Setup → Financials → Projects

All Methods

No

Transaction Codes

OTRC

Code

Administration → Setup → Financials → Transaction Codes

All Methods

No

Account Category

OACG

Name + Source

Financials → Chart of Accounts

All Methods

No

Dimensions

ODIM

DimCode

Financials → Cost Accounting → Dimensions

All Methods

No

All methods only update existing dimensions.

Cost Center Type

OCCT

CctCode

Financials → Cost Accounting → Cost Centers → Cost Center Type

All Methods

No

Cost Center

OPRC

PrcCode

ODIM, OCCT

Financials → Cost Accounting → Cost Centers

All Methods

No

System cost centers are not deleted.

When updating system cost centers, update process may fail if Effective Date is not defined.

Distribution Rules

OOCR

OcrCode

ODIM, OPRC

Financials → Cost Accounting → Distribution Rules

All Methods

No

When updating, sub-table OCR1 in target is replaced by source.

System-created distribution rules for cost centers are not deleted or updated.

CFOP Codes

OCFP

Code

Administration → Setup → Financials → Tax → Nota Fiscal → CFOP Codes

All Methods

No

Tax Category

ONFT

Code

Administration → Setup → Financials → Tax → Tax Types (Tax Category column)

All Methods

No

Locked system records are not deleted.

Card Groups

OCRG

Group Name

OPLN

Administration → Setup → Business Partners → Customer Groups and  Administration → Setup →Business Partner → Vendor Groups

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Cannot delete last business partner groups.

Shipping Types

OSHP

Name

Administration → Setup → Inventory → Shipping Types

All Methods

No

Indicator

OIDC

Code

Business Partners → Business Partner Master Data → General tab

Add New Records and Update Existing Records

No

BP Industry Name

OOND

Industry name

Business Partners → Business Partner Master Data → General tab

All Methods

No

Sales Employees/Buyers

OSLP

Sales Employee Name

OCOG, OHEM

Administration → Setup → General → Sales Employees/Buyers

All Methods

No

Default sales employees are not deleted or updated.

Employee related data is not copied with OSLP, but is copied together with OHEM.

Agent

OAGP

Agent Code + Name

Business Partners → Business Partner Master Data → General tab

All Methods

No

Business Partner Properties

OCQG

Proterty GroupCode

Administration → Setup → Business Partners → Business Partner Properties

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

No

Cannot delete system properties.

Business Partners

OCRD

CardCode

OCRD, OCRG, OPLN, OCOG, OSLP, OCRN, OACT, OCST, OBPP, OCRC, ODDG, OSTC, OIDC, OSHP, OCTG, OTNN, OPYM, ODUN, OCRY, OPYB, OPRJ, OAGP, OWHT, OHLD, ODUT, OHEM, OTER, OLNG, ODSC, OCDP, OBCA, OVTP, OOND, OCPN, OTWS, OCNA

Business Partners → Business Partner Master Data

All Methods

No

Contact Person

OCPR

CardCode + Contact Person Name

OCRD, OCRY

Business Partners → Business Partner Master Data

All Methods

No

BP Ship to Address and Bill to Address

CRD1

CardCode + Address Name + Address Type

OCST, OCRY

Business Partners → Business Partner Master Data

All Methods

No

Serial Numbers

NNM1

N/A

N/A

N/A

N/A

No

Territories

OTER

Name

OTER

Administration → Setup → General → Territories

All Methods

No

Countries

OCRY

Code

OADF

Administration → Setup → Business Partners → Countries

All Methods (In BR, do not support Delete All Records Then Add New Records)

No

Country of current localization is not deleted.

In BR localization, Country is used by State.

States

OCST

Country Code + State Name

OCRY

Business Partners → Business Partner Master Data

All Methods (In BR, do not support Delete All Records Then Add New Records)

No

In BR localization, State is used by County.

Address Format

OADF

Name

Administration → Setup → Business Partners → Address Format

All Methods (In BR, do not support Delete All Records Then Add New Records)

No

Default address format for country of current localization is not deleted.

Define Summary VAT Report Type

OSVT

Name

Administration → Setup → Financials → Tax → Tax Groups

All Methods

No

Service Supply

OSSP

Code

Administration → Setup → Financials →Tax → Tax Groups

All Methods

No

Tax Report Type

OKRT

TaxRepType

OSVT

Administration → Setup → Financials → Tax → Tax Groups

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Goods Shipment

OGSP

Code

Administration → Setup → Financials → Tax → Tax Groups

All Methods

No

Triangular Deal

OIND

Code

Administration → Setup → Financials → Tax → Tax Groups

All Methods

No

Tax Group

OVTG

Code

OACT, OIND, OGSP, OSSP, OVTG (in BE, PT), OKRT (in KR)

Administration → Setup → Financials → Tax → Tax Groups

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

To copy IsiGIC field, you must enable extended tax reporting in the target.

Place of Business

OBPL

Name

Administration → Setup → Financials

All Methods

No

Multiple Branch

OBPL

Name

OCRD, OWHS, OCNA, OBNI, OBSI, OCST, OCNT, OCRY

Administration → Setup → Financials

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

In BR localization, target must have multiple branches enabled (this setting is not copied).

When copying BPs, if BP is assigned to a branch, which is not assigned to the user performing the copy process, the copy process will fail. To solve this issue, either copy the relevent user together with the branch, or first manually assign the user to the branch in the target.

CNAE Code

OCNA

CNAECode

Administration → Setup → Financials → Branches

All Methods

No

Tax Parameter

OTPS

Code

OTPA, OTPR

Administration → Setup → Financials → Tax → Tax Engine Configuration → Tax Parameter

All Methods

No

Tax Parameter Attributes

OTPA

Code

Administration → Setup → Financials → Tax → Tax Engine Configuration → Tax Parameter (Attributes Grid)

All Methods

No

Locked system records are not deleted.

Tax Return Values

OTPR

Code

Administration → Setup → Financials → Tax → Tax Engine Configuration → Tax Parameter (Return Values Grid)

All Methods

No

Locked system records are not deleted.

Sales Tax Code/Tax Code

OSTC

Code

OSTA, OTFC (in BR, IN), OFML (in BR, IN), OCFP (in BR), OTSC (in BR)

Administration → Setup → Financials → Tax → Tax Code

All Methods

No

When updating, sub-table STC1 in target is replaced by source.

Sales Tax Authorities

OSTA

Type Name + Code

OACT, OSTT

Administration → Setup → Financials → Tax → Tax Code (Click link button of Code column in Grid)

All Methods

No

When updating, sub-table STA1 in target is replaced by source.

Tax  Type

OSTT

Name

ONFT, OTPS (in BR,IN)

Administration → Setup → Financials → Tax → Tax Types

All Methods

No

Tax Type Combination

OTFC

Code

OSTT, OFML

Administration → Setup → Financials → Tax → Tax Engine Configuration → Tax Type Combination

All Methods

No

Tax Formula

OFML

Code

OSTT

Administration → Setup → Financials → Tax → Tax Engine Configuration → Tax Formula

All Methods

No

Banks

ODSC

CountryCod + BankCode

OCRY, DSC1, OBOC

Administration → Setup → Banking → Banks

All Methods

No

House Bank Account

DSC1

Country + BankCode + Account

OCRY, OCST, OACT, ODSC, NNM1

Administration → Setup → Banking → House Bank Account

All Methods

No

CST Codes

OTSC

Tax Category + CST Code Incoming

ONFT

Administration → Setup → Financials → Tax → Nota Fiscal → CST Codes for Nota Fiscal

All Methods

No

Material Group

OMGP

Material Group

Administration → Setup → Financials → Tax → Item Classification → Material Groups

All Methods

No

NCM Code

ONCM

NcmCode

Administration → Setup → Financials → Tax → Item Classification → NCM Code

All Methods

No

Service Group

OSGP

Service Group

Administration → Setup → Financials → Tax → Item Classification →Service Group

All Methods

No

DNF Code

ODNF

NCM Code + DNFCode

ONCM

Item Master Data, click "DNF Code"

All Methods

No

User

OUSR

User Name (User_Code)

OUPT, OUDP, OUBR, OBPL (in BR multi-branch)

Administration → Setup → General → Users

All Methods

No

User settings for Tools → My Menu are replaced.

Cannot delete current user and system users (manager, B1i, Workflow).

Cannot copy authorizations for reports and dashboards.

Cockpit setting are not copied.

User shortcuts are copied.

Department

OUDP

Branches Name (Name)

Administration → Setup → General → Users, Department

All Methods

No

System department is not deleted.

Branch

OUBR

Departments Name (Name)

Administration → Setup → General → Users, Branch

All Methods

No

System branch is not deleted.

Column Preferences

CPRF

FormID + ItemID + ColID + User_Code

OUSR

All Methods

No

Records linked to deleted users, current user, and system users (manager, B1i, Workflow) are not deleted.

Additional Authorization Creator

OUPT

Authorization ID (AbsID)

Administration → System Initialization → Authorizations → Additional Authorization Creator

All Methods

No

Employee Master Data

OHEM

lastName + firstName + middleName

OHEM, OHTY, OHTR, OHED, OHST, OHPS, OIDT, OCNT,

Human Resources → Employee Master Data

All Methods

No

Sub-tables HEM1 (absence) and HEM3 (reviews) are not copied.

Duplicated names are not copied.

Attachments are not copied.

Employee Types

OHTY

Name

Human Resources → Employee Master Data, Membership tab, Role

All Methods

No

System employee types are not deleted.

Employee Status

OHST

Name

Human Resources → Employee Master Data, Administration tab, Status

All Methods

No

Employee Termination Reasons

OHTR

Name

Human Resources → Employee Master Data, Administration tab, Termination Reason

All Methods

No

Employee Position

OHPS

Name

Human Resources → Employee Master Data, header, Position

All Methods

No

In BR localization, if theActivate Localization Fields option is selected, you cannot delete employee position.

Employee Education Type

OHED

Name

Human Resources → Employee Master Data, Administration tab, click Education, Education Type

All Methods

No

Employee Teams

OHTM

Name

OHEM

Human Resources → Employee Master Data, Membership tab, Team

All Methods

No

When copying teams, you must also copy the employees together with the teams to which they are linked.

Employee ID Type

OIDT

ID Type Name (IDType)

Human Resources → Employee Master Data, Personal tab, ID Type

All Methods

No

System employee ID type is not deleted.

Financial Report Templates

OFRT

ABS_ID

DIM

Financials → Financial Report Templates

All Methods

No

Financial Report Categories

OFRC

CAT_ID + Template_ID

ACT, CFW, PRC, SLP (in CN, JP, KR)

Financials → Financial Report Templates

All Methods

No

Cash Flow Line Items

OCFW

CFWName

CFW

Administration → Setup → Financials

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Nature of Assessee

ONOA

CODE

Administration → Setup → Financials → TDS → Nature of Assessee

All Methods

No

Withholding Tax

OWHT

WT_Code

OSEC, ONOA, OLCT, OBSI, OTSC, OCRN

Business Partners → Business Partner Master Data → Accounting tab → Tax tab → Subject to Withholding Tax → WTax Determination

All Methods

No

Section

OSEC

Code

Administration → Setup → Financials → TDS → Sections

All Methods

No

Brazil String Indexer

OBSI

IndexType + Code

Administration → Setup → Financials → Tax → Withholding Tax

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Price List

OPLN

List_Name

OPLN

Inventory → Price Lists → Price Lists

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Cash Discount

OCDC

Code

Administration → Setup → Business Partners → Payment Terms → Cash Discount

All Methods

No

Inventory Cycles

OCYC

Name

Administration → Setup → Inventory → Inventory Cycles and Administration → Setup → Inventory → Item Group → General tab → Order Interval

All Methods

No

Inventory cycles and order intervals belong to the same object, OCYC.

County

OCNT

Country + State + Code

OCRY, OCST

Inventory → Item Master Data

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Service Code

OSCD

County + Service Code

OCNT

Administration → Setup → Financials → Tax → Item Classification → Service Codes

All Methods

No

Payment Terms

OCTG

Group_Name

OCDC, OPLN

Administration → Setup → Business Partners → Payment Terms

All Methods

No

Default payment terms for vendors and customers are not copied.

Locations

OLCT

Name

OCRY, OCST

Administration → Setup → Inventory → Locations

All Methods (In IN, do not support Delete All Records Then Add New Records)

No

In IN localization, cannot delete default "Delhi" location.

Account

OACT

Account_Identifier

OOCR, OPRJ, OACG, OSTC, OBPL (in BR), OTRC (in FR), OVTG

Financials → Chart of Accounts

Delete All Records Then Add New Records

No

Sequence of accounts between target and source may be different after copying.

Account Segmentation

OASG

#

Administration → Setup → Financials → Account Segmentation

Delete All Records Then Add New Records

No

After copying, Use Segmentation Accounts setting will be the same in source and target.

When copying CoA, account segmentation and posting periods are automatically selected for copying.

Posting Periods (with its G/L Accounts)

OACP

Period Code

OACT, OVTG, OWHT, OCRD

Administration → Setup → Financials → G/L Account Determination

Delete All Records Then Add New Records

No

When copying CoA, account segmentation and posting periods are automatically selected for copying.

In some localizations, default withholding tax and default VAT group are not copied, since the data is stored in OADM.

Customs Groups

OARG

Name

OACT

Administration → Setup → Inventory → Customs Groups

All Methods

No

Fixed Assets Account Determination

OADT

Code

OACT

Administration → Setup → Financials → Fixed Assets → Account Determination

All Methods

No

Manufacturers

OMRC

Name

Administration → Setup → Inventory → Manufacturers

All Methods

No

Item Groups

OITB

Name

OACT, OCYC, OSCD, OSGP, ONCM, OMGP, OUOM, OUGP, OWHS

Administration → Setup → Inventory → Item Groups

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Cannot delete the last item group.

Asset Groups

OAGS

Code

Inventory → Item Master Data → Fixed Assets Table → Assets Groups

All Methods

No

Service Categories

OSCG

servicecfg

Inventory → Item Master Data → General Table → Service Categories

All Methods

No

Cannot update used records.

Currency

OCRN

CurrCode

Administration → Setup → Financials → Currencies

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Cannot delete system and local currency.

India Chapter ID

OCHP

chapter_id (Chapter,Heading,SubHeading)

Inventory → Item Master Data → General Table → India Chapter ID

All Methods

No

Brazil Numeric Indexer

OBNI

Index type + Code

Administration → Setup → Financials → Branches

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Warehouses

OWHS

OWHS_CODE

OACT, OLCT, OCRY, OCST, OCNT (in BR), OBPL, OSTC (in US), OBIN

Administration → Setup → Inventory → Warehouses

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

At least one default warehouse is required.

External Bank Operation Code

OBOC

Operation Code Category (OpCodeCat)

OBTC

Administration → Setup → Banking → Bank Statement Processing → External Bank Operation Code

All Methods

No

Internal Bank Operation Code

OBTC

Code (InOpCode)

OACT, OPRJ, OOCR, OVTG

Administration → Setup → Banking → Bank Statement Processing → Internal Bank Operation Code

All Methods

No

Depreciation Areas

ODPA

Code

ODPA

Administration → Setup → Financials → Fixed Assets

All Methods

No

Pool of Depreciation Type

ODPP

Code

Administration → Setup → Financials → Fixed Assets → Depreciation Type → Pool of Depreciation Type (calculation table)

All Methods

No

Withholding Tax Determination

DDT

Cardcode, WHShaamGrp, TrcCode

OCRD

Administration → Setup → Financials → Tax

All Methods

No

Depreciation Type

ODTP

code

ODTP, ODPP

Administration → Setup → Financials → Fixed Assets

All Methods

No

When updating, sub-table DTP1 in target is replaced by source.

Brazil Beverage Indexer

OBBI

TableCode, BrandCode, GroupCode

OBSI, OBNI

Item Master Data → Purchasing Data tab → Beverage Table

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Asset Classes

OACS

Code

ODTP, ODPA, OADT

Administration → Setup → Financials → Fixed Assets

All Methods

No

Item Master Data

OITM

Code

OITB, OARG, OVTG, OACT, OCRD, OMRC, ADP1, OSHP, OSTC, OSCD, OSGP, ONCM, OMTP, OMGP, OSCG, OCHP, ODNF, NNM1, OBFI, OBSI, OBNI, OUGP, OUOM, OACS, OAGS, OHEM, OLCT, OPLN, OCRN, OPKG, OPRJ, OOCR, ODPA, ODTP, ODCI, OCST, OCRY, OBCD, OBMI, OCYC, OUSR, OCTT, OCOG

Inventory → Item Master Data

All Methods

No

When copying items without shipping types in source, target shipping type is automatically assigned to items.

Commission Group

OCOG

Name

Administration → Setup → General → Commission Group

All Methods

No

User Defaults

OUDG

Code

OWHS, OSLP, OCRD, OCRC, OCRY, OSTC, OBPL (KR)

Administration → Setup → General → User Defaults

All Methods

No

Advanced G/L Account Determination Rules

OGAR

abs_Entry

OITM, OITB, OWHS, OCRG, OCST, OACT

Administration → Setup → Financials → G/L Account Determination

Delete All Records Then Add New Records

No

When copying Advanced G/L Account Determination Rule, Determination Criteria is automatically selected for copying.

Determination Criteria

ODMC

DmcId

Administration → Setup → Financials → G/L Account Determination → Determination Criteria

Delete All Records Then Add New Records

No

When copying Advanced G/L Account Determination Rule, Determination Criteria is automatically selected for copying.

Brazil Mutli-Indexer

OBMI

Index type + Code

OBNI

Item Master Data → Purchasing Data tab → SPED

All Methods

No

Bin Location Field Activation

OBFC

FldType + FldNum

Administration → Setup → Inventory → Bin Locations

All Methods

No

All methods only update system bin location field activations.

Bin Location Attribute Codes

OBAT

FldAbs + AttrValue

Administration → Setup → Inventory → Bin Locations

All Methods

No

Warehouse Sublevel Codes

OBSL

FldAbs + SLCode

OBFC

Administration → Setup → Inventory → Bin Locations

All Methods

No

SYSTEM-BIN-LOCATION is not deleted.

Bin Location Master Data

OBIN

BinCode

OWHS, OBSL, OBAT, OITM, OITB

Administration → Setup → Inventory → Bin Locations

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

When copy '02-A1' to Target failed maybe because '02-A1' already exist, 'A1' for different Sublevel.

If the bin location code separator is different in source and target, you may encounter errors. For example, if source bin location code is Whs01+A1 and target bin location code is Whs01*A1, addition of Whs01+A1 will fail.

BP Bank Account

OCRB

Country + BankCode + Account + CardCode

OCRY, ODSC, OCST

Business Partners → Business Partner Master Data → Payment Term tab

All Methods

No

Dunning Terms

ODUT

TermCode

OACT

Administration → Setup → Business Partners

All Methods

No

Closing Date Procedure (JA)

OCDP

ClsDtCode

Administration → Setup → Business Partners → Closing Date Procedure

All Methods

No

Credit Cards

OCRC

CreditName

OACT

Administration → Setup → Banking → Credit Cards

Add New Records and Update Existing Records

Add New Records Without Updating Existing Records

Update Existing Records Without Adding New Records

No

Business Partner Priorities

OBPP

PrioCode

Administration → Setup → Business Partners

All Methods

No

Holiday

OHLD

HldCode

Administration → System Initialization → Company Details

All Methods

No

Bank Charges Allocation Codes

OBCA

Code

Administration → Setup → Banking → Bank Charges Allocation Codes

All Methods

No

Payment Blocks

OPYB

payBlock

Administration → Setup → Business Partners → Payment Blocks

All Methods

No

Payment Methods

OPYM

Code

OFRM, OCRC, DSC1, OCRN, OCTG, ODTY, OPTF, OIST, OOCC, OCRN

Administration → Setup → Banking → Payment Methods

All Methods

No

FileFormat

OFRM

Name + formatType

N/A

All Methods

No

System file format is not deleted.

Vendor Type

OVTP

Vendor Type (VendorType)

Business Partners → Business Partner Master Data → Accounting tab → Tax tab

All Methods

No

System vendor types are not deleted.

Contract Template

OCTT

template name

Administration → Setup → Service → Contract Template

All Methods

No

1099 Forms

OTNN

Form1099

Business Partners → Business Partner Master Data → Accounting tab

All Methods

No

System records are not deleted.

e-Tax Website

OTWS

TwsName

Administration → Setup → Financials → Tax

All Methods

No

BoE Document Type

ODTY

DocType

Administration → Setup → Banking → Payment Methods

All Methods

No

BoE Portfolio

OPTF

Internal PortFolio ID

Administration → Setup → Banking → Payment Methods

All Methods

No

BoE Instruction

OIST

Instruction Code + IsCancel

Administration → Setup → Banking → Payment Methods

All Methods

No

BoE Occurrence

OOCC

Code + IsMovement

Administration → Setup → Banking → Payment Methods

All Methods

No

Bar Code

OBCD

BcdCode + UomEntry + ItemCode

OUOM

Administration → Setup → Inventory → Bar Codes

All Methods

No

UoM Master Data

OUOM

UomCode

Administration → Setup → Inventory → Units of Measurement

All Methods

No

UoM Group

OUGP

UgpCode

OUOM

Administration → Setup → Inventory → Units of Measurement Group

All Methods

No