Additional Information for Value Mapping for Master Data Distribution in SAP ECC in Integration Hub

Additional Information for Value Mapping for Master Data Distribution in SAP ECC in Integration Hub

Business Partner

SAP ECC

Customizing Table         Values

SAP Integration Framework 2.0

Value Mapping Table

SAP Business One

Value Table                     Default Values

T151

Customers: Customer Groups

01  Industry
02  Retail


GroupCode

OCRG 

Customer Groups

(Type C) 

100 Customers

101 Vendors

T047A 

Account Level Dunning Control

0001  Four-level dunning notice, every two weeks

0003  Payment reminder, every two weeks

0005  Four-level dunning notice, every two weeks, RE forms

DunningTerm

ODUT

Dunning Levels 

No default values available

TVCIN

Payment cards: Type

AMEX

MC

VISA

and so on

CreditCardTypes

OCRC

Credit Cards

No default values available

T008

Payment blocks 

'   Free for payment

*   Skip account

A  Blocked for payment

B  Blocked for payment

N  Postprocess inc.pmnt

P  Payment request

R  Invoice verification

V  Payment clearing

PaymentBlockDescription

OPYB

Payment Blocks

1 Inability to pay 

2 Poor quality

3 Disputed items 

4 Legal action

KNA1

Customer number 


No default values available

SalesPersonCode

OSLP

Sales Employees

If not provided, the system sets name of KUN2.

T042E

Company Code-Specific Specifications for Payment Methods

A Bank direct debit

E Automatic debit

F Debit for one-time customer (CPD)

K Bank check for foreign payment 

L Foreign bank transfer

O Order check

P Postal check transfer

R European transfer

S Check

T Check/Bill of exchange

U Bank transfer

V Clearing (in a group)

W Bill of exchange (foreign payment)

CollectionAuthori-zation

There is no value table available, but fixed values for yes and no.

tYES

tNO

TVSB

Shipping Conditions

01 As soon as possible

02 Standard

03 Collect processing

04 Transport Service

05 Just-in-time

06 Synch to production

08 TVPS Multimode

09 Pick up

10 Immediately

20 Domestic 24/48h

ShippingType

OSHP

Shipping Types

No default values available

T042Z

Payment Methods for Automatic Payment

(Dependent on Country Key. More than one payment method may be selected)

A ACH

U International Bank Transfer

C Check

S Single Check

T Bank Transfer

W Fed Wire

PaymentMethodCode

OPYM

Payment Methods

No default values available

T171

Customers: Sales Districts

000001 Northern Region


US0015 US Midwest Region


Territory

OTER

Territory

No default values available

T052

Terms of Payment

0001 Payable immediately Due net

0002 Within 14 days 3% cash discount


NT30 Net 30


PayTermsGrpCode

OCTG

Payment Terms

-1 Monetary basis

3 Discount

T005U

Region (State, Province, County)

01 Schleswig-Holstein

02 Hamburg

03 Lower Saxony

04 Bremen

05 Nrth Rhine Westfalia

06 Hessen

07 Rhineland Palatinate

08 Baden-Wurttemberg

09 Bavaria

10 Saarland

11 Berlin

12 Brandenburg

13 Mecklenburg-Vorpomm.

14 Saxony

15 Saxony-Anhalt

16 Thuringia

State

OCST

Code


TPRIT

Customers: Delivery Priorities


Priority

OBPP

Business Partner Priorities



Product

If the default values in the table below do not already exist in SAP ECC and SAP Business One, enter them manually.

SAP ECC

Customizing Table         Values

SAP Integration Framework 2.0

Value Mapping Table

SAP Business One

Value Table                     Default Values

T134

Material Types

CONT

COUP

DIEN

ERSA

FERT

FGTR

FHMI

FOOD

FRIP

HALB

HAWA

HERS

HIBE

INTR

KMAT

LEER

LGUT

MODE

NLAG

NOF1

PIPE

PROD

ROH 

UNBW

VERP

VKHM

VOLL

WERB

WERT

WETT 

Not applicable 

In the current release, an item type is always set.

OITM

Item Types

Item

Labor

Travel

T023

Mat. Groups

01 Material Group 1

02 Material Group 2


ItemGroupCode

OITB

Item Groups 

100 Articles

T025

Valuation Classes 

0710

0720

1210

3000

3001

3002

3003

3030

3031

3040

3050

3100

3200

3300

7900

7920




T006

Units of Measurement 

MM Millimeter

CM Centimeter

DM Decimeter

M Meter

" Inch

FT Feet

PurchaseHeightUnit, PurchaseLengthUnit, PurchaseWidthUnit, SalesHeightUnit, SalesLengthUnit, SalesWidthUnit

OLGT

Length and Width UOM

1 mm

2 cm

3 dm

4 m

5 ''

6 '

T006

Units of Measurement 

MG Milligram

G Gram

KG Kilogram

OZ Ounce

LB US Pound

PurchaseWeightUnit, SalesWeightUnit

OWGT

Weight UOM 

1 mg

2 g

3 kg

4 Oz

5 Lb

T006

Units of Measurement 

“3 Cubic Inch

CCM Cubic Centimeter

CDM Cubic Decimeter

CL Centiliter

FOZ Fluid Ounce US

FT3 Cubic Foot

GAL US Gallon

HL Hectoliter

L Liter

M3 Cubic Meter

ML Milliliter

MM3 Cubic Milliliter

PT Pint, US liquid

QT Quart, US liquid

PurchaseVolumeUnit, SalesVolumeUnit

OLGT

Length and Width UOM

1 cmm

2 cc

3 cdm

4 cm

5 ci

6 cf

T438A

MRP Type


PD

ND


PlanningSystem

Expected values in the SAP Business One interface DI-API

bop_MRP Material Requirement 

Planning System

bop_None 

No Planning System

T001W

Plants or Branches

3000


DefaultWarehouse, WarehouseCode

OWHS

Items, Warehouse


01 General Warehouse


Next Step: Appendix - Sample flow process for Master Data Distribution in SAP ECC in Integration Hub