# SAP SD Customer Master Sales Area Load Worksheet > Source: https://netray.co/tools/sap-sd-customer-master-sales-area-load-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Collect sales area data per customer: sales org, channel, division, shipping, incoterms, payment terms and tax classification, then export to Excel. ## Category sap ## Erp SAP S/4HANA ## Audience - SAP SD consultant - Master data lead - Data migration lead ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Customer no. **Key:** cust **Type:** text #### Name **Key:** name **Type:** text #### Sales org **Key:** salesorg **Type:** text #### Dist. channel **Key:** chan **Type:** text #### Division **Key:** div **Type:** text #### Shipping condition **Key:** ship_cond **Type:** select **Options:** - 01 Standard - 02 Express - 03 Pickup #### Delivering plant **Key:** plant **Type:** text #### Incoterms **Key:** inco **Type:** select **Options:** - EXW - FCA - FOB - CIF - CIP - DAP - DDP #### Incoterms location **Key:** inco_loc **Type:** text #### Payment terms **Key:** terms **Type:** text #### Currency **Key:** cur **Type:** select **Options:** - USD - EUR - GBP - INR - CNY - ZAR #### Cust. pricing procedure **Key:** cust_proc **Type:** text #### Acct assignment group **Key:** acct_grp **Type:** text #### Tax class **Key:** tax **Type:** select **Options:** - 0 Exempt - 1 Taxable #### Credit limit **Key:** credit **Type:** number **Format:** number **Rows:** #### Northline Machining **Cust:** 100234 **Salesorg:** 1000 **Chan:** 10 **Div:** 00 **Ship cond:** 01 Standard **Plant:** 1100 **Inco:** FCA **Inco loc:** Dallas **Terms:** NT30 **Cur:** USD **Cust proc:** 1 **Acct grp:** 01 **Tax:** 1 Taxable **Credit:** 250000 #### Rhein Aero GmbH **Cust:** 100877 **Salesorg:** 2000 **Chan:** 10 **Div:** 00 **Ship cond:** 02 Express **Plant:** 2100 **Inco:** DAP **Inco loc:** Hamburg **Terms:** NT45 **Cur:** EUR **Cust proc:** 1 **Acct grp:** 02 **Tax:** 1 Taxable **Credit:** 400000 #### Pune Drives Pvt Ltd **Cust:** 101502 **Salesorg:** 3000 **Chan:** 20 **Div:** 00 **Ship cond:** 01 Standard **Plant:** 3100 **Inco:** CIF **Inco loc:** Nhava Sheva **Terms:** NT60 **Cur:** INR **Cust proc:** 2 **Acct grp:** 03 **Tax:** 1 Taxable **Credit:** 9000000 **Totals:** #### Total credit limit **Key:** credit **Agg:** sum **Format:** number **Summary:** #### Customer sales area rows **Key:** n **Expr:** count **Format:** integer **Primary:** true **Notes:** Sales area data lives in table KNVV, one row per customer and sales area. Partner functions are held in KNVP and tax data in KNVI. Credit limits are held in credit management and shown here for planning only. In S/4HANA customers are maintained through business partners. ## Content **Intro:** The customer master has three layers: general, company code and sales area. SD owns the last one. This worksheet gathers the sales area data for each customer so the load file is complete before cutover. **Sections:** #### How to use the worksheet **Body:** Enter one row per customer and sales area. If a customer buys through two sales organisations, create two rows. Pick the shipping condition, delivering plant, incoterms and payment terms from your own reference lists. Export to Excel and send the sheet to the customers' account managers for confirmation before it goes to your load tool. #### What each field drives **Body:** The shipping condition and loading group determine the shipping point. Incoterms and their location print on order confirmations and invoices, and drive export documents. Payment terms feed due date and cash discount. The customer pricing procedure and the sales document pricing procedure together select the pricing procedure. The account assignment group decides which revenue account is found in billing. **Bullets:** - Shipping condition and plant set the shipping point - Customer pricing procedure helps pick the procedure - Account assignment group drives revenue accounts - Tax classification drives the tax code in billing #### Reviewing the sheet **Body:** Filter by sales org and confirm every row has a delivering plant, incoterms and payment terms. Missing values will either stop order entry or default silently, and silent defaults create wrong invoices. Check currency against the sales organisation and credit limit against the credit control area. Compare the number of rows to the number of active customers per sales area in the legacy system. #### Common mistakes **Body:** Teams migrate general data but forget sales area data, copy all customers into every sales area, leave account assignment group blank, or load incoterms that conflict with the shipping condition. Another trap is partner functions: each ship-to needs its own master record and a link in the sold-to. Test a handful of customers through VA01 before loading all of them. **Cta:** For migrations, Netray can compare legacy customer data with the target structure and flag missing or inconsistent sales area fields, read-only. **Faq:** #### Which table stores customer sales area data? **Answer:** Table KNVV holds one row per customer, sales organisation, distribution channel and division. General data is in KNA1, company code data in KNB1 and partner functions in KNVP. #### Do I need a row for every division? **Answer:** Only if your configuration requires it. Many companies use a common division for master data and handle product divisions in the material master and document. Check your sales area design. #### How does S/4HANA change customer creation? **Answer:** In S/4HANA the business partner transaction BP is the leading entry point, and customer roles are added to the partner. Customer data is still stored for SD use, but loads normally use the migration cockpit or APIs. #### Is the credit limit part of the sales area data? **Answer:** No. Credit limits live in credit management, either in the classic credit control area setup or in SAP Credit Management. The column here is for planning and approval during data collection. ## Search terms sap customer master sales area data, sap knvv fields template, sap customer master load template excel, sap xd01 sales area data, sap customer migration sheet, sap business partner customer sales data template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json