Customer Creation Initial Screen

Bill to Party Available Tabs

1. Address

2. Control Data

3. 3. Payment Transactions

4. Marketing

5. Unloading Points

6. Contact Person

Company Code Details

1. Account Management

2. Payment Transactions

3. Correspondence

4. Insurance

Sales Area Data Sales

2. Sold to Party

1. Address

2. Control Data

3. Payment Transaction

4. Marketing

5. Unloading Points

6. Export Data

7. Contact Person

Company Code Data

1. Account Management

2. Payment Transactions

3. Correspondence

4. Insurance

Sales Area Data

1. Sales

2. Shipping

3. Billing Document

4. Partner Function

3. Payer (Pay to Party) General Data

1. Address

2. Control Data

3. Payment Transactions

4. Marketing

5. Unloading Points

6. Contact Person

Company Code Data

1. Account Management

2. Payment Transactions

3. Correspondence

4. Insurance

Sales Area Data

1. Sales

2. Billing Document

Screen Visibility in Portal: Marketing Manger

Segment General Data

Screen Address Control Data Payment Transactions Marketing Unloading points Export data Contact Person Account Management Payment Transactions Correspondance Insurance Sales Shipping Billing Documents Partner functions Excise Duty Sales Tax/Service Tax Witholding tax

Table KNA1,ADRC KNA1 KNBK KNA1 KNVA KNEX KNVK KNB1 KNB1 KNB5 KNB1 KNVV KNVV KNVV KNVP J_1IMOCUST J_1IMOCUST J_1IMOCUST

SP X X X X X X X

SH X X X X X X X

BP X X X X X X X

PY X X X X X X X X

Agent

Company Code data

X X X X X X X X X X X X

X X X

Sales Area Data

CIN Details

X X X X X

X X X X X

Tables and fields : KNA1-KUNNR General Data: Structure name - ZZT_SD_CUS_STR_GENDATA Table Type ZTable s.no 1 2 3 4 5 6 7 8 9 10 11 - ZZT_SD_CUS_TAB_GENDATA - ZZT_SD_T_CUS_GD Field LAND1 NAME1 NAME2 CITY1 POST_CODE1 table Description Country Key Name 1 Name 2 City Postal Code Region (State, Province, County) Street House number and street Time zone Language First telephone number Fax Number size R/O R R O O O O O R O O O O Condition

REGION ADRC STREET HOUSE_NUM1 TIME_ZONE LANGU TEL_NUMBER

12 FAX_NUMBER

I_BAPIADDR1 Control data: Structure name - ZZT_SD__CUST_STR_CTRLDATA Table Type ZTable s.no 1 2 3 4 - ZZT_SD_CUST_TAB_CTRLDATA - ZZT_SD_T_CUS_CD Field LIFNR VBUND STCEG TXJCD table Description Account Number of Vendor or Creditor Company ID of Trading Partner KNA1 VAT Registration Number Tax Jurisdiction size R/O O O O O Condition

I_KNA1 Payment Transactions: T_XKNBK Table Type

- ZZT_SD_CUS_TAB_PAYMTTRANS

s.no 1 2 3 4 5 6 7 8 9 10 11

Field BANKS BANKL BANKN KOINH BKONT IBAN BVTYP BKREF XEZER KNRZA XZEMP

table Description KNBK Bank country key Bank Keys Bank account number Account Holder Name Bank Control Key IBAN (International Bank Account Number) Partner Bank Type Reference specifications for bank details Indicator: Is there collection authorization ? Account number of an alternative payer KNA1 Indicator: Is an alternative payer allowed in document? - ZZT_SD_T_CUS_PT

size R/O O O O O

Condition

ZTable Marketing : I_KNA1 Table Type s.no 1 2 3 4 Field NIELS KUKLA BRSCH BRAN1

Structure name - ZZT_SD_CUS_STR_PAYMTTRANS

- ZZT_SD_CUST_TAB_MARK table Description Nielsen ID Customer classification KNA1 Industry key Industry Code 1 - ZZT_SD_T_CUS_MKT size R/O O O O O Condition

ZTable

Structure name - ZZT_SD_CUST_STR_MARK Unloading Points: T_XKNVA Table Type - ZZT_SD_CUST_TAB_UNLPT s.no 1 2 3 Field ABLAD DEFAB KNFAK table Description KNVA Unloading Point Default unloading point Customer's factory calendar - ZZT_SD_T_CUS_UP size R/O O O O Condition

ZTable Contact Person Table Type s.no Table 1 KNVK 2

Structure name - ZZT_SD_CUST_STR_UNLPT

- ZZT_SD_CUST_TAB_CNTPR Field ANRED NAME1 Description Form of address for contact person (Mr, Mrs...etc) Name 1 size

3 4 5 6 7 8 9 10

TSABT knvk TPFKT BAPICONTACT_ADDRESSDATA BAPICONTACT_ADDRESSDATA

NAMEV TELF1 ABTNR VTEXT PAFKT VTEXT FAX_NUMBER E_MAIL

First name First telephone number Contact person department Description Contact person function Description Fax Number Email

ZTable Export Table Type s.no Table 1 2 3 KNEX 4 5 6 7 s.no Table 1 2 3 KNA1 4 5 6

- ZZT_SD_T_CUS_CTP

Structure name - ZZT_SD_CUST_STR_CNTPR

- ZZT_SD_CUS_TAB_EXPORT Field LNDEX TDODA TDOCO SDNDA SDNCO DHRDA DHRCO Field CIVVE MILVE CCC01 CCC02 CCC03 CCC04 Description Country key for export control in customer master Date of last check of TDO list for export control ID: TDO boycott list for export control Date of last check of SDN list for export control ID: SDN boycott list for export control Date of last check in inter. boycott list for exp. control ID: Customer boycott list for export control Description ID for mainly non-military use ID for mainly military use Indicator for biochemical warfare for legal control Indicator for nuclear nonproliferation for legal control Indicator for national security for legal control Indicator for missile technology for legal control size R/O O O O O O O O size R/O O O O O O O Condition

Condition

ZZT_SD_T_CUS_EXP Structure name - ZZT_SD_CUS_STR_EXPORT Company code data Account Management Table Type - ZZT_SD_CUS_TAB_ACCMGMT s.no Table 1 KNB1 2 3 4 ZTable Field AKONT ZUAWA FDGRV PERNR Description size R/O Reconciliation Account in General Ledger O Key for sorting according to assignment numbers O Planning group O Personnel Number O Condition

- ZZT_SD_T_CUS_AM

Structure name - ZZT_SD_CUS_STR_ACCMGMT

Payment Transactions Table Type s.no Table 1 KNB1 2 3 4 - ZZT_SD_CUS_TAB_CCPAYTRANS Field ZTERM ZWELS KNRZB ZAHLS HBKID Description Terms of Payment Key List of the Payment Methods to be Considered Account number of an alternative payer Block Key for Payment Short Key for a House Bank size R/O O O O O Condition

ZTable Correspondence Table Type s.no Table 1 KNB5 2 3 4 5 6 7 8 ZTable Insurance

- ZZT_SD_T_CUS_CPT

Structure name - ZZT_SD_CUS_STR_CCPAYTRANS

- ZZT_SD_CUS_TAB_CORR Field MAHNA KNRMA MADAT BUSAB MANSP GMVDT MAHNS MGRUP Description Dunning Procedure Account number of the dunning recipient Date of Last Dunning Notice Dunning clerk Dunning Block Date of the legal dunning proceedings Dunning Level Key for dunning notice grouping size R/O O O O O Condition

- ZZT_SD_T_CUS_COR

Structure name - ZZT_SD_CUS_STR_CORR

Structure name - ZZT_SD_CUST_STR_INSR Table Type ZTable s.no Table 1 KNB1 2 3 4 5 6 SALES AREA Sales Structure name - ZZT_SD_CUS_STR_SASALES Table Type - ZZT_SD_CUS_TAB_SASALES - ZZT_SD_CUST_TAB_INSR - ZZT_SD_T_CUS_INS Field VRSNR VRBKZ VLIBB VERDT VRSZL VRSPR Description Dunning Procedure Account number of the dunning recipient Date of Last Dunning Notice Dunning clerk Dunning Block Date of the legal dunning proceedings size R/O O O O O Condition

ZTable

- ZZT_SD_T_CUS_SAL

s.n o

Table 1 KNVV 2 3 4 5 6 7 8 9 10 11 12 13 14

Field BZIRK VKBUR VKGRP KDGRP BEGRU VSORT EIKTO MEGRU KURST PVKSM KONDA KALKS PLTYP VERSG

Description Sales district Sales Office Sales Group Customer group Authorization Group Item proposal Shipper's (Our) Account Number Unit of Measure Group Exchange Rate Type Customer procedure for product proposal Price group (customer) Pricing procedure assigned to this customer Price list type Customer Statistics Group

