High- Level Specification
| Implementing System | SAP S/4HANA |
|---|---|
| Invoked by/Invokes | ERP-1138 - Getting issue details... STATUS |
| Business Process Reference | 02.04.02.01. Manage Standard Sales Order |
Functional Overview
EDI customers sends their Sales Order creation message through Elemica to Syensqo. Elemica sends the OrderCreate XML to SAP CPI which then calls a custom API to create the Sales Order in Syensqo's S/4HANA system.
The purpose of this functional specification is to create the custom API for the creation of a sales order in S/4HANA either
- From data directly available in the Elemica XML or
- from data derived from S/4HANA based on data in the Elemica XML.
Scope and Objectives
This System Interface, a custom implementation in SAP S/4HANA,
- consumes the OrderCreate data from SAP CPI
- maps this data into a structure to create a sales order in SAP S/4HANA
- transform some data OrderCreate message from SAP CPI into the Sales Order structure in S/4HANA
- performs lookup of specified data (as applicable) in S/4HANA
- stored certain data from OrderCreate message from SAP CPI into a S/4HANA custom table
The standard SAP Sales Order API is unable to support the above functions, hence the need for a custom API.
Process Flow Diagram
Step | Description | Comment |
|---|---|---|
1 | Based on the purchase order received from Syensqo's EDI customer, Elemica converts this into OrderCreate message and sends to SAP CPI via API Management |
|
2. | SAP CPI receives the OrderCreate XML message from Elemica and maps to SAP Sales Order in S/4HANA. To create the Sales Order, SAP CPI calls the custom API which is the scope of this functional specification | This is covered in Integration Process functional specification ERP-1138 - Getting issue details... STATUS |
3 | Sales Order is created in SAP S/4HANA based on the message received from SAP CPI |
Assumptions
- The custom Sales Order Create API will be called from SAP CPI and be able to lookup data from SAP S/4HANA to feed the target structure to create the sales order
- The source object and S/4HANA System target field mappings, including custom fields, will be updated based on mapping requirements in S/4HANA System.
- The Custom API should be able to map all source and target mappings to successfully create a sales order
Dependencies
- All configurations in S/4HANA from where the custom API should look up values should already be implemented before the interface is deployed.
- Connection between SAP CPI and S/4HANA already set up
- Required master data in S/4HANA already loaded
Security, Integrity and Controls
- Required authorisations to execute the custom API need to be defined.
- Existing secure connectivity for communication between SAP S/4HANA and SAP CPI will be applied.
Configuration Requirements
tbc
Special Requirements
tbc
new custom table to map Header DUNS and Body DUNS
Design Rationale
API Use
Custom API from API_SALES_ORDER_SRV_0001
Data Structure
The following fields will be used to provide the required data structure of the interface:
| Parent | Cardinality | Field | Description | Mandatory (Y/N) | Data Type | Notes |
|---|---|---|---|---|---|---|
| DocumentHeader | 1 | Segment not in referenced API | ||||
| DocumentIdentifier | N | String | ||||
| DocumentIdentifierDateTime | N | DateTime | ||||
| RequestingDocumentIdentifier | N | String | ||||
| RequestingDocumentDateTime | N | DateTime | ||||
| SenderPartnerName | Y | String | ||||
| SenderDUNS | Y | String | ||||
| SenderContactName | N | String | ||||
| SenderContactDescription | N | String | ||||
| SenderTelephoneNumberTelecomCountryCode | N | String | ||||
| SenderTelephoneNumberTelecomAreaCode | N | String | ||||
| SenderTelephoneNumberPhoneNumber | N | String | ||||
| SenderFaxNumberTelecomCountryCode | N | String | ||||
| SenderFaxNumberTelecomAreaCode | N | String | ||||
| SenderFaxNumberPhoneNumber | N | String | ||||
| SenderEmailAddress | N | String | ||||
| SenderAlternativeCommunicationMethod | N | String | ||||
| SenderAddressLine | N | String | ||||
| SenderCityName | N | String | ||||
| SenderStateProvince | N | String | ||||
| SenderPostalCode | N | String | ||||
| SenderPostalCountry | N | String | ||||
| SenderLocationCode | N | String | ||||
| SenderTaxIdentifierNumber | N | String | ||||
| SenderJurisdiction | N | String | ||||
| SenderTaxCertificateType | N | String | ||||
| SenderTaxCertificateNumber | N | string | ||||
| SenderTaxBasis | N | string | ||||
| SenderTaxRate | N | string | ||||
| SenderSenderURL | N | string | ||||
| ReceiverPartnerName | Y | string | ||||
| ReceiverDUNSCode | Y | String | ||||
| ReceiverContactName | N | String | ||||
| ReceiverContactDescription | N | String | ||||
| ReceiverTelephoneNumberTelecomCountryCode | N | String | ||||
| ReceiverTelephoneNumberTelecomAreaCode | N | String | ||||
| ReceiverTelephoneNumberPhoneNumber | N | String | ||||
| ReceiverFaxNumberTelecomCountryCode | N | String | ||||
| ReceiverFaxNumberTelecomAreaCode | N | String | ||||
| ReceiverFaxNumberPhoneNumber | N | String | ||||
| ReceiverEmailAddress | N | String | ||||
| ReceiverAlternativeCommunicationMethod | N | String | ||||
| ReceiverAddressLine | N | String | ||||
| ReceiverCityName | N | String | ||||
| ReceiverStateProvince | N | String | ||||
| ReceiverPostalCode | N | String | ||||
| ReceiverPostalCountry | N | String | ||||
| ReceiverLocationCode | N | String | ||||
| ReceiverTaxIdentifierNumber | N | String | ||||
| ReceiverJurisdiction | N | String | ||||
| ReceiverTaxCertificateType | N | String | ||||
| ReceiverTaxCertificateNumber | N | String | ||||
| ReceiverTaxBasis | N | String | ||||
| ReceiverTaxRate | N | String | ||||
| ReceiverSenderURL | N | String | ||||
| A_SalesOrder | 1 | |||||
| DsitributionChannel | Y | String | Not in source file. To be derived/fetched via custom logic to create Sales Order by API | |||
| OrganisationDivision | Y | String | Not in source file. To be derived/fetched via custom logic to create Sales Order by API | |||
| SalesOrderType | Y | String | Not in source file. To be derived/fetched via custom logic to create Sales Order by API | |||
| SalesOrganisation | Y | String | Not in source file. To be derived/fetched via custom logic to create Sales Order by API | |||
| UserStatus | Y | String | Not in source file. To be derived/fetched via custom logic to create Sales Order by API | |||
| CustomerPurchaseOrderType | Y | String | Not in source file. To be derived/fetched via custom logic to create Sales Order by API | |||
| PurchaseOrderByCustomer | Customer reference number that the customer uses to uniquely identify a purchasing document (for example, a sales inquiry or a purchase order) | Y | String | |||
| CustomerPurchaseOrderDate | Y | DateTime | ||||
| TransactionCurrency | The currency that applies to the sales order | N | String | |||
| ContractNumber | Customer reference number that the customer uses to uniquely identify a purchasing document (for example, a sales inquiry or a purchase order) | N | String | Not in referenced API | ||
| LanguageCode | N | String | Not in referenced API | |||
| RevisionNumber | N | String | Not in referenced API | |||
| ReleaseNumber | N | String | Not in referenced API | |||
| IncotermsClassification | Commonly used trading terms that comply with the standards established by the International Chamber of Commerce (ICC) | N | String | |||
| IncotermsLocation1 | Provides additional information for the primary Incoterm | N | String | |||
| CustomerPaymentTerms | N | String | ||||
| DiscountPercentage | N | String | Not in referenced API | |||
| DiscountAmount | N | String | Not in referenced API | |||
| DiscountDaysDue | N | String | Not in referenced API | |||
| DiscountsDueDate | N | DateTime | Not in referenced API | |||
| DeferredAmount | N | String | Not in referenced API | |||
| DeferedDueDate | N | DateTime | Not in referenced API | |||
| PercentDeferredPayable | N | String | Not in referenced API | |||
| Penalty | N | String | Not in referenced API | |||
| PurchaseOrderByShipToParty | N | String | ||||
| CountryOfFinalDestination | N | String | Not in referenced API | |||
| MarketPlaceIdentifier | N | String | Not in referenced API | |||
| MarketPlaceDocumentIdentifier | N | String | Not in referenced API | |||
| MarketPlaceReferenceItem | N | String | Not in referenced API | |||
| MarketPlaceSellerIdentifier | N | String | Not in referenced API | |||
| InvoiceCommunicationMode | N | String | Not in referenced API | |||
| BillingScheduleCode | N | String | Not in referenced API | |||
| A_SalesOrderHeaderPartner | 1 | |||||
| BuyerPartnerName | The customer who orders the goods or services. The sold-to party is contractually responsible for sales orders. | Y | String | Buyer = SoldtoParty. | ||
| BuyerPartnerCode | Y | String | ||||
| BuyerContactName | N | String | ||||
| BuyerContactDescription | N | String | ||||
| SellerPartnerName | N | String | ||||
| SellerPartnerCode | Y | String | ||||
| SellerContactName | N | String | ||||
| SellerContactDescription | N | String | ||||
| ShiptoPartnerName | N | String | ||||
| ShipToPartnerCode | Y | String | ||||
| PayerPartnerName | N | String | ||||
| PayerPartnerCode | N | String | ||||
| BilltoPartnerName | N | String | ||||
| BillToPartnerCode | N | String | ||||
| ShipperPartnerName | N | String | ||||
| ShipperPartnerCode | N | String | ||||
| ShipFromPartnerName | N | String | ||||
| ShipFromPartnerCode | N | String | ||||
| CarrierPartnerName | N | String | ||||
| CarrierPartnerCode | N | String | ||||
| A_SalesOrderPartnerAddress | 1 | BuyerTelephoneNumberTelecomCountryCode | N | String | ||
| BuyerTelephoneNumberTelecomAreaCode | N | String | ||||
| BuyerTelephoneNumberPhoneNumber | N | String | ||||
| BuyerFaxNumberTelecomCountryCode | N | String | ||||
| BuyerFaxNumberTelecomAreaCode | N | String | ||||
| BuyerFaxNumberPhoneNumber | N | String | ||||
| BuyerEmailAddress | N | String | ||||
| BuyerAlternativeCommunicationMethod | N | String | ||||
| BuyerAddressLine | N | String | ||||
| BuyerCityName | N | String | ||||
| BuyerStateProvince | N | String | ||||
| BuyerPostalCode | N | String | ||||
| BuyerPostalCountry | N | String | ||||
| BuyerLocationCode | N | String | ||||
| BuyerExternalReference | N | String | ||||
| BuyerTaxIdentifierNumber | N | String | ||||
| BuyerJurisdiction | N | String | ||||
| BuyerTaxCertificateType | N | String | ||||
| BuyerTaxCertificateNumber | N | String | ||||
| BuyerTaxBasis | N | String | ||||
| BuyerTaxRate | N | String | ||||
| BuyerSenderURL | N | String | ||||
| ShipToTelephoneNumberTelecomCountryCode | N | String | ||||
| ShipToTelephoneNumberTelecomAreaCode | N | String | ||||
| ShipToTelephoneNumberPhoneNumber | N | String | ||||
| ShipToFaxNumberTelecomCountryCode | N | String | ||||
| ShipToFaxNumberTelecomAreaCode | N | String | ||||
| ShipToFaxNumberPhoneNumber | N | String | ||||
| ShipToEmailAddress | N | String | ||||
| ShipToAlternativeCommunicationMethod | N | String | ||||
| ShipToAddressLine | N | String | ||||
| ShipToCityName | N | String | ||||
| ShipToStateProvince | N | String | ||||
| ShipToPostalCode | N | String | ||||
| ShipToPostalCountry | N | String | ||||
| ShipToLocationCode | N | String | ||||
| ShipToExternalReference | N | String | ||||
| ShipToTaxIdentifierNumber | N | String | ||||
| ShipToJurisdiction | N | String | ||||
| ShipToTaxCertificateType | N | String | ||||
| ShipToTaxCertificateNumber | N | String | ||||
| ShipToTaxBasis | N | String | ||||
| ShipToTaxRate | N | String | ||||
| ShipToSenderURL | N | String | ||||
| PayerTelephoneNumberTelecomCountryCode | N | String | ||||
| PayerTelephoneNumberTelecomAreaCode | N | String | ||||
| PayerTelephoneNumberPhoneNumber | N | String | ||||
| PayerFaxNumberTelecomCountryCode | N | String | ||||
| PayerFaxNumberTelecomAreaCode | N | String | ||||
| PayerFaxNumberPhoneNumber | N | String | ||||
| PayerEmailAddress | N | String | ||||
| PayerAlternativeCommunicationMethod | N | String | ||||
| PayerAddressLine | N | String | ||||
| PayerCityName | N | String | ||||
| PayerStateProvince | N | String | ||||
| PayerPostalCode | N | String | ||||
| PayerPostalCountry | N | String | ||||
| PayerLocationCode | N | String | ||||
| PayerExternalReference | N | String | ||||
| PayerTaxIdentifierNumber | N | String | ||||
| PayerJurisdiction | N | String | ||||
| PayerToTaxCertificateType | N | String | ||||
| PayerTaxCertificateNumber | N | String | ||||
| PayerTaxBasis | N | String | ||||
| PayerTaxRate | N | String | ||||
| PayerSenderURL | N | String | ||||
| AccountHolderName | N | String | ||||
| AccountNumber | N | String | ||||
| FinancialInstitution | N | String | ||||
| FinancialInstitutionDFINumber | N | String | ||||
| CreditCardNumber | N | String | ||||
| CreditCardType | N | String | ||||
| CreditCardExpirationDate | N | DateTime | ||||
| BillToTelephoneNumberTelecomCountryCode | N | String | ||||
| BillToTelephoneNumberTelecomAreaCode | N | String | ||||
| BillToTelephoneNumberPhoneNumber | N | String | ||||
| BillToFaxNumberTelecomCountryCode | N | String | ||||
| BillToFaxNumberTelecomAreaCode | N | String | ||||
| BillToFaxNumberPhoneNumber | N | String | ||||
| BillToEmailAddress | N | String | ||||
| BillToAlternativeCommunicationMethod | N | String | ||||
| BillToAddressLine | N | String | ||||
| BillToCityName | N | String | ||||
| BillToStateProvince | N | String | ||||
| BillToPostalCode | N | String | ||||
| BillToPostalCountry | N | String | ||||
| BillToLocationCode | N | String | ||||
| BillToExternalReference | N | String | ||||
| BillToTaxIdentifierNumber | N | String | ||||
| BillToJurisdiction | N | String | ||||
| BillToTaxCertificateType | N | String | ||||
| BillToTaxCertificateNumber | N | String | ||||
| BillToTaxBasis | N | String | ||||
| BillToTaxRate | N | String | ||||
| BillToSenderURL | N | String | ||||
| ShipFromTelephoneNumberTelecomCountryCode | N | String | ||||
| ShipFromTelephoneNumberTelecomAreaCode | N | String | ||||
| ShipFromTelephoneNumberPhoneNumber | N | String | ||||
| ShipFromFaxNumberTelecomCountryCode | N | String | ||||
| ShipFromFaxNumberTelecomAreaCode | N | String | ||||
| ShipFromFaxNumberPhoneNumber | N | String | ||||
| ShipFromEmailAddress | N | String | ||||
| ShipFromAlternativeCommunicationMethod | N | String | ||||
| ShipFromAddressLine | N | String | ||||
| ShipFromCityName | N | String | ||||
| ShipFromStateProvince | N | String | ||||
| ShipFromPostalCode | N | String | ||||
| ShipFromPostalCountry | N | String | ||||
| ShipFromLocationCode | N | String | ||||
| ShipFromExternalReference | N | String | ||||
| ShipFromTaxIdentifierNumber | N | String | ||||
| ShipFromJurisdiction | N | String | ||||
| ShipFromTaxCertificateType | N | String | ||||
| ShipFromTaxCertificateNumber | N | String | ||||
| ShipFromTaxBasis | N | String | ||||
| ShipFromTaxRate | N | String | ||||
| ShipFromSenderURL | N | String | ||||
| CarrierTelephoneNumberTelecomCountryCode | N | String | ||||
| CarrierTelephoneNumberTelecomAreaCode | N | String | ||||
| CarrierTelephoneNumberPhoneNumber | N | String | ||||
| CarrierFaxNumberTelecomCountryCode | N | String | ||||
| CarrierFaxNumberTelecomAreaCode | N | String | ||||
| CarrierFaxNumberPhoneNumber | N | String | ||||
| CarrierEmailAddress | N | String | ||||
| CarrierAlternativeCommunicationMethod | N | String | ||||
| CarrierAddressLine | N | String | ||||
| CarrierCityName | N | String | ||||
| CarrierStateProvince | N | String | ||||
| CarrierPostalCode | N | String | ||||
| CarrierPostalCountry | N | String | ||||
| CarrierLocationCode | N | String | ||||
| CarrierExternalReference | N | String | ||||
| CarrierTaxIdentifierNumber | N | String | ||||
| CarrierJurisdiction | N | String | ||||
| CarrierTaxCertificateType | N | String | ||||
| CarrierTaxCertificateNumber | N | String | ||||
| CarrierTaxBasis | N | String | ||||
| CarrierTaxRate | N | String | ||||
| CarrierSenderURL | N | String | ||||
| ShipperTelephoneNumberTelecomCountryCode | N | String | ||||
| ShipperTelephoneNumberTelecomAreaCode | N | String | ||||
| ShipperTelephoneNumberPhoneNumber | N | String | ||||
| ShipperFaxNumberTelecomCountryCode | N | String | ||||
| ShipperFaxNumberTelecomAreaCode | N | String | ||||
| ShipperFaxNumberPhoneNumber | N | String | ||||
| ShipperEmailAddress | N | String | ||||
| ShipperAlternativeCommunicationMethod | N | String | ||||
| ShipperAddressLine | N | String | ||||
| ShipperCityName | N | String | ||||
| ShipperStateProvince | N | String | ||||
| ShipperPostalCode | N | String | ||||
| ShipperPostalCountry | N | String | ||||
| ShipperLocationCode | N | String | ||||
| ShipperExternalReference | N | String | ||||
| ShipperTaxIdentifierNumber | N | String | ||||
| ShipperJurisdiction | N | String | ||||
| ShipperTaxCertificateType | N | String | ||||
| ShipperTaxCertificateNumber | N | String | ||||
| ShipperTaxBasis | N | String | ||||
| ShipperTaxRate | N | String | ||||
| ShipperSenderURL | N | String | ||||
| A_SalesOrderText | 1 to many | |||||
| Language (key) | The language key indicates the following:
| Y | String | |||
| LongTextID (key) | Y | String | ||||
| LongText | Y | String | ||||
| A_SalesOrderItem | 1 | |||||
| UnderlyingPurchaseOrderItem | N | String | ||||
| SalesOrderItem (key) | N | String | ||||
| LineItemHandlingInstruction | N | String | ||||
| MaterialByCustomer | Y | String | ||||
| MaterialByCustomerDescription | N | String | ||||
| ProductDescription | N | String | ||||
| ProductGradeDescription | N | String | ||||
| Material | M | String | ||||
| MaterialDescription | N | String | ||||
| ProductDescription | N | String | ||||
| ProductGradeDescription | N | String | ||||
| PurchaseOrderByCustomer | N | String | ||||
| ReferenceItem | N | String | ||||
| RequestedQuantity | The number or volume of materials specified for an item | N | String | |||
| RequestedQuantityISOUnit | N | String | ||||
| PackagingQuantity | N | String | ||||
| PackagingQuantityISOUnit | N | String | ||||
| EngineeringChangeOrderIdentifier | N | String | ||||
| BatchNumber | N | String | ||||
| CountryOfOriginCode | N | String | ||||
| IncotermsClassification | N | String | ||||
| IncotermsLocation1 | N | String | ||||
| TransportMethodCode | N | String | ||||
| LineItemPurposeCode | N | String | ||||
| BalanceItemFlag | N | String | ||||
| DeliveryTolerancesLowerLimit | N | String | ||||
| DeliveryTolerancesUpperLimit | N | String | ||||
| DeliveryTolerancesUnitofMeasure | N | String | ||||
| A_SalesOrderItemText | 1 to many | |||||
| Language (key) | N | String | ||||
| LongTextID (key) | N | String | ||||
| LongText | N | String | ||||
| A_SalesOrderItemPrElement | 1 | |||||
ConditionAmountPerUnit | N | String | ||||
| ConditionCurrency | N | String | |||
| ConditionRateValue | N | String | |||
| ConditionQuantityUnitofMeasureCode | N | String | |||
| A_SalesOrderScheduleLine | 1 |
| ||||
ScheduleDateRequestedDeliveryOn | N | DateTime | ||||
ScheduleDateConfirmedPickUpOn | N | DateTime | ||||
| A_SalesOrderItemPartner | 1 | |||||
| ShiptoPartnerName | N | String | ||||
| ShipToPartnerCode | Y | String | ||||
| BilltoPartnerName | N | String | ||||
| BillToPartnerCode | N | String | ||||
| ShipperPartnerName | N | String | ||||
| ShipperPartnerCode | N | String | ||||
| ShipFromPartnerName | N | String | ||||
| ShipFromPartnerCode | N | String | ||||
| CarrierPartnerName | N | String | ||||
| CarrierPartnerCode | N | String | ||||
| A_SalesOrderItemPartnerAddress | 1 |
| ||||
| ShipToTelephoneNumberTelecomCountryCode | N | String | ||||
| ShipToTelephoneNumberTelecomAreaCode | N | String | ||||
| ShipToTelephoneNumberPhoneNumber | N | String | ||||
| ShipToFaxNumberTelecomCountryCode | N | String | ||||
| ShipToFaxNumberTelecomAreaCode | N | String | ||||
| ShipToFaxNumberPhoneNumber | N | String | ||||
| ShipToEmailAddress | N | String | ||||
| ShipToAlternativeCommunicationMethod | N | String | ||||
| ShipToAddressLine | N | String | ||||
| ShipToCityName | N | String | ||||
| ShipToStateProvince | N | String | ||||
| ShipToPostalCode | N | String | ||||
| ShipToPostalCountry | N | String | ||||
| ShipToLocationCode | N | String | ||||
| ShipToExternalReference | N | String | ||||
| ShipToTaxIdentifierNumber | N | String | ||||
| ShipToJurisdiction | N | String | ||||
| ShipToTaxCertificateType | N | String | ||||
| ShipToTaxCertificateNumber | N | String | ||||
| ShipToTaxBasis | N | String | ||||
| ShipToTaxRate | N | String | ||||
| ShipToSenderURL | N | String | ||||
| BillToTelephoneNumberTelecomCountryCode | N | String | ||||
| BillToTelephoneNumberTelecomAreaCode | N | String | ||||
| BillToTelephoneNumberPhoneNumber | N | String | ||||
| BillToFaxNumberTelecomCountryCode | N | String | ||||
| BillToFaxNumberTelecomAreaCode | N | String | ||||
| BillToFaxNumberPhoneNumber | N | String | ||||
| BillToEmailAddress | N | String | ||||
| BillToAlternativeCommunicationMethod | N | String | ||||
| BillToAddressLine | N | String | ||||
| BillToCityName | N | String | ||||
| BillToStateProvince | N | String | ||||
| BillToPostalCode | N | String | ||||
| BillToPostalCountry | N | String | ||||
| BillToLocationCode | N | String | ||||
| BillToExternalReference | N | String | ||||
| BillToTaxIdentifierNumber | N | String | ||||
| BillToJurisdiction | N | String | ||||
| BillToTaxCertificateType | N | String | ||||
| BillToTaxCertificateNumber | N | String | ||||
| BillToTaxBasis | N | String | ||||
| BillToTaxRate | N | String | ||||
| BillToSenderURL | N | String | ||||
| ShipFromTelephoneNumberTelecomCountryCode | N | String | ||||
| ShipFromTelephoneNumberTelecomAreaCode | N | String | ||||
| ShipFromTelephoneNumberPhoneNumber | N | String | ||||
| ShipFromFaxNumberTelecomCountryCode | N | String | ||||
| ShipFromFaxNumberTelecomAreaCode | N | String | ||||
| ShipFromFaxNumberPhoneNumber | N | String | ||||
| ShipFromEmailAddress | N | String | ||||
| ShipFromAlternativeCommunicationMethod | N | String | ||||
| ShipFromAddressLine | N | String | ||||
| ShipFromCityName | N | String | ||||
| ShipFromStateProvince | N | String | ||||
| ShipFromPostalCode | N | String | ||||
| ShipFromPostalCountry | N | String | ||||
| ShipFromLocationCode | N | String | ||||
| ShipFromExternalReference | N | String | ||||
| ShipFromTaxIdentifierNumber | N | String | ||||
| ShipFromJurisdiction | N | String | ||||
| ShipFromTaxCertificateType | N | String | ||||
| ShipFromTaxCertificateNumber | N | String | ||||
| ShipFromTaxBasis | N | String | ||||
| ShipFromTaxRate | N | String | ||||
| ShipFromSenderURL | N | String | ||||
| CarrierTelephoneNumberTelecomCountryCode | N | String | ||||
| CarrierTelephoneNumberTelecomAreaCode | N | String | ||||
| CarrierTelephoneNumberPhoneNumber | N | String | ||||
| CarrierFaxNumberTelecomCountryCode | N | String | ||||
| CarrierFaxNumberTelecomAreaCode | N | String | ||||
| CarrierFaxNumberPhoneNumber | N | String | ||||
| CarrierEmailAddress | N | String | ||||
| CarrierAlternativeCommunicationMethod | N | String | ||||
| CarrierAddressLine | N | String | ||||
| CarrierCityName | N | String | ||||
| CarrierStateProvince | N | String | ||||
| CarrierPostalCode | N | String | ||||
| CarrierPostalCountry | N | String | ||||
| CarrierLocationCode | N | String | ||||
| CarrierExternalReference | N | String | ||||
| CarrierTaxIdentifierNumber | N | String | ||||
| CarrierJurisdiction | N | String | ||||
| CarrierTaxCertificateType | N | String | ||||
| CarrierTaxCertificateNumber | N | String | ||||
| CarrierTaxBasis | N | String | ||||
| CarrierTaxRate | N | String | ||||
| CarrierSenderURL | N | String | ||||
| ShipperTelephoneNumberTelecomCountryCode | N | String | ||||
| ShipperTelephoneNumberTelecomAreaCode | N | String | ||||
| ShipperTelephoneNumberPhoneNumber | N | String | ||||
| ShipperFaxNumberTelecomCountryCode | N | String | ||||
| ShipperFaxNumberTelecomAreaCode | N | String | ||||
| ShipperFaxNumberPhoneNumber | N | String | ||||
| ShipperEmailAddress | N | String | ||||
| ShipperAlternativeCommunicationMethod | N | String | ||||
| ShipperAddressLine | N | String | ||||
| ShipperCityName | N | String | ||||
| ShipperStateProvince | N | String | ||||
| ShipperPostalCode | N | String | ||||
| ShipperPostalCountry | N | String | ||||
| ShipperLocationCode | N | String | ||||
| ShipperExternalReference | N | String | ||||
| ShipperTaxIdentifierNumber | N | String | ||||
| ShipperJurisdiction | N | String | ||||
| ShipperTaxCertificateType | N | String | ||||
| ShipperTaxCertificateNumber | N | String | ||||
| ShipperTaxBasis | N | String | ||||
| ShipperTaxRate | N | String | ||||
| ShipperSenderURL | N | String |
Calculation and Mapping
Populate the table below to list the calculation and validation rules per field. Can be deleted if not needed.
Note for LA: if it is based on received value, ok in calculation table. if based on other logic not from received value, in processing logic
| Parent | Field | Rule Type | Rule Instruction |
|---|---|---|---|
| DocumentHeader | |||
| DocumentIdentifier | map to text | map to T010 (Elemica text ID) with tag "DocumentIdentifier" + <value> | |
| DocumentIdentifierDateTime | |||
| RequestingDocumentIdentifier | |||
| RequestingDocumentDateTime | map to Sales Order field | map to VBAK-POSEX | |
| SenderPartnerName | |||
| SenderDUNSCode | store in custom table as 'HeaderDUNS_Sender' | ||
| SenderContactName | |||
| SenderContactDescription | |||
| SenderTelephoneNumberTelecomCountryCode | |||
| SenderTelephoneNumberTelecomAreaCode | |||
| SenderTelephoneNumberPhoneNumber | |||
| SenderFaxNumberTelecomCountryCode | |||
| SenderFaxNumberTelecomAreaCode | |||
| SenderFaxNumberPhoneNumber | |||
| SenderEmailAddress | |||
| SenderAlternativeCommunicationMethod | |||
| SenderAddressLine | |||
| SenderCityName | |||
| SenderStateProvince | |||
| SenderPostalCode | |||
| SenderPostalCountry | |||
| SenderLocationCode | |||
| SenderTaxIdentifierNumber | |||
| SenderJurisdiction | |||
| SenderTaxCertificateType | |||
| SenderTaxCertificateNumber | |||
| SenderTaxBasis | |||
| SenderTaxRate | |||
| SenderSenderURL | |||
| ReceiverPartnerName | |||
| ReceiverDUNSCode | store in custom table 'HeaderDUNS_Receiver' | ||
| ReceiverContactName | |||
| ReceiverContactDescription | |||
| ReceiverTelephoneNumberTelecomCountryCode | |||
| ReceiverTelephoneNumberTelecomAreaCode | map to field | VBAP-AUGRU | |
| ReceiverTelephoneNumberPhoneNumber | |||
| ReceiverFaxNumberTelecomCountryCode | |||
| ReceiverFaxNumberTelecomAreaCode | |||
| ReceiverFaxNumberPhoneNumber | |||
| ReceiverEmailAddress | |||
| ReceiverAlternativeCommunicationMethod | |||
| ReceiverAddressLine | |||
| ReceiverCityName | |||
| ReceiverStateProvince | |||
| ReceiverPostalCode | |||
| ReceiverPostalCountry | |||
| ReceiverLocationCode | |||
| ReceiverTaxIdentifierNumber | |||
| ReceiverJurisdiction | |||
| ReceiverTaxCertificateType | |||
| ReceiverTaxCertificateNumber | |||
| ReceiverTaxBasis | |||
| ReceiverTaxRate | |||
| ReceiverSenderURL | |||
| A_SalesOrder | |||
| DsitributionChannel | |||
| OrganisationDivision | |||
| SalesOrderType | |||
| SalesOrganisation | |||
| UserStatus | |||
| CustomerPurchaseOrderType | |||
| PurchaseOrderByCustomer | |||
| CustomerPurchaseOrderDate | |||
| TransactionCurrency | |||
| ContractNumber | |||
| LanguageCode | |||
| RevisionNumber | |||
| ReleaseNumber | |||
| IncotermsClassification | |||
| IncotermsLocation1 | |||
| CustomerPaymentTerms | |||
| DiscountPercentage | |||
| DiscountAmount | |||
| DiscountDaysDue | |||
| DiscountsDueDate | |||
| DeferredAmount | |||
| DeferedDueDate | |||
| PercentDeferredPayable | |||
| Penalty | |||
| PurchaseOrderByShipToParty | |||
| CountryOfFinalDestination | |||
| MarketPlaceIdentifier | |||
| MarketPlaceDocumentIdentifier | |||
| MarketPlaceReferenceItem | |||
| MarketPlaceSellerIdentifier | |||
| InvoiceCommunicationMode | |||
| BillingScheduleCode | |||
| A_SalesOrderHeaderPartner | |||
| BuyerPartnerName | |||
| BuyerPartnerCode | |||
| BuyerContactName | |||
| BuyerContactDescription | |||
| SellerPartnerName | |||
| SellerPartnerCode | |||
| SellerContactName | |||
| SellerContactDescription | |||
| ShiptoPartnerName | |||
| ShipToPartnerCode | |||
| PayerPartnerName | |||
| PayerPartnerCode | |||
| BilltoPartnerName | |||
| BillToPartnerCode | |||
| ShipperPartnerName | |||
| ShipperPartnerCode | |||
| ShipFromPartnerName | |||
| ShipFromPartnerCode | |||
| CarrierPartnerName | |||
| CarrierPartnerCode | |||
| A_SalesOrderPartnerAddress | BuyerTelephoneNumberTelecomCountryCode | ||
| BuyerTelephoneNumberTelecomAreaCode | |||
| BuyerTelephoneNumberPhoneNumber | |||
| BuyerFaxNumberTelecomCountryCode | |||
| BuyerFaxNumberTelecomAreaCode | |||
| BuyerFaxNumberPhoneNumber | |||
| BuyerEmailAddress | |||
| BuyerAlternativeCommunicationMethod | |||
| BuyerAddressLine | |||
| BuyerCityName | |||
| BuyerStateProvince | |||
| BuyerPostalCode | |||
| BuyerPostalCountry | |||
| BuyerLocationCode | |||
| BuyerExternalReference | |||
| BuyerTaxIdentifierNumber | |||
| BuyerJurisdiction | |||
| BuyerTaxCertificateType | |||
| BuyerTaxCertificateNumber | |||
| BuyerTaxBasis | |||
| BuyerTaxRate | |||
| BuyerSenderURL | |||
| ShipToTelephoneNumberTelecomCountryCode | |||
| ShipToTelephoneNumberTelecomAreaCode | |||
| ShipToTelephoneNumberPhoneNumber | |||
| ShipToFaxNumberTelecomCountryCode | |||
| ShipToFaxNumberTelecomAreaCode | |||
| ShipToFaxNumberPhoneNumber | |||
| ShipToEmailAddress | |||
| ShipToAlternativeCommunicationMethod | |||
| ShipToAddressLine | |||
| ShipToCityName | |||
| ShipToStateProvince | |||
| ShipToPostalCode | |||
| ShipToPostalCountry | |||
| ShipToLocationCode | |||
| ShipToExternalReference | |||
| ShipToTaxIdentifierNumber | |||
| ShipToJurisdiction | |||
| ShipToTaxCertificateType | |||
| ShipToTaxCertificateNumber | |||
| ShipToTaxBasis | |||
| ShipToTaxRate | |||
| ShipToSenderURL | |||
| PayerTelephoneNumberTelecomCountryCode | |||
| PayerTelephoneNumberTelecomAreaCode | |||
| PayerTelephoneNumberPhoneNumber | |||
| PayerFaxNumberTelecomCountryCode | |||
| PayerFaxNumberTelecomAreaCode | |||
| PayerFaxNumberPhoneNumber | |||
| PayerEmailAddress | |||
| PayerAlternativeCommunicationMethod | |||
| PayerAddressLine | |||
| PayerCityName | |||
| PayerStateProvince | |||
| PayerPostalCode | |||
| PayerPostalCountry | |||
| PayerLocationCode | |||
| PayerExternalReference | |||
| PayerTaxIdentifierNumber | |||
| PayerJurisdiction | |||
| PayerToTaxCertificateType | |||
| PayerTaxCertificateNumber | |||
| PayerTaxBasis | |||
| PayerTaxRate | |||
| PayerSenderURL | |||
| AccountHolderName | |||
| AccountNumber | |||
| FinancialInstitution | |||
| FinancialInstitutionDFINumber | |||
| CreditCardNumber | |||
| CreditCardType | |||
| CreditCardExpirationDate | |||
| BillToTelephoneNumberTelecomCountryCode | |||
| BillToTelephoneNumberTelecomAreaCode | |||
| BillToTelephoneNumberPhoneNumber | |||
| BillToFaxNumberTelecomCountryCode | |||
| BillToFaxNumberTelecomAreaCode | |||
| BillToFaxNumberPhoneNumber | |||
| BillToEmailAddress | |||
| BillToAlternativeCommunicationMethod | |||
| BillToAddressLine | |||
| BillToCityName | |||
| BillToStateProvince | |||
| BillToPostalCode | |||
| BillToPostalCountry | |||
| BillToLocationCode | |||
| BillToExternalReference | |||
| BillToTaxIdentifierNumber | |||
| BillToJurisdiction | |||
| BillToTaxCertificateType | |||
| BillToTaxCertificateNumber | |||
| BillToTaxBasis | |||
| BillToTaxRate | |||
| BillToSenderURL | |||
| ShipFromTelephoneNumberTelecomCountryCode | |||
| ShipFromTelephoneNumberTelecomAreaCode | |||
| ShipFromTelephoneNumberPhoneNumber | |||
| ShipFromFaxNumberTelecomCountryCode | |||
| ShipFromFaxNumberTelecomAreaCode | |||
| ShipFromFaxNumberPhoneNumber | |||
| ShipFromEmailAddress | |||
| ShipFromAlternativeCommunicationMethod | |||
| ShipFromAddressLine | |||
| ShipFromCityName | |||
| ShipFromStateProvince | |||
| ShipFromPostalCode | |||
| ShipFromPostalCountry | |||
| ShipFromLocationCode | |||
| ShipFromExternalReference | |||
| ShipFromTaxIdentifierNumber | |||
| ShipFromJurisdiction | |||
| ShipFromTaxCertificateType | |||
| ShipFromTaxCertificateNumber | |||
| ShipFromTaxBasis | |||
| ShipFromTaxRate | |||
| ShipFromSenderURL | |||
| CarrierTelephoneNumberTelecomCountryCode | |||
| CarrierTelephoneNumberTelecomAreaCode | |||
| CarrierTelephoneNumberPhoneNumber | |||
| CarrierFaxNumberTelecomCountryCode | |||
| CarrierFaxNumberTelecomAreaCode | |||
| CarrierFaxNumberPhoneNumber | |||
| CarrierEmailAddress | |||
| CarrierAlternativeCommunicationMethod | |||
| CarrierAddressLine | |||
| CarrierCityName | |||
| CarrierStateProvince | |||
| CarrierPostalCode | |||
| CarrierPostalCountry | |||
| CarrierLocationCode | |||
| CarrierExternalReference | |||
| CarrierTaxIdentifierNumber | |||
| CarrierJurisdiction | |||
| CarrierTaxCertificateType | |||
| CarrierTaxCertificateNumber | |||
| CarrierTaxBasis | |||
| CarrierTaxRate | |||
| CarrierSenderURL | |||
| ShipperTelephoneNumberTelecomCountryCode | |||
| ShipperTelephoneNumberTelecomAreaCode | |||
| ShipperTelephoneNumberPhoneNumber | |||
| ShipperFaxNumberTelecomCountryCode | |||
| ShipperFaxNumberTelecomAreaCode | |||
| ShipperFaxNumberPhoneNumber | |||
| ShipperEmailAddress | |||
| ShipperAlternativeCommunicationMethod | |||
| ShipperAddressLine | |||
| ShipperCityName | |||
| ShipperStateProvince | |||
| ShipperPostalCode | |||
| ShipperPostalCountry | |||
| ShipperLocationCode | |||
| ShipperExternalReference | |||
| ShipperTaxIdentifierNumber | |||
| ShipperJurisdiction | |||
| ShipperTaxCertificateType | |||
| ShipperTaxCertificateNumber | |||
| ShipperTaxBasis | |||
| ShipperTaxRate | |||
| ShipperSenderURL | |||
| A_SalesOrderText | |||
| Language (key) | |||
| LongTextID (key) | |||
| LongText | |||
| A_SalesOrderItem | |||
| UnderlyingPurchaseOrderItem | |||
| SalesOrderItem (key) | |||
| LineItemHandlingInstruction | |||
| MaterialByCustomer | |||
| MaterialByCustomerDescription | |||
| ProductDescription | |||
| ProductGradeDescription | |||
| Material | |||
| MaterialDescription | |||
| ProductDescription | |||
| ProductGradeDescription | |||
| PurchaseOrderByCustomer | |||
| ReferenceItem | |||
| RequestedQuantity | |||
| RequestedQuantityISOUnit | |||
| PackagingQuantity | |||
| PackagingQuantityISOUnit | |||
| EngineeringChangeOrderIdentifier | |||
| BatchNumber | |||
| CountryOfOriginCode | |||
| IncotermsClassification | |||
| IncotermsLocation1 | |||
| TransportMethodCode | |||
| LineItemPurposeCode | |||
| BalanceItemFlag | |||
| DeliveryTolerancesLowerLimit | |||
| DeliveryTolerancesUpperLimit | |||
| DeliveryTolerancesUnitofMeasure | |||
| A_SalesOrderItemText | |||
| Language (key) | |||
| LongTextID (key) | |||
| LongText | |||
| A_SalesOrderItemPrElement | |||
ConditionAmountPerUnit | |||
ConditionCurrency | |||
ConditionRateValue | |||
ConditionQuantityUnitofMeasureCode | |||
| A_SalesOrderScheduleLine |
| ||
ScheduleDateRequestedDeliveryOn | |||
ScheduleDateConfirmedPickUpOn | |||
| A_SalesOrderItemPartner | |||
| ShiptoPartnerName | |||
| ShipToPartnerCode | |||
| BilltoPartnerName | |||
| BillToPartnerCode | |||
| ShipperPartnerName | |||
| ShipperPartnerCode | |||
| ShipFromPartnerName | |||
| ShipFromPartnerCode | |||
| CarrierPartnerName | |||
| CarrierPartnerCode | |||
| A_SalesOrderItemPartnerAddress |
| ||
| ShipToTelephoneNumberTelecomCountryCode | |||
| ShipToTelephoneNumberTelecomAreaCode | |||
| ShipToTelephoneNumberPhoneNumber | |||
| ShipToFaxNumberTelecomCountryCode | |||
| ShipToFaxNumberTelecomAreaCode | |||
| ShipToFaxNumberPhoneNumber | |||
| ShipToEmailAddress | |||
| ShipToAlternativeCommunicationMethod | |||
| ShipToAddressLine | |||
| ShipToCityName | |||
| ShipToStateProvince | |||
| ShipToPostalCode | |||
| ShipToPostalCountry | |||
| ShipToLocationCode | |||
| ShipToExternalReference | |||
| ShipToTaxIdentifierNumber | |||
| ShipToJurisdiction | |||
| ShipToTaxCertificateType | |||
| ShipToTaxCertificateNumber | |||
| ShipToTaxBasis | |||
| ShipToTaxRate | |||
| ShipToSenderURL | |||
| BillToTelephoneNumberTelecomCountryCode | |||
| BillToTelephoneNumberTelecomAreaCode | |||
| BillToTelephoneNumberPhoneNumber | |||
| BillToFaxNumberTelecomCountryCode | |||
| BillToFaxNumberTelecomAreaCode | |||
| BillToFaxNumberPhoneNumber | |||
| BillToEmailAddress | |||
| BillToAlternativeCommunicationMethod | |||
| BillToAddressLine | |||
| BillToCityName | |||
| BillToStateProvince | |||
| BillToPostalCode | |||
| BillToPostalCountry | |||
| BillToLocationCode | |||
| BillToExternalReference | |||
| BillToTaxIdentifierNumber | |||
| BillToJurisdiction | |||
| BillToTaxCertificateType | |||
| BillToTaxCertificateNumber | |||
| BillToTaxBasis | |||
| BillToTaxRate | |||
| BillToSenderURL | |||
| ShipFromTelephoneNumberTelecomCountryCode | |||
| ShipFromTelephoneNumberTelecomAreaCode | |||
| ShipFromTelephoneNumberPhoneNumber | |||
| ShipFromFaxNumberTelecomCountryCode | |||
| ShipFromFaxNumberTelecomAreaCode | |||
| ShipFromFaxNumberPhoneNumber | |||
| ShipFromEmailAddress | |||
| ShipFromAlternativeCommunicationMethod | |||
| ShipFromAddressLine | |||
| ShipFromCityName | |||
| ShipFromStateProvince | |||
| ShipFromPostalCode | |||
| ShipFromPostalCountry | |||
| ShipFromLocationCode | |||
| ShipFromExternalReference | |||
| ShipFromTaxIdentifierNumber | |||
| ShipFromJurisdiction | |||
| ShipFromTaxCertificateType | |||
| ShipFromTaxCertificateNumber | |||
| ShipFromTaxBasis | |||
| ShipFromTaxRate | |||
| ShipFromSenderURL | |||
| CarrierTelephoneNumberTelecomCountryCode | |||
| CarrierTelephoneNumberTelecomAreaCode | |||
| CarrierTelephoneNumberPhoneNumber | |||
| CarrierFaxNumberTelecomCountryCode | |||
| CarrierFaxNumberTelecomAreaCode | |||
| CarrierFaxNumberPhoneNumber | |||
| CarrierEmailAddress | |||
| CarrierAlternativeCommunicationMethod | |||
| CarrierAddressLine | |||
| CarrierCityName | |||
| CarrierStateProvince | |||
| CarrierPostalCode | |||
| CarrierPostalCountry | |||
| CarrierLocationCode | |||
| CarrierExternalReference | |||
| CarrierTaxIdentifierNumber | |||
| CarrierJurisdiction | |||
| CarrierTaxCertificateType | |||
| CarrierTaxCertificateNumber | |||
| CarrierTaxBasis | |||
| CarrierTaxRate | |||
| CarrierSenderURL | |||
| ShipperTelephoneNumberTelecomCountryCode | |||
| ShipperTelephoneNumberTelecomAreaCode | |||
| ShipperTelephoneNumberPhoneNumber | |||
| ShipperFaxNumberTelecomCountryCode | |||
| ShipperFaxNumberTelecomAreaCode | |||
| ShipperFaxNumberPhoneNumber | |||
| ShipperEmailAddress | |||
| ShipperAlternativeCommunicationMethod | |||
| ShipperAddressLine | |||
| ShipperCityName | |||
| ShipperStateProvince | |||
| ShipperPostalCode | |||
| ShipperPostalCountry | |||
| ShipperLocationCode | |||
| ShipperExternalReference | |||
| ShipperTaxIdentifierNumber | |||
| ShipperJurisdiction | |||
| ShipperTaxCertificateType | |||
| ShipperTaxCertificateNumber | |||
| ShipperTaxBasis | |||
| ShipperTaxRate | |||
| ShipperSenderURL |
Processing Logic
Describe the Customs DUNS table
| Field | |||
|---|---|---|---|
describe the custom table for the header and body DUNS
how the header DUNS is fetched (which field in XML) and where it is stored
EDPAR look ups
where Partner addresses are stored in S/4 to be used during orderresponse
As API field mapping is not sufficient, we need to add logic to populate these fields to create the sales order
| Field | Logic to populate field |
|---|---|
| SalesOrganization | |
| DistributionChannel | |
| Division | |
| SalesOrderType | |
| UserStatus |
Delta or Full Load Requirements
Interface Alert & Monitoring
Language Requirements
User Interface Requirements
Sequencing
Volumetrics
Performance Consideration
Error Handling
Testing
How to Test
Test Conditions and Expected Results
| ID | Condition | Expected Results |
|---|---|---|
Test Considerations/Dependencies
Other Information
Development Details
Package
| Package Name | Parent Package |
|---|---|
Other Development Objects
| Object Type | Object Name | Purpose/High Level Logic | Design Rationale Reference |
|---|---|---|---|