| Status | |
|---|---|
| Owner | ABOLAJI-ext, Luqman |
| Stakeholders | |
| Jira Request ID | |
| Jira Development ID |
| Implementing System | SAP S/4HANA |
|---|---|
| Invoked by/Invokes | ERP-1120 Integration Process - Order Response Interface from S/4HANA to Elemica |
| Business Process Reference | 02.04.02.01. Manage Standard Sales Order |
Some of the EDI customers requires an acknowledgement/response when their Sales Order is successfully created in Syensqo's S/4HANA system.
For this, the OrderResponse message is triggered from the Sales Order in Syensqo's S/4HANA system which calls the custom API to send the XML via SAP CPI to Elemica (the EDI service provider system).
The purpose of this functional specification is to create the custom API for the trigger and generation of the OrderResponse message from a sales order in S/4HANA
This System Interface, a custom implementation in SAP S/4HANA,
The standard SAP Sales Order API is unable to support the above functions, hence the need for a custom API.

Step | Description | Comment |
|---|---|---|
1 | Sales Order event triggers the custom Sales Order Response API to send Sales Order to SAP CPI based on defined structure. Events that could trigger this are Creation of Sales Order and Specific changes to a Sales Order | |
2 | SAP CPI receives the custom Sales Order ResponseAPI and translates the message to a cXML format | This is covered in Integration Process functional specification ERP-1120 Integration Process - Order Response Interface from S/4HANA to Elemica |
3 | Via API management, SAP CPI pushes the xXML format of the sales order to Elemica |
Specify any special requirements or considerations that may impact the interface based on specific locations, regulatory compliance or system limitations. Clearly outline requirements e.g. localization rules for countries like China
N/A
This template section may be used to specify the custom API design. The requirement can be for an API provider which means the API will be designed in the system or can be for an API consumer which means that an API will be consumed in the system.
Custom API based on CO_SDSLS_ESR_SALES_ORDER_NOTIF
| Parent | Cardinality | Field | Description | Mandatory (Y/N) | Data Type |
| A_SalesOrderHeader | 1 | ||||
| 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 | |||
| ReceiverDUNS | 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 | |||
| PurchaseOrderTypeCode | Y | String | |||
| CustomerPurchaseOrder | 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 | |||
| PurchaseOrderReferenceItem | N | String | |||
| 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 | ||
| LanguageCode | N | String | |||
| RevisionNumber | N | String | |||
| ReleaseNumber | N | String | |||
| SalesOrderReference | Y | String | |||
| SalesOrderReferenceItem | N | String | |||
| 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 | |||
| PaymentTermsBasisDateCode | N | DateTime | |||
| PaymentTermsBasisDate | N | String | |||
| DiscountPercentage | N | String | |||
| DiscountAmount | N | String | |||
| DiscountDaysDue | N | String | |||
| DiscountsDueDate | N | DateTime | |||
| DeferredAmount | N | String | |||
| DeferedDueDate | N | DateTime | |||
| PercentDeferredPayable | N | String | |||
| Penalty | N | String | |||
| ShipWithPurchaseOrder | N | String | |||
| CountryOfFinalDestination | N | String | |||
| MarketPlaceIdentifier | N | String | |||
| MarketPlaceDocumentIdentifier | N | String | |||
| MarketPlaceReferenceItem | N | String | |||
| MarketPlaceSellerIdentifier | N | String | |||
| InvoiceCommunicationMode | N | String | |||
| BillingScheduleCode | N | String | |||
| PurchaseOrderResponseReasonCode | N | String | |||
| BuyerPartnerName | The customer who orders the goods or services. The sold-to party is contractually responsible for sales orders. | Y | String | ||
| 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 | |||
| 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 | ||||
| CustomerRequiredInstructions | N | String | |||
| ShipperInstructions | N | String | |||
| ConsigneeInstructions | N | String | |||
| CarrierInstructions | N | String | |||
| ImportInstruction | N | String | |||
| CustomerServiceInstructions | N | String | |||
| RoutingInstruction | N | String | |||
| A_SalesOrderItem | 1 | ||||
| LineItemNumber | N | String | |||
| PurchaseOrderLineItemNumber | 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 | |||
| SalesOrderReference | N | String | |||
| SalesOrderItemReferenceItem | N | String | |||
| SalesOrderItemNumber | 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 | |||
| ChangeAcknowledgementFlag | N | String | |||
| LineItemStatus | N | String | |||
| LineStatusCode | N | String | |||
| LineItemPurposeCode | N | String | |||
| ItemShiptoPartnerName | N | String | |||
| ItemShipToPartnerCode | Y | String | |||
| ItemBilltoPartnerName | N | String | |||
| ItemBillToPartnerCode | N | String | |||
| ItemShipperPartnerName | N | String | |||
| ItemShipperPartnerCode | N | String | |||
| ItemShipFromPartnerName | N | String | |||
| ItemShipFromPartnerCode | N | String | |||
| ItemCarrierPartnerName | N | String | |||
| ItemCarrierPartnerCode | N | String | |||
| ItemShipToTelephoneNumberTelecomCountryCode | N | String | |||
| ItemShipToTelephoneNumberTelecomAreaCode | N | String | |||
| ItemShipToTelephoneNumberPhoneNumber | N | String | |||
| ItemShipToFaxNumberTelecomCountryCode | N | String | |||
| ItemShipToFaxNumberTelecomAreaCode | N | String | |||
| ItemShipToFaxNumberPhoneNumber | N | String | |||
| ItemShipToEmailAddress | N | String | |||
| ItemShipToAlternativeCommunicationMethod | N | String | |||
| ItemShipToAddressLine | N | String | |||
| ItemShipToCityName | N | String | |||
| ItemShipToStateProvince | N | String | |||
| ItemShipToPostalCode | N | String | |||
| ItemShipToPostalCountry | N | String | |||
| ItemShipToLocationCode | N | String | |||
| ItemShipToExternalReference | N | String | |||
| ItemShipToTaxIdentifierNumber | N | String | |||
| ItemShipToJurisdiction | N | String | |||
| ItemShipToTaxCertificateType | N | String | |||
| ItemShipToTaxCertificateNumber | N | String | |||
| ItemShipToTaxBasis | N | String | |||
| ItemShipToTaxRate | N | String | |||
| ItemShipToSenderURL | N | String | |||
| ItemBillToTelephoneNumberTelecomCountryCode | N | String | |||
| ItemBillToTelephoneNumberTelecomAreaCode | N | String | |||
| ItemBillToTelephoneNumberPhoneNumber | N | String | |||
| ItemBillToFaxNumberTelecomCountryCode | N | String | |||
| ItemBillToFaxNumberTelecomAreaCode | N | String | |||
| ItemBillToFaxNumberPhoneNumber | N | String | |||
| ItemBillToEmailAddress | N | String | |||
| ItemBillToAlternativeCommunicationMethod | N | String | |||
| ItemBillToAddressLine | N | String | |||
| ItemBillToCityName | N | String | |||
| ItemBillToStateProvince | N | String | |||
| ItemBillToPostalCode | N | String | |||
| ItemBillToPostalCountry | N | String | |||
| ItemBillToLocationCode | N | String | |||
| ItemBillToExternalReference | N | String | |||
| ItemBillToTaxIdentifierNumber | N | String | |||
| ItemBillToJurisdiction | N | String | |||
| ItemBillToTaxCertificateType | N | String | |||
| ItemBillToTaxCertificateNumber | N | String | |||
| ItemBillToTaxBasis | N | String | |||
| ItemBillToTaxRate | N | String | |||
| ItemBillToSenderURL | N | String | |||
| ItemShipFromTelephoneNumberTelecomCountryCode | N | String | |||
| ItemShipFromTelephoneNumberTelecomAreaCode | N | String | |||
| ItemShipFromTelephoneNumberPhoneNumber | N | String | |||
| ItemShipFromFaxNumberTelecomCountryCode | N | String | |||
| ItemShipFromFaxNumberTelecomAreaCode | N | String | |||
| ItemShipFromFaxNumberPhoneNumber | N | String | |||
| ItemShipFromEmailAddress | N | String | |||
| ItemShipFromAlternativeCommunicationMethod | N | String | |||
| ItemShipFromAddressLine | N | String | |||
| ItemShipFromCityName | N | String | |||
| ItemShipFromStateProvince | N | String | |||
| ItemShipFromPostalCode | N | String | |||
| ItemShipFromPostalCountry | N | String | |||
| ItemShipFromLocationCode | N | String | |||
| ItemShipFromExternalReference | N | String | |||
| ItemShipFromTaxIdentifierNumber | N | String | |||
| ItemShipFromJurisdiction | N | String | |||
| ItemShipFromTaxCertificateType | N | String | |||
| ItemShipFromTaxCertificateNumber | N | String | |||
| ItemShipFromTaxBasis | N | String | |||
| ItemShipFromTaxRate | N | String | |||
| ItemShipFromSenderURL | N | String | |||
| ItemCarrierTelephoneNumberTelecomCountryCode | N | String | |||
| ItemCarrierTelephoneNumberTelecomAreaCode | N | String | |||
| ItemCarrierTelephoneNumberPhoneNumber | N | String | |||
| ItemCarrierFaxNumberTelecomCountryCode | N | String | |||
| ItemCarrierFaxNumberTelecomAreaCode | N | String | |||
| ItemCarrierFaxNumberPhoneNumber | N | String | |||
| ItemCarrierEmailAddress | N | String | |||
| ItemCarrierAlternativeCommunicationMethod | N | String | |||
| ItemCarrierAddressLine | N | String | |||
| ItemCarrierCityName | N | String | |||
| ItemCarrierStateProvince | N | String | |||
| ItemCarrierPostalCode | N | String | |||
| ItemCarrierPostalCountry | N | String | |||
| ItemCarrierLocationCode | N | String | |||
| ItemCarrierExternalReference | N | String | |||
| ItemCarrierTaxIdentifierNumber | N | String | |||
| ItemCarrierJurisdiction | N | String | |||
| ItemCarrierTaxCertificateType | N | String | |||
| ItemCarrierTaxCertificateNumber | N | String | |||
| ItemCarrierTaxBasis | N | String | |||
| ItemCarrierTaxRate | N | String | |||
| ItemCarrierSenderURL | N | String | |||
| ItemShipperTelephoneNumberTelecomCountryCode | N | String | |||
| ItemShipperTelephoneNumberTelecomAreaCode | N | String | |||
| ItemShipperTelephoneNumberPhoneNumber | N | String | |||
| ItemShipperFaxNumberTelecomCountryCode | N | String | |||
| ItemShipperFaxNumberTelecomAreaCode | N | String | |||
| ItemShipperFaxNumberPhoneNumber | N | String | |||
| ItemShipperEmailAddress | N | String | |||
| ItemShipperAlternativeCommunicationMethod | N | String | |||
| ItemShipperAddressLine | N | String | |||
| ItemShipperCityName | N | String | |||
| ItemShipperStateProvince | N | String | |||
| ItemShipperPostalCode | N | String | |||
| ItemShipperPostalCountry | N | String | |||
| ItemShipperLocationCode | N | String | |||
| ItemShipperExternalReference | N | String | |||
| ItemShipperTaxIdentifierNumber | N | String | |||
| ItemShipperJurisdiction | N | String | |||
| ItemShipperTaxCertificateType | N | String | |||
| ItemShipperTaxCertificateNumber | N | String | |||
| ItemShipperTaxBasis | N | String | |||
| ItemShipperTaxRate | N | String | |||
| ItemShipperSenderURL | N | String | |||
| A_SalesOrderItemText | 1 to many | ||||
| CustomerRequiredInstructions | N | String | |||
| ShipperInstructions | N | String | |||
| ConsigneeInstructions | N | String | |||
| CarrierInstructions | N | String | |||
| ImportInstruction | N | String | |||
| CustomerServiceInstructions | N | String | |||
| RoutingInstruction | N | String | |||
| A_SalesOrderItemPrElement | 1 | ||||
| PricePerUnit | N | String | |||
| PriceCurrencyCode | N | String | |||
| A_SalesOrderScheduleLine | 1 | ||||
| ScheduleDateConfirmedDeliveryOn | N | DateTime | |||
| ScheduleDateConfirmedShipOn | N | DateTime | |||
| ScheduleDateConfirmedShipBy | N | DateTime | |||
| ScheduleDateConfirmedPickUpby | N | DateTime | |||
Populate the table below to list the calculation and validation rules per field. Can be deleted if not needed.
| Parent | Field | Rule Type | Rule Instruction (Field/TextID to map from) | |
| A_SalesOrderHeaderHeader | DocumentIdentifier | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | |
| DocumentIdentifierDateTime | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| RequestingDocumentIdentifier | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| RequestingDocumentDateTime | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| SenderPartnerName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverPartnerName> | ||
| SenderDUNS | map from ZL2C_DUNS cusfrom table | ReceiverDUNS | ||
| SenderContactName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverContactName> | ||
| SenderContactDescription | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverContactDescriptione> | ||
| SenderTelephoneNumberTelecomCountryCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTelephoneNumberTelecomCountryCode> | ||
| SenderTelephoneNumberTelecomAreaCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTelephoneNumberTelecomAreaCode> | ||
| SenderTelephoneNumberPhoneNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTelephoneNumberPhoneNumber> | ||
| SenderFaxNumberTelecomCountryCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverFaxNumberTelecomCountryCode> | ||
| SenderFaxNumberTelecomAreaCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverFaxNumberTelecomAreaCode> | ||
| SenderFaxNumberPhoneNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverFaxNumberPhoneNumber> | ||
| SenderEmailAddress | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverEmailAddress> | ||
| SenderAlternativeCommunicationMethod | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverAlternativeCommunicationMethod> | ||
| SenderAddressLine | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverAddressLine> | ||
| SenderCityName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverCityName> | ||
| SenderStateProvince | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverStateProvince> | ||
| SenderPostalCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverPostalCode> | ||
| SenderPostalCountry | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverPostalCountry> | ||
| SenderLocationCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverLocationCode> | ||
| SenderTaxIdentifierNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTaxIdentifierNumber> | ||
| SenderJurisdiction | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverJurisdiction> | ||
| SenderTaxCertificateType | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTaxCertificateType> | ||
| SenderTaxCertificateNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTaxCertificateNumber> | ||
| SenderTaxBasis | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTaxBasis> | ||
| SenderTaxRate | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverTaxRate> | ||
| SenderSenderURL | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <ReceiverReceiverURL> | ||
| ReceiverPartnerName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderPartnerName> | ||
| ReceiverDUNS | map from ZL2C_DUNS cusfrom table | SenderDUNS | ||
| ReceiverContactName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderContactName> | ||
| ReceiverContactDescription | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderContactDescription> | ||
| ReceiverTelephoneNumberTelecomCountryCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTelephoneNumberTelecomCountryCode> | ||
| ReceiverTelephoneNumberTelecomAreaCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTelephoneNumberTelecomAreaCode> | ||
| ReceiverTelephoneNumberPhoneNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTelephoneNumberPhoneNumber> | ||
| ReceiverFaxNumberTelecomCountryCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderFaxNumberTelecomCountryCode> | ||
| ReceiverFaxNumberTelecomAreaCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderFaxNumberTelecomAreaCode> | ||
| ReceiverFaxNumberPhoneNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderFaxNumberPhoneNumber> | ||
| ReceiverEmailAddress | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderEmailAddress> | ||
| ReceiverAlternativeCommunicationMethod | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderAlternativeCommunicationMethod> | ||
| ReceiverAddressLine | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderAddressLine> | ||
| ReceiverCityName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderCityName> | ||
| ReceiverStateProvince | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderStateProvince> | ||
| ReceiverPostalCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderPostalCode> | ||
| ReceiverPostalCountry | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderPostalCountry> | ||
| ReceiverLocationCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderLocationCode> | ||
| ReceiverTaxIdentifierNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTaxIdentifierNumber> | ||
| ReceiverJurisdiction | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderJurisdiction> | ||
| ReceiverTaxCertificateType | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTaxCertificateType> | ||
| ReceiverTaxCertificateNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTaxCertificateNumber> | ||
| ReceiverTaxBasis | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTaxBasis> | ||
| ReceiverTaxRate | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderTaxRate | ||
| ReceiverSenderURL | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <SenderSenderURL> | ||
| PurchaseOrderTypeCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| CustomerPurchaseOrder | map from sales order field | VBAK-BSTNK | ||
| CustomerPurchaseOrderDate | map from sales order field | VBAK-BSTDK | ||
| PurchaseOrderReferenceItem | ||||
| TransactionCurrency | map from sales order field | VBAK-WAERK | ||
| ContractNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| LanguageCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| RevisionNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| ReleaseNumber | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| SalesOrderReference | map from sales order field | VBAK-VBELN | ||
| SalesOrderItemReferenceItem | ||||
| IncotermsClassification | map from sales order field | VBKD-INCO1 | ||
| IncotermsLocation1 | map from sales order field | VBKD-INCO2_L | ||
| CustomerPaymentTerms | map from sales order field | VBKD-ZTERM | ||
| PaymentTermsBasisDateCode | not mapped | |||
| PaymentTermsBasisDate | not mapped | |||
| DiscountPercentage | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| DiscountAmount | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| DiscountDaysDue | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| DiscountsDueDate | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| DeferredAmount | not mapped | |||
| DeferedDueDate | not mapped | |||
| PercentDeferredPayable | not mapped | |||
| Penalty | not mapped | |||
| ShipWithPurchaseOrder | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| CountryOfFinalDestination | map from text + logic | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> If text does not exist, use country of the shipto Party Country of ShiptoParty: KNA1-LAND1 where KNA1-KUNNR = VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = SH | ||
| MarketPlaceIdentifier | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| MarketPlaceDocumentIdentifier | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| MarketPlaceReferenceItem | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| MarketPlaceSellerIdentifier | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| InvoiceCommunicationMode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| BillingScheduleCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| PurchaseOrderResponseReasonCode | ||||
| BuyerPartnerName | map from sales order | KNA1-NAME1 where KNA1-KUNNR = SoldtoParty (see Processing Logic section) | ||
| BuyerPartnerCode | See Partner Look Up Logic in Processing Logic section | |||
| BuyerContactName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| BuyerContactDescription | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| SellerPartnerName | map from sales order | TVKO-VTEXT where TVKO-VKORG = VBAK-VKORG | ||
| SellerPartnerCode | see SellerPartnerCode Logic Section | |||
| SellerContactName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| SellerContactDescription | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| ShiptoPartnerName | map from sales order | KNA1-NAME1 where KNA1-KUNNR = ShipToParty (see Processing Logic section) | ||
| ShipToPartnerCode | See Partner Look Up Logic in Processing Logic section | |||
| PayerPartnerName | map from sales order | KNA1-NAME1 where KNA1-KUNNR = Payer (see Processing Logic section) | ||
| PayerPartnerCode | See Partner Look Up Logic in Processing Logic section | |||
| BilltoPartnerName | map from sales order | KNA1-NAME1 where KNA1-KUNNR = BillToParty (see Processing Logic section) | ||
| BillToPartnerCode | See Partner Look Up Logic in Processing Logic section | |||
| ShipperPartnerName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| ShipperPartnerCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| ShipFromPartnerName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| ShipFromPartnerCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| CarrierPartnerName | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| CarrierPartnerCode | map from text | From text VBBK-Z999: Fetch <value> where 'Label> = <Field> | ||
| BuyerTelephoneNumberTelecomCountryCode | not mapped | |||
| BuyerTelephoneNumberTelecomAreaCode | not mapped | |||
| BuyerTelephoneNumberPhoneNumber | map from sales order | ADR2-TEL_NUMBER where ADRC-ADDRNUMBER = SoldToAddressNumber | ||
| BuyerFaxNumberTelecomCountryCode | not mapped | |||
| BuyerFaxNumberTelecomAreaCode | not mapped | |||
| BuyerFaxNumberPhoneNumber | map from sales order | ADR3-FAXNR_LONG where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerEmailAddress | map from sales order | ADR6-SMTP_ADDR where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerAlternativeCommunicationMethod | not mapped | |||
| BuyerAddressLine | map from sales order | ADRC-HOUSE_NUM1 where ADRC-ADDRNUMBER= SoldToAddressNumber " " ADRC-STREET where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerCityName | map from sales order | ADRC-CITY1 where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerStateProvince | map from sales order | ADRC-REGION where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerPostalCode | map from sales order | ADRC-POST_CODE1 where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerPostalCountry | map from sales order | ADRC-COUNTRY where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerLocationCode | map from sales order | KNA1-LOCCO where KNA1-KUNNR = SoldToParty | ||
| BuyerExternalReference | not mapped | |||
| BuyerTaxIdentifierNumber | map from sales order | DFKKBPTAXNUM_TAXNUM where DFKKBPTAXNUM_PARTNER = BUT000_PARTNER BUT000_PARTNER: BUT000_PARTNER where BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID where CVI_CUST_LINK_CUSTOMER = SoldToParty | ||
| BuyerJurisdiction | map from sales order | ADRC-TAXJURCODE where ADRC-ADDRNUMBER= SoldToAddressNumber | ||
| BuyerTaxCertificateType | not mapped | |||
| BuyerTaxCertificateNumber | not mapped | |||
| BuyerTaxBasis | not mapped | |||
| BuyerTaxRate | not mapped | |||
| BuyerSenderURL | map from text | ADR12-URI_ADDR where ADR12-ADDRNUMBER= SoldToAddressNumber | ||
| ShipToTelephoneNumberTelecomCountryCode | not mapped | |||
| ShipToTelephoneNumberTelecomAreaCode | not mapped | |||
| ShipToTelephoneNumberPhoneNumber | map from sales order | ADR2-TEL_NUMBER where ADRC-ADDRNUMBER = SToAddressNumber | ||
| ShipToFaxNumberTelecomCountryCode | not mapped | |||
| ShipToFaxNumberTelecomAreaCode | not mapped | |||
| ShipToFaxNumberPhoneNumber | map from sales order | ADR3-FAXNR_LONG where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToEmailAddress | map from sales order | ADR6-SMTP_ADDR where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToAlternativeCommunicationMethod | not mapped | |||
| ShipToAddressLine | map from sales order | ADRC-HOUSE_NUM1 where ADRC-ADDRNUMBER= ShipToAddressNumber " " ADRC-STREET where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToCityName | map from sales order | ADRC-CITY1 where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToStateProvince | map from sales order | ADRC-REGION where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToPostalCode | map from sales order | ADRC-POST_CODE1 where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToPostalCountry | map from sales order | ADRC-COUNTRY where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToLocationCode | map from sales order | KNA1-LOCCO where KNA1-KUNNR = ShipToParty | ||
| ShipToExternalReference | not mapped | |||
| ShipToTaxIdentifierNumber | map from sales order | DFKKBPTAXNUM_TAXNUM where DFKKBPTAXNUM_PARTNER = BUT000_PARTNER BUT000_PARTNER: BUT000_PARTNER where BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID where CVI_CUST_LINK_CUSTOMER = ShipToParty | ||
| ShipToJurisdiction | map from sales order | ADRC-TAXJURCODE where ADRC-ADDRNUMBER= ShipToAddressNumber | ||
| ShipToTaxCertificateType | not mapped | |||
| ShipToTaxCertificateNumber | not mapped | |||
| ShipToTaxBasis | not mapped | |||
| ShipToTaxRate | not mapped | |||
| ShipToSenderURL | map from sales order | ADR12-URI_ADDR where ADR12-ADDRNUMBER= SoldToAddressNumber | ||
| PayerTelephoneNumberTelecomCountryCode | not mapped | |||
| PayerTelephoneNumberTelecomAreaCode | not mapped | |||
| PayerTelephoneNumberPhoneNumber | map from sales order | ADR2-TEL_NUMBER where ADRC-ADDRNUMBER = PayerAddressNumber | ||
| PayerFaxNumberTelecomCountryCode | not mapped | |||
| PayerFaxNumberTelecomAreaCode | not mapped | |||
| PayerFaxNumberPhoneNumber | map from sales order | ADR3-FAXNR_LONG where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerEmailAddress | map from sales order | ADR6-SMTP_ADDR where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerAlternativeCommunicationMethod | not mapped | |||
| PayerAddressLine | map from sales order | ADRC-HOUSE_NUM1 where ADRC-ADDRNUMBER= PayerAddressNumber " " ADRC-STREET where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerCityName | map from sales order | ADRC-CITY1 where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerStateProvince | map from sales order | ADRC-REGION where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerPostalCode | map from sales order | ADRC-POST_CODE1 where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerPostalCountry | map from sales order | ADRC-COUNTRY where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerLocationCode | map from sales order | KNA1-LOCCO where KNA1-KUNNR = Payer | ||
| PayerExternalReference | not mapped | |||
| PayerTaxIdentifierNumber | map from sales order | DFKKBPTAXNUM_TAXNUM where DFKKBPTAXNUM_PARTNER = BUT000_PARTNER BUT000_PARTNER: BUT000_PARTNER where BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID where CVI_CUST_LINK_CUSTOMER = Payer | ||
| PayerJurisdiction | map from sales order | ADRC-TAXJURCODE where ADRC-ADDRNUMBER= PayerAddressNumber | ||
| PayerToTaxCertificateType | not mapped | |||
| PayerTaxCertificateNumber | not mapped | |||
| PayerTaxBasis | not mapped | |||
| PayerTaxRate | not mapped | |||
| PayerSenderURL | map from sales order | ADR12-URI_ADDR where ADR12-ADDRNUMBER= PayerAddressNumber | ||
| AccountHolderName | not mapped | |||
| AccountNumber | not mapped | |||
| FinancialInstitution | not mapped | |||
| FinancialInstitutionDFINumber | not mapped | |||
| CreditCardNumber | not mapped | |||
| CreditCardType | not mapped | |||
| CreditCardExpirationDate | not mapped | |||
| BillToTelephoneNumberTelecomCountryCode | not mapped | |||
| BillToTelephoneNumberTelecomAreaCode | not mapped | |||
| BillToTelephoneNumberPhoneNumber | map from sales order | ADR2-TEL_NUMBER where ADRC-ADDRNUMBER = BillToAddressNumber | ||
| BillToFaxNumberTelecomCountryCode | not mapped | |||
| BillToFaxNumberTelecomAreaCode | not mapped | |||
| BillToFaxNumberPhoneNumber | map from sales order | ADR3-FAXNR_LONG where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToEmailAddress | map from sales order | ADR6-SMTP_ADDR where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToAlternativeCommunicationMethod | not mapped | |||
| BillToAddressLine | map from sales order | ADRC-HOUSE_NUM1 where ADRC-ADDRNUMBER= BillToAddressNumber " " ADRC-STREET where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToCityName | map from sales order | ADRC-CITY1 where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToStateProvince | map from sales order | ADRC-REGION where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToPostalCode | map from sales order | ADRC-POST_CODE1 where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToPostalCountry | map from sales order | ADRC-COUNTRY where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToLocationCode | map from sales order | KNA1-LOCCO where KNA1-KUNNR = BillToParty | ||
| BillToExternalReference | not mapped | |||
| BillToTaxIdentifierNumber | map from sales order | DFKKBPTAXNUM_TAXNUM where DFKKBPTAXNUM_PARTNER = BUT000_PARTNER BUT000_PARTNER: BUT000_PARTNER where BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID BUT000_PARTNER_GUID = CVI_CUST_LINK_PARTNER_GUID where CVI_CUST_LINK_CUSTOMER = BillToParty | ||
| BillToJurisdiction | map from sales order | ADRC-TAXJURCODE where ADRC-ADDRNUMBER= BillToAddressNumber | ||
| BillToTaxCertificateType | not mapped | |||
| BillToTaxCertificateNumber | not mapped | |||
| BillToTaxBasis | not mapped | |||
| BillToTaxRate | not mapped | |||
| BillToSenderURL | map from text | ADR12-URI_ADDR where ADR12-ADDRNUMBER= BillToAddressNumber | ||
| ShipFromTelephoneNumberTelecomCountryCode | not mapped | |||
| ShipFromTelephoneNumberTelecomAreaCode | not mapped | |||
| ShipFromTelephoneNumberPhoneNumber | not mapped | |||
| ShipFromFaxNumberTelecomCountryCode | not mapped | |||
| ShipFromFaxNumberTelecomAreaCode | not mapped | |||
| ShipFromFaxNumberPhoneNumber | not mapped | |||
| ShipFromEmailAddress | not mapped | |||
| ShipFromAlternativeCommunicationMethod | not mapped | |||
| ShipFromAddressLine | not mapped | |||
| ShipFromCityName | not mapped | |||
| ShipFromStateProvince | not mapped | |||
| ShipFromPostalCode | not mapped | |||
| ShipFromPostalCountry | not mapped | |||
| ShipFromLocationCode | not mapped | |||
| ShipFromExternalReference | not mapped | |||
| ShipFromTaxIdentifierNumber | not mapped | |||
| ShipFromJurisdiction | not mapped | |||
| ShipFromTaxCertificateType | not mapped | |||
| ShipFromTaxCertificateNumber | not mapped | |||
| ShipFromTaxBasis | map from text | |||
| ShipFromTaxRate | not mapped | |||
| ShipFromSenderURL | map from text | |||
| CarrierTelephoneNumberTelecomCountryCode | not mapped | |||
| CarrierTelephoneNumberTelecomAreaCode | not mapped | |||
| CarrierTelephoneNumberPhoneNumber | not mapped | |||
| CarrierFaxNumberTelecomCountryCode | map from text | |||
| CarrierFaxNumberTelecomAreaCode | not mapped | |||
| CarrierFaxNumberPhoneNumber | not mapped | |||
| CarrierEmailAddress | not mapped | |||
| CarrierAlternativeCommunicationMethod | map from text | |||
| CarrierAddressLine | not mapped | |||
| CarrierCityName | not mapped | |||
| CarrierStateProvince | not mapped | |||
| CarrierPostalCode | not mapped | |||
| CarrierPostalCountry | not mapped | |||
| CarrierLocationCode | not mapped | |||
| CarrierExternalReference | not mapped | |||
| CarrierTaxIdentifierNumber | not mapped | |||
| CarrierJurisdiction | not mapped | |||
| CarrierTaxCertificateType | not mapped | |||
| CarrierTaxCertificateNumber | not mapped | |||
| CarrierTaxBasis | not mapped | |||
| CarrierTaxRate | not mapped | |||
| CarrierSenderURL | not mapped | |||
| ShipperTelephoneNumberTelecomCountryCode | not mapped | |||
| ShipperTelephoneNumberTelecomAreaCode | not mapped | |||
| ShipperTelephoneNumberPhoneNumber | not mapped | |||
| ShipperFaxNumberTelecomCountryCode | not mapped | |||
| ShipperFaxNumberTelecomAreaCode | not mapped | |||
| ShipperFaxNumberPhoneNumber | not mapped | |||
| ShipperEmailAddress | not mapped | |||
| ShipperAlternativeCommunicationMethod | not mapped | |||
| ShipperAddressLine | not mapped | |||
| ShipperCityName | not mapped | |||
| ShipperStateProvince | not mapped | |||
| ShipperPostalCode | not mapped | |||
| ShipperPostalCountry | not mapped | |||
| ShipperLocationCode | not mapped | |||
| ShipperExternalReference | not mapped | |||
| ShipperTaxIdentifierNumber | not mapped | |||
| ShipperJurisdiction | not mapped | |||
| ShipperTaxCertificateType | not mapped | |||
| ShipperTaxCertificateNumber | not mapped | |||
| ShipperTaxBasis | not mapped | |||
| ShipperTaxRate | not mapped | |||
| ShipperSenderURL | not mapped | |||
| A_SalesOrderText | CustomerRequiredInstructions | map from text | VBBK_Z004 | |
| ShipperInstructions | map from text | VBBK_Z004 | ||
| ConsigneeInstructions | map from text | VBBK_Z004 | ||
| CarrierInstructions | map from text | VBBK_Z004 | ||
| ImportInstruction | map from text | VBBK_Z004 | ||
| CustomerServiceInstructions | read text | read SO10 text section in Processing Logic | ||
| RoutingInstruction | map from text | VBBK_Z004 | ||
| A_SalesOrderItem | LineItemNumber | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | |
| PurchaseOrderLineItemNumber | map from sales order field | VBAP-POSNR | ||
| LineItemHandlingInstruction | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| MaterialByCustomer | map from sales order field | VBAP-KDMAT | ||
| MaterialByCustomerDescription | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ProductDescription | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ProductGradeDescription | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| Material | map from sales order field | VBAP-MATNR | ||
| MaterialDescription | map from sales order field | VBAP-ARKTX | ||
| ProductDescription | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ProductGradeDescription | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| SalesOrderReference | map from sales order field | VBAK-VBELN | ||
| SalesOrderReferenceItem | map from sales order field | VBAP-POSNR where VBAP-VBELN = VBAK-VBELN | ||
| SalesOrderItemNumber | map from sales order field | VBAP-POSNR where VBAP-VBELN = VBAK-VBELN | ||
| RequestedQuantity | map from sales order field | VBAP-KWMENG | ||
| RequestedQuantityISOUnit | map from sales order field | VBAP-VRKME | ||
| PackagingQuantity | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| PackagingQuantityISOUnit | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| EngineeringChangeOrderIdentifier | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| BatchNumber | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| CountryOfOriginCode | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| IncotermsClassification | map from sales order | VBKD-INCO1 | ||
| IncotermsLocation1 | map from sales order | VBKD-INCO2_L | ||
| TransportMethodCode | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| LineItemPurposeCode | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| BalanceItemFlag | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| DeliveryTolerancesLowerLimit | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| DeliveryTolerancesUpperLimit | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| DeliveryTolerancesUnitofMeasure | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ChangeAcknowledgementFlag | fixed value | default <N> | ||
| LineStatusCode | See LineStatusCode Mapping in Processing Logic section | |||
| LineResponseReasonCode | fixed value | default <ZZ> | ||
| LineItemPurposeCode | fixed value | default <ZZ> | ||
| ItemShiptoPartnerName | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ItemShipToPartnerCode | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ItemBilltoPartnerName | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ItemBillToPartnerCode | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| ItemShipperPartnerName | not mapped | |||
| ItemShipperPartnerCode | not mapped | |||
| ItemShipFromPartnerName | not mapped | |||
| ItemShipFromPartnerCode | not mapped | |||
| ItemCarrierPartnerName | not mapped | |||
| ItemCarrierPartnerCode | not mapped | |||
| ItemShipToTelephoneNumberTelecomCountryCode | not mapped | |||
| ItemShipToTelephoneNumberTelecomAreaCode | not mapped | |||
| ItemShipToTelephoneNumberPhoneNumber | not mapped | |||
| ItemShipToFaxNumberTelecomCountryCode | not mapped | |||
| ItemShipToFaxNumberTelecomAreaCode | not mapped | |||
| ItemShipToFaxNumberPhoneNumber | not mapped | |||
| ItemShipToEmailAddress | not mapped | |||
| ItemShipToAlternativeCommunicationMethod | not mapped | |||
| ItemShipToAddressLine | not mapped | |||
| ItemShipToCityName | not mapped | |||
| ItemShipToStateProvince | not mapped | |||
| ItemShipToPostalCode | not mapped | |||
| ItemShipToPostalCountry | not mapped | |||
| ItemShipToLocationCode | not mapped | |||
| ItemShipToExternalReference | not mapped | |||
| ItemShipToTaxIdentifierNumber | not mapped | |||
| ItemShipToJurisdiction | not mapped | |||
| ItemShipToTaxCertificateType | not mapped | |||
| ItemShipToTaxCertificateNumber | not mapped | |||
| ItemShipToTaxBasis | not mapped | |||
| ItemShipToTaxRate | not mapped | |||
| ItemShipToSenderURL | not mapped | |||
| ItemBillToTelephoneNumberTelecomCountryCode | not mapped | |||
| ItemBillToTelephoneNumberTelecomAreaCode | not mapped | |||
| ItemBillToTelephoneNumberPhoneNumber | not mapped | |||
| ItemBillToFaxNumberTelecomCountryCode | not mapped | |||
| ItemBillToFaxNumberTelecomAreaCode | not mapped | |||
| ItemBillToFaxNumberPhoneNumber | not mapped | |||
| ItemBillToEmailAddress | not mapped | |||
| ItemBillToAlternativeCommunicationMethod | not mapped | |||
| ItemBillToAddressLine | not mapped | |||
| ItemBillToCityName | not mapped | |||
| ItemBillToStateProvince | not mapped | |||
| ItemBillToPostalCode | not mapped | |||
| ItemBillToPostalCountry | not mapped | |||
| ItemBillToLocationCode | not mapped | |||
| ItemBillToExternalReference | not mapped | |||
| ItemBillToTaxIdentifierNumber | not mapped | |||
| ItemBillToJurisdiction | not mapped | |||
| ItemBillToTaxCertificateType | not mapped | |||
| ItemBillToTaxCertificateNumber | not mapped | |||
| ItemBillToTaxBasis | not mapped | |||
| ItemBillToTaxRate | not mapped | |||
| ItemBillToSenderURL | not mapped | |||
| ItemShipFromTelephoneNumberTelecomCountryCode | not mapped | |||
| ItemShipFromTelephoneNumberTelecomAreaCode | not mapped | |||
| ItemShipFromTelephoneNumberPhoneNumber | not mapped | |||
| ItemShipFromFaxNumberTelecomCountryCode | not mapped | |||
| ItemShipFromFaxNumberTelecomAreaCode | not mapped | |||
| ItemShipFromFaxNumberPhoneNumber | not mapped | |||
| ItemShipFromEmailAddress | not mapped | |||
| ItemShipFromAlternativeCommunicationMethod | not mapped | |||
| ItemShipFromAddressLine | not mapped | |||
| ItemShipFromCityName | not mapped | |||
| ItemShipFromStateProvince | not mapped | |||
| ItemShipFromPostalCode | not mapped | |||
| ItemShipFromPostalCountry | not mapped | |||
| ItemShipFromLocationCode | not mapped | |||
| ItemShipFromExternalReference | not mapped | |||
| ItemShipFromTaxIdentifierNumber | not mapped | |||
| ItemShipFromJurisdiction | not mapped | |||
| ItemShipFromTaxCertificateType | not mapped | |||
| ItemShipFromTaxCertificateNumber | not mapped | |||
| ItemShipFromTaxBasis | not mapped | |||
| ItemShipFromTaxRate | not mapped | |||
| ItemShipFromSenderURL | not mapped | |||
| ItemCarrierTelephoneNumberTelecomCountryCode | not mapped | |||
| ItemCarrierTelephoneNumberTelecomAreaCode | not mapped | |||
| ItemCarrierTelephoneNumberPhoneNumber | not mapped | |||
| ItemCarrierFaxNumberTelecomCountryCode | not mapped | |||
| ItemCarrierFaxNumberTelecomAreaCode | not mapped | |||
| ItemCarrierFaxNumberPhoneNumber | not mapped | |||
| ItemCarrierEmailAddress | not mapped | |||
| ItemCarrierAlternativeCommunicationMethod | not mapped | |||
| ItemCarrierAddressLine | not mapped | |||
| ItemCarrierCityName | not mapped | |||
| ItemCarrierStateProvince | not mapped | |||
| ItemCarrierPostalCode | not mapped | |||
| ItemCarrierPostalCountry | not mapped | |||
| ItemCarrierLocationCode | not mapped | |||
| ItemCarrierExternalReference | not mapped | |||
| ItemCarrierTaxIdentifierNumber | not mapped | |||
| ItemCarrierJurisdiction | not mapped | |||
| ItemCarrierTaxCertificateType | not mapped | |||
| ItemCarrierTaxCertificateNumber | not mapped | |||
| ItemCarrierTaxBasis | not mapped | |||
| ItemCarrierTaxRate | not mapped | |||
| ItemCarrierSenderURL | not mapped | |||
| ItemShipperTelephoneNumberTelecomCountryCode | not mapped | |||
| ItemShipperTelephoneNumberTelecomAreaCode | not mapped | |||
| ItemShipperTelephoneNumberPhoneNumber | not mapped | |||
| ItemShipperFaxNumberTelecomCountryCode | not mapped | |||
| ItemShipperFaxNumberTelecomAreaCode | not mapped | |||
| ItemShipperFaxNumberPhoneNumber | not mapped | |||
| ItemShipperEmailAddress | not mapped | |||
| ItemShipperAlternativeCommunicationMethod | not mapped | |||
| ItemShipperAddressLine | not mapped | |||
| ItemShipperCityName | not mapped | |||
| ItemShipperStateProvince | not mapped | |||
| ItemShipperPostalCode | not mapped | |||
| ItemShipperPostalCountry | not mapped | |||
| ItemShipperLocationCode | not mapped | |||
| ItemShipperExternalReference | not mapped | |||
| ItemShipperTaxIdentifierNumber | not mapped | |||
| ItemShipperJurisdiction | not mapped | |||
| ItemShipperTaxCertificateType | not mapped | |||
| ItemShipperTaxCertificateNumber | not mapped | |||
| ItemShipperTaxBasis | not mapped | |||
| ItemShipperTaxRate | not mapped | |||
| ItemShipperSenderURL | not mapped | |||
| A_SalesOrderItemText | CustomerRequiredInstructions | map from text | VBBP_Z004 | |
| ShipperInstructions | map from text | VBBP_Z004 | ||
| ConsigneeInstructions | map from text | VBBP_Z004 | ||
| CarrierInstructions | map from text | VBBP_Z004 | ||
| ImportInstruction | map from text | VBBP_Z004 | ||
| CustomerServiceInstructions | map from text | VBBP_Z004 | ||
| RoutingInstruction | map from text | VBBP_Z002 | ||
| A_SalesOrderItemPrElement | PricePerUnit | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | |
| PriceCurrencyCode | map from text | From text VBBP-Z999: Fetch <value> where 'Label> = <Field> | ||
| A_SalesOrderScheduleLine | ScheduleDateConfirmedDeliveryOn | map from sales order field | VBEP-EDATU where: VBEP-VBELN = VBAK-VBELN VBEP-POSNR = VBAP-POSNR | |
| ScheduleDateConfirmedShipOn | map from sales order field | VBEP-EDATU where: VBEP-VBELN = VBAK-VBELN VBEP-POSNR = VBAP-POSNR | ||
| ScheduleDateConfirmedShipBy | ||||
| ScheduleDateConfirmedPickUpby |
Populate the table below to list the mapping for edocument implementations. Can be deleted if not needed.
| General | Syensqo XML (Intermediate Target) | SAP eDoc Standard Mapping (Source) | Custom Mapping (Source) | |||||||
|---|---|---|---|---|---|---|---|---|---|---|
| S-NR | Flow (SD/FI/MM/ALL) | Target Field | Target Field Details | Condition | Syensqo XML Node | Syensqo XML Field | SAP eDoc Standard Node | SAP eDoc Standard Field | Fixed Value | Custom Logic |
| Conditional / Mandatory | Header / Header Tax / Header Value / Header Extension / Sender / Sender Extension / Receiver / Receiver Extension / Item / Item Tax / Item Value / Item Extension | |||||||||
Describe the processing requirement in the System
SellerPartnerCode Determination Logic
Refer to DUNS Reference Table (ZL2C_DUNS)
Fetch SellerDUNS where:
SenderDUNS = A_SalesOrderHeaderHeader/SenderDUNS
ReceiverDUNS = A_SalesOrderHeaderHeader/ReceiverDUNS
BuyerDUNS = A_SalesOrderHeaderPartner/BuyerPartnerCode
Partner Look Up Logic
Elemica use the DUNS (Partner Codes) for the different business partner roles in a message. To send a sales order response from S/4HANA, the Partner Codes for each of the SAP Customers Partner roles have to be found. As a pre-requisite, the mapping of the Partner Codes, partner role and the SAP Customer numbers will be maintained using the standard SAP table EDPAR. This table will be maintained in each client as part of customer activates via transaction code VOE4.
Below table is the look up logic of the Partner Code from the SAP Customer partner role from sales order for the Order Response Message
| Partner Code | Logic to find Partner Code from SAP Customer |
|---|---|
| BuyerPartnerCode | EDPAR-EXPNR where: |
| ShipToPartnerCode | EDPAR-EXPNR where: EDPAR-KUNNR = <SoldToParty> |
| PayerPartnerCode | EDPAR-INPNR where: EDPAR-KUNNR = SoldToParty |
| BillToPartnerCode | EDPAR-INPNR where: EDPAR-KUNNR = SoldToParty> |
where:
| SAP Customer Code | Source of SAP Customer in Sales Order |
|---|---|
| SoldToParty | VBAK-KUNNR |
| ShipToParty | VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = SH |
| Payer | VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = BP |
| BillToParty | VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = PY |
Address Number
| Customer Address Number | Address Number (KNA1-ADRNR) logic |
|---|---|
| SoldToAddressNumber | KNA1-ADRNR where KNA1-KUNNR = SoldtoParty |
| ShipToAddressNumber | KNA1-ADRNR where KNA1-KUNNR = ShipToParty |
| PayerAddressNumber | KNA1-ADRNR where KNA1-KUNNR = PayerParty |
| BillToAddressNumber | KNA1-ADRNR where KNA1-KUNNR = BillToParty |
SO10 text for CustomerServiceInstruction
Maintain below text in SO10
This order is supplied subject to the General Terms and Conditions of sales of Solvay companies available on the Solvay Internet website: https://www.solvay.com/en/markets-and-products/doing-business-with-solvay/terms-conditions/index.html
Sales Order Criteria for sending Order Response API
SAP Event Mesh Trigger Conditions
| Trigger Condition | Sales Order Event | |
|---|---|---|
| Immediately after sales order is created | Sales Order Created | |
| Sales Order Changes | Sales Order Changed | what changes trigger this event? |
| Delivery block change | Sales Order Overall Delivery Block Status Changed | |
| Credit Status change | Sales Order Overall Credit Check Status Changed | |
| Changes to rejection status | Sales Order Rejection Status Changed |
Custom Table: OUTBOUND EDI CUSTOMER Table (ZL2C_EDI_CUST_OUT)
Outbound EDI messages are only required by specific customers. This table is to maintain the list of customers and the outbound messages they require for use by SAP Event Mesh to trigger the outbound API.
This table should not be transportable and should only be maintained by a technical user (no user transaction or Fiori app required).
This table will be initially populated with known and existing data as part of cutover activities. It will be updated when a new customer is onboarded and required any of the outbound messages.
When a sold to requires an outbound message, an X will be marked against it.
Table Definition
| Field | Data Type | Validation Rule/Value Help |
|---|---|---|
| Sold to | String | |
| Order Response | Char | |
| ShipNotice | Char | |
| Invoice | Char |
Table Example
| Sold to | Order Response | ShipNotice | Invoice |
|---|---|---|---|
| 2073976 | X | X | |
| 2094097 | X |
LineStatusCode Mapping
| Sales Order Event | LineStatusCode |
|---|---|
| Sales Order Created | PH |
| Sales Order Item Created | IN |
| Sales Order Item Changed | IN |
Sales Order Item Rejection Status Changed | CU |
Delta or Full Load Requirements
Please describe change tracking requirements, i.e. transferring only delta, or always full load
Monitoring will be done via AIF
Language Requirements
English
N/A
N/A
circa 800 messages per month
Specify if there are any specific performance factors that need to be taken into consideration during development i.e. interface must be able to handle 100 posting per-hour, etc.
All errors occurring during mapping rule execution and during API trigger to be added to the application log and AIF in a readable and user understandable format
All errors should trigger incident creation in SyRa and send email to an IT mailbox (tbc)
Please provide some guidance and/or test data to help the developer unit test the interface. Please include both positive and negative testing (to validate error situations handling)
The developer will need to test repeatedly, so where appropriate provide instructions to reverse the actions performed so the test may be run again, or explain how to create new input data to the test. In particular, the developer will need logons for test users representing the various roles within the approval process.
| ID | Condition | Expected Results |
|---|---|---|
| 1 | OrderResponse API executes defined logics, mapping and lookups in S/4HANA and triggers the XML to SAP CPI | All defined logics, mapping and lookups in S/4HANA executed correctly and AP triggers XML to SAP CPI |
| 2 | OrderResponse API sends XML to SAP CPI based on Sales Order Criteria and SAP Event Mesh trigger conditions | OrderResponse API successfully sends XML to SAP CPI based on Sales Order Criteria and SAP Event Mesh trigger conditions |
| 3 | OrderResponse API sends XML to SAP CPI meeting defined structure and mapping | OrderResponse API successfully sends XML to SAP CPI meeting defined structure and mapping |
N/A
| Package Name | Parent Package |
|---|---|
Other Development Objects
| Object Type | Object Name | Purpose/High Level Logic | Design Rationale Reference |
|---|---|---|---|
Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.