siz e

R/O O O O O

Conditio n

Shipping Structure name - ZZT_SD_CUST_STR_SHIP Table Type ZTable s.n o - ZZT_SD_CUST_TAB_SHIP - ZZT_SD_T_CUS_SHI siz e Conditio n

Table 1 KNVV 2 3 4 5 6 7

Field LPRIO VSBED VWERK PODKZ PODTG KZTLF ANTLF

Description Sales district Sales Office Sales Group Customer group Authorization Group Item proposal Shipper's (Our) Account Number

R/O O O O O

Billing Doc Structure name - ZZT_SD_CUS_STR_BILLDOC Table Type ZTable s.no Table 1 KNVV 2 3 - ZZT_SD_CUS_TAB_BILLDOC - ZZT_SD_T_CUS_BD Field PERFK PERRL INCO1 Description Invoice dates (calendar identification) Invoice list schedule (calendar identification) Incoterms (Part 1) size R/O O O O Condition

4 5 6 7 8 9 10 11

KNVI T005T KNVI T685T KNVI TSKDT

ZTERM KTGRD ALAND LANDX TATYP VTEXT TAXKD VTEXT

Terms of Payment Key Account assignment group for this customer Departure country Country Name Tax category (sales tax, federal sales tax,...) Name Tax classification for customer Description

Partner Function Structure name - ZZT_SD_CUST_STR_PARFUN Table Type ZTable s.no 1 2 3 4 5 6 CIN Excise Duty Structure name - ZZT_SD_CUST_STR_EXDUTY Table Type ZTable - ZZT_SD_CUS_TAB_EXDUTY - ZZT_SD_T_CUS_EXD - ZZT_SD_CUST_TAB_PARFUN - ZZT_SD_T_CUS_PF Field PARVW VTEXT KTONR VTXTM KNREF DEFPA Description Partner Function Name Number of an SD business partner Description Customer description of partner Default Partner size R/O O O O O Condition

Table KNVP TPART RF02D(STRUCTURE) RF02D KNVP KNVP

s.no Table 1 J_1IMOCUST 2 3 4 5 6

Field J_1IEXCD J_1IEXRN J_1IEXRG J_1IEXDI J_1IEXCO J_1IEXCICU

Description ECC Number Excise Registration Number Excise Range Excise Division Excise Commissionerate Excise tax indicator for customer

size R/O O O O O O O

Condition

Sales Tax/Service Tax Structure name - ZZT_SD_CUST_STR_SALESTAX Table Type ZTable - ZZT_SD_CUST_TAB_SALESTAX - ZZT_SD_T_CUS_SST

s.no Table 1 J_1IMOCUST 2 3 Withholding Tax

Field J_1ICSTNO J_1ILSTNO J_1ISERN

Description Central Sales Tax Number Local Sales Tax Number Service Tax Registration Number

size R/O O O O

Condition

Structure name - ZZT_SD_CUST_STR_WHTAX Table Type ZTable - ZZT_SD_CUST_TAB_WHTAX - ZZT_SD_T_CUS_WHT Field J_1IPANNO J_1IPANREF J_1ISERN Description Permanent Account Number PAN Reference Number Service Tax Registration Number size R/O O O O Condition

s.no Table 1 J_1IMOCUST 2 3 BAPIs S.no BAPI Name 1 2 3 4 5 6 7

SD_CUSTOMER_MAINTAIN_ALL BALW_BAPIRETURN_GET2 NUMBER_GET_NEXT GUID_CREATE BAPI_TRANSACTION_COMMIT BAPI_TRANSACTION_ROLLBACK BAPI_CUST_GETDETAIL2

Description Customer creation BAPI Error message Running number Guide creation Save data Roll back data Get customer detail customer credit check Customer updation

8 SD_CREDIT_EXPOSURE 9 CUST_UPDATE Tables

S.no 1 2 3

Table Name ZZT_SD_T_CUS_TRACK ZZT_SD_T_CUS_MATRIX ZZT_SD_T_CUS_DATA_MAINTAIN

Description Customer track table Customer matrix table Sold to party data

Structures: S.no Name 1 ZZH_SD_CUS_STR_ Desc

Table types: S.no Name 1 ZZH_SD_CUS_TAB_ Desc

Proposed Screen: Screen 1:

Screen 2:

Screen 3:

Screen 4:

Screen 5:

Screen 6:

Screen 7:

Estimation: