| Status | |
|---|---|
| Owner | |
| Stakeholders | |
| Jira Request ID | |
| Jira Development ID |
| Implementing System | SAP S/4HANA |
|---|---|
| Invoked by/Invokes | |
| Business Process Reference | 02.04.02.01. Manage Standard Sales Order |
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
Scope and Objectives
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.
![]()
Insert the flowchart and fill in the steps
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 |
3 | Sales Order is created in SAP S/4HANA based on the message received from SAP CPI |
Describe any assumptions that have been made in the process of completing this design. What functionality is expected of configuration or other developments that pass information to this development and/ or retrieve the information processed by it (performance, triggers, exceptions, etc.)
Indicate any dependencies or constraints that may impact development, in terms of requirements from internal or external applications or teams, limited access to legacy systems, time constraints or data restrictions. Also, please specify schedule dependencies e.g. interface or batch jobs that must run prior to execution.
To detail the security requirements for processing this object, any data integrity issues associated with the object and the teams that will be responsible for processing the object, i.e. authorization/roles required to who can execute the interface, encryption requirement, etc.
Specify the configuration requirements for this object. Like in case of substitution/ routine specify the configuration needed
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
If the interface interacts with third-party systems such as Icertis, describe any additional integration, security or authentication considerations that must be taken into account.
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.
Populate the type of the API use in this section. Will the API be Consumed or Provided.
Custom API based on API_SALES_ORDER_SRV_0001
| 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 | |||
| TransactionCurrency | The currency that applies to the sales order | N | String | ||
| Number | 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 | |||
| 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 | |||
| 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 | |||
| BuyerPartnerName | The customer who orders the goods or services. The sold-to party is ually 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 | |||
| CustomerPurchaseOrderNumber | 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 | |||
| 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 | ||
| PriceBasis | N | String | ||
| PriceBasisUnitofMeasure | N | String | ||
| A_SalesOrderScheduleLine | 1 |
| |||
ScheduleDateRequestedDeliveryOn | N | DateTime | |||
ScheduleDateConfirmedPickUpOn | 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 to) | Additional Instruction |
| A_SalesOrderHeader | ||||
| DocumentIdentifier | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DocumentIdentifierDateTime | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| RequestingDocumentIdentifier | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| RequestingDocumentDateTime | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderDUNS | map to ZL2C_DUNS custom table | SenderDUNS | ||
| SenderContactName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderContactDescription | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SenderSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverDUNS | map to ZL2C_DUNS custom table | ReceiverDUNS | ||
| ReceiverContactName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverContactDescription | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReceiverSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PurchaseOrderTypeCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CustomerPurchaseOrder | map to sales order field | VBAK-BSTNK | ||
| CustomerPurchaseOrderDate | map to sales order field | VBAK-BSTDK | ||
| TransactionCurrency | map to sales order field | VBAK-WAERK | ||
| ContractNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| LanguageCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| RevisionNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ReleaseNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| IncotermsClassification | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| IncotermsLocation1 | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CustomerPaymentTerms | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DiscountPercentage | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DiscountAmount | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DiscountDaysDue | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DiscountsDueDate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DeferredAmount | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DeferedDueDate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PercentDeferredPayable | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| Penalty | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipWithPurchaseOrder | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CountryOfFinalDestination | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| MarketPlaceIdentifier | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| MarketPlaceDocumentIdentifier | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| MarketPlaceReferenceItem | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| MarketPlaceSellerIdentifier | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| InvoiceCommunicationMode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillingScheduleCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerPartnerCode | map to ZL2C_DUNS custom table and see Partner Look Up Logic | BuyerDUNS | ||
| BuyerContactName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerContactDescription | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SellerPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SellerPartnerCode | map to ZL2C_DUNS custom table | SellerDUNS | ||
| SellerContactName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| SellerContactDescription | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShiptoPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToPartnerCode | see Partner Look Up Logic | |||
| PayerPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerPartnerCode | see Partner Look Up Logic | |||
| BilltoPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToPartnerCode | see Partner Look Up Logic | |||
| ShipperPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperPartnerCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromPartnerCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierPartnerName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierPartnerCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BuyerSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipToSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerToTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PayerSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| AccountHolderName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| AccountNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| FinancialInstitution | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| FinancialInstitutionDFINumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CreditCardNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CreditCardType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CreditCardExpirationDate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BillToSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipFromSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CarrierSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTelephoneNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTelephoneNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTelephoneNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperFaxNumberTelecomCountryCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperFaxNumberTelecomAreaCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperFaxNumberPhoneNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperEmailAddress | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperAlternativeCommunicationMethod | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperAddressLine | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperCityName | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperStateProvince | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperPostalCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperPostalCountry | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperLocationCode | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperExternalReference | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTaxIdentifierNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperJurisdiction | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTaxCertificateType | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTaxCertificateNumber | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTaxBasis | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperTaxRate | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ShipperSenderURL | map to text | VBBK_Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| A_SalesOrderText | ||||
| CustomerRequiredInstructions | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| ShipperInstructions | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| ConsigneeInstructions | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| CarrierInstructions | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| ImportInstruction | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| CustomerServiceInstructions | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| RoutingInstruction | map to text | VBBK_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| A_SalesOrderItem | ||||
| LineItemNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PurchaseOrderLineItemNumber | map to sales order field | VBAP-POSNR | ||
| LineItemHandlingInstruction | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| MaterialByCustomer | map to sales order field | VBAP-KDMAT | ||
| MaterialByCustomerDescription | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ProductDescription | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ProductGradeDescription | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| Material | map to sales order field | VBAP-MATNR | ||
| MaterialDescription | map to sales order field | VBAP-ARKTX | ||
| ProductDescription | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ProductGradeDescription | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CustomerPurchaseOrder | map to sales order field | VBKD-BSTKD_E | ||
| ReferenceItem | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| RequestedQuantity | map to sales order field | VBAP-KWMENG | ||
| RequestedQuantityISOUnit | map to sales order field | VBAP-VRKME | ||
| PackagingQuantity | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PackagingQuantityISOUnit | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| EngineeringChangeOrderIdentifier | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BatchNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| CountryOfOriginCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| IncotermsClassification | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| IncotermsLocation1 | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| TransportMethodCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| LineItemPurposeCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| BalanceItemFlag | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DeliveryTolerancesLowerLimit | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DeliveryTolerancesUpperLimit | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| DeliveryTolerancesUnitofMeasure | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShiptoPartnerName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToPartnerCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBilltoPartnerName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToPartnerCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperPartnerName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperPartnerCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromPartnerName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromPartnerCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierPartnerName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierPartnerCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTelephoneNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTelephoneNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTelephoneNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToFaxNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToFaxNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToFaxNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToEmailAddress | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToAlternativeCommunicationMethod | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToAddressLine | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToCityName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToStateProvince | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToPostalCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToPostalCountry | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToLocationCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToExternalReference | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTaxIdentifierNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToJurisdiction | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTaxCertificateType | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTaxCertificateNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTaxBasis | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToTaxRate | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipToSenderURL | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTelephoneNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTelephoneNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTelephoneNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToFaxNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToFaxNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToFaxNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToEmailAddress | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToAlternativeCommunicationMethod | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToAddressLine | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToCityName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToStateProvince | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToPostalCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToPostalCountry | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToLocationCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToExternalReference | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTaxIdentifierNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToJurisdiction | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTaxCertificateType | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTaxCertificateNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTaxBasis | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToTaxRate | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemBillToSenderURL | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTelephoneNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTelephoneNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTelephoneNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromFaxNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromFaxNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromFaxNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromEmailAddress | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromAlternativeCommunicationMethod | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromAddressLine | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromCityName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromStateProvince | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromPostalCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromPostalCountry | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromLocationCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromExternalReference | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTaxIdentifierNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromJurisdiction | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTaxCertificateType | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTaxCertificateNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTaxBasis | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromTaxRate | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipFromSenderURL | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTelephoneNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTelephoneNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTelephoneNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierFaxNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierFaxNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierFaxNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierEmailAddress | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierAlternativeCommunicationMethod | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierAddressLine | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierCityName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierStateProvince | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierPostalCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierPostalCountry | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierLocationCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierExternalReference | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTaxIdentifierNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierJurisdiction | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTaxCertificateType | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTaxCertificateNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTaxBasis | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierTaxRate | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemCarrierSenderURL | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTelephoneNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTelephoneNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTelephoneNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperFaxNumberTelecomCountryCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperFaxNumberTelecomAreaCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperFaxNumberPhoneNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperEmailAddress | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperAlternativeCommunicationMethod | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperAddressLine | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperCityName | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperStateProvince | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperPostalCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperPostalCountry | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperLocationCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperExternalReference | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTaxIdentifierNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperJurisdiction | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTaxCertificateType | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTaxCertificateNumber | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTaxBasis | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperTaxRate | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| ItemShipperSenderURL | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| A_SalesOrderItemText | ||||
| CustomerRequiredInstructions | map to text | VBBP_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| ShipperInstructions | map to text | VBBP_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| ConsigneeInstructions | map to text | VBBP_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| CarrierInstructions | map to text | VBBP_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| ImportInstruction | map to text | VBBP_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| CustomerServiceInstructions | map to text | VBBP_Z004 | Format for update in Text: "<Field>:" + <value>. | |
| RoutingInstruction | map to text | VBBP_Z002 | Format for update in Text: "<Field>:" + <value>. | |
| A_SalesOrderItemPrElement | ||||
| PricePerUnit | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PriceCurrencyCode | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PriceBasis | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| PriceBasisUnitofMeasure | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. Add label <Field> only if <value> is not blank | |
| A_SalesOrderScheduleLine | ||||
| ScheduleDateRequestedDeliveryOn | map to sales order field | VBEP-EDATU | VBEP-EDATU for each VBAP-POSNR also map to VBAK-VDATU from first line item | |
| ScheduleDateConfirmedPickUpOn | map to text | VBBP-Z999 | Format for update in Text: "<Field>:" + <value>. | |
| A_SalesOrderAdditionalFields | ||||
| DsitributionChannel | refer to field logics in Processing Logic section | |||
| Division | refer to field logics in Processing Logic section | |||
| SalesOrderType | refer to field logics in Processing Logic section | |||
| SalesOrganisation | refer to field logics in Processing Logic section | |||
| SalesOrderPOType | refer to field logics in Processing Logic section | |||
| UserStatus | refer to field logics in Processing Logic section |
Describe the processing requirement in the System
Custom Table: DUNS Reference Table (ZL2C_DUNS)
Every Elemica message has a set of 4 DUNS codes that uniquely identifies the message and used to support its successful integration in S/4HANA. To support this use, a custom table will be created in S/4HANA to store this sets of data, keep them updated (where required) and reference them when outbound messages (e.g. OrderResponse, Invoice) are sent from S/4HANA to Elemica.
This table will be initially populated with known and existing data as part of cutover activities. Subsequently, whenever an Elemica OrderCreate message is received, it will update this table automatically with the DUNS received for Sender, Receiver, Buyer and Seller in the message. If it finds any values already in the table, it does not update table
| Field | Description | Data Type | Validation Rule/Value Help | Source Field in Inbound Message |
|---|---|---|---|---|
| SenderDUNS | This is Elemica's representation of the Sender as a communication partner | String | A_SalesOrderHeader/SenderDUNS | |
| ReceiverDUNS | This is Elemica's representation of the Receiver as communication partner | String | A_SalesOrderHeader/ReceiverDUNS | |
| BuyerDUNS | This is a representation of the customer | String | A_SalesOrderHeaderPartner/BuyerPartnerCode | |
SellerDUNS | This is a representation of the Syensqo entity making the sale | String | A_SalesOrderHeaderPartner/SellerPartnerCode |
Partner Look Up Logic
Elemica use the DUNS for the different business partner roles in a message. To create a sales order in S/4HANA, the equivalent SAP Customers for each of the partner DUNS have to be found. As a pre-requisite, the mapping of the partner DUNS, 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 activites via transaction code VOE4.
Below table summarised the look up logic of the SAP Customer Numbers for each partner role from the DUNS in the Elemica message
| SAP Customer | Logic to find SAP Customer from API data | Field in Sales Order for SAP Customer |
|---|---|---|
SoldToParty | EDPAR-INPNR where: | VBAK-KUNNR |
| ShipToParty | EDPAR-INPNR where: EDPAR-KUNNR = <SoldToParty> | VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = SH |
| Payer | EDPAR-INPNR where: EDPAR-KUNNR = <SoldToParty> | VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = PY |
| BillToParty | EDPAR-INPNR where: EDPAR-KUNNR = <SoldToParty> | VBPA-KUNNR where: VBPA-VBELN = VBAK-VBELN VBPA-PARVW = BP |
Field Logic
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 |
|---|---|
| A_SalesOrderAdditionalFields/SalesOrganization | KNMT-VKORG where KNMT-KUNNR = ShipToParty and KNMT-KDMAT = <MaterialByCustomer>. if not found, use: KNMT-VKORG where KNMT-KUNNR = SoldtoParty and KNMT-KDMAT = <MaterialByCustomer> |
| A_SalesOrderAdditionalFields/DistributionChannel | KNMT-VTWEG where KNMT-KUNNR = SoldtoParty and KNMT-KDMAT = <MaterialByCustomer> if not found, use: KNMT-VTWEG where KNMT-KUNNR = SoldtoParty and KNMT-KDMAT = <MaterialByCustomer> |
| A_SalesOrderAdditionalFields/Division | Default as 01 |
| A_SalesOrderAdditionalFields/SalesOrderPOType | Default 'DFUE' into VBAK-BSARK |
| A_SalesOrderAdditionalFields/SalesOrderType | Use PurchaseOrderTypeCode value to derive based on SalesOrderType mapping table |
| A_SalesOrderAdditionalFields/UserStatus | Activate ZECB user status The user status in sales order header is found following the below logical steps
VBAK–OBJNR where VBAK-VBELN Step 2: Find Active User Status Entries Query the JEST table, where: JEST-OBJNR = VBAK–OBJNR JEST-INACT = ‘’ (or 0) → Only active statuses Fetch JEST-STAT where start letter = E (User statuses start with “E”) Step 3: Find the status profile used for the sales order fetch sales document type: VBAK-AUART where VBAK-VBELN then fetch TVAK-STSMA where TVAK-AUART = VBAK-AUART
Query TJ30T to find TXT04 where: TJ30T–STSMA = TVAK-STSMA (Status Profile assigned to the sales document type as in step 3 above) TJ30T–ESTAT = JEST–STAT (determined in step 2) TJ30T–SPRAS = 'EN' language key Set TJ30T-TXT04 = ZECB, and make active |
SalesOrderType Mapping
SalesOrderType is derived based on PurchaseOrderTypeCode from the source XML using the mapping table below
| PurchaseOrderTypeCode | SalesOrderType | Comment |
|---|---|---|
| KN | OR | Triggers a logic to fetch reference contract for SalesOrderType |
| SA | OR | Triggers a logic to fetch reference contract for SalesOrderType |
| KA | KE | Triggers a logic to fetch Consignment Fill Up Order (KB) for SalesOrderType KE |
| CN | KB | Triggers a logic to fetch reference contract for SalesOrderType |
| Z2 | KBB | Triggers a logic to fetch reference contract for SalesOrderType |
| SO | KBB | Triggers a logic to fetch reference contract for SalesOrderType |
| NE | ORB | Triggers a logic to fetch reference contract for SalesOrderType |
| ZE | RCM |
Logic to fetch reference contract for SalesOrderType
Step 1: Find if a contract exists for the sold to, ship to, material and validity
1a: To find existing contract(s) for the sold to party of the order being created
Contract Number(s) = VBAK-VBELN
Read VBAK-VBELN where
VBAK-AUART = CQ and
VBAK-KUNNR = SoldToParty
If no contract(s) is found, API create an error which can be checked in AIF (see error handling section for data errors approach).
1b: For the contract(s) found in step 1a, check the ship to in the sales order being created match the ship to(s)
ContractShipToParty = VBPA-KUNNR
where:
VBPA-VBELN = Contract Number(s)
VBPA-PARVW = SH
If ShipToParty, in the sales order being created matches ContractShipToParty on the contract(s), then contract exist for the ship to
If not, API create an errors which can be checked in AIF (see error handling section for data errors approach).
1c: check contract exist for each of the material (A_SalesOrderItem_Material) for which the sales order is being created
For the contract(s) found in step 1b, check each material for which sales order is being created exist in them
Fetch VBAP-MATNR where
VBAP-POSNR = A_SalesOrderItem _PurchaseOrderLineItemNumber
If A_SalesOrderItem_Material = VBAP-MATNR, then material is found in the contract
If material is not found, API create an error which can be checked in AIF (see error handling section for data errors approach).
1d: check validity of contract(s) found in step 1c
For a unique combination of sold to, ship to and material,
If only one contract Is found, proceed to create the sales order with reference to the contract
If multiple contracts are found, the compare the contract end date against the requested delivery date and select the contract with the most recent contract end date.
Contract End date = VEDA-VENDDAT where VEDA-VBELN = Contract Number
Requested delivery date = VBAK-VDATU
Select contract with the most recent contract end date compared to the requested delivery date of the sales order being created
Proceed to create the sales order with reference to the contract
Logic to fetch Consignment Fill Up Order (KB) for SalesOrderType KE
Step 1: Find if a Consignment Fill Up exists for the sold to, ship to and material
Consignment Fill Up = Sales Document Type KB
1a: To find if a Consignment Fill Up exists for the sold to
Consignment Fill Up = VBAK-VBELN
Read VBAK-VBELN where
VBAK-AUART = KB and
VBAK-KUNNR = SoldToParty
If no Consignment Fill Up is found, API create an error which can be checked in AIF (see error handling section for data errors approach).
1b: For the Consignment Fill Up(s) found in step 1a, check the ship to in the sales order being created match the ship to(s)
ConsignmentFillUpShipToParty = VBPA-KUNNR
where:
VBPA-VBELN = Consignment Fill Up
VBPA-PARVW = SH
If ShipToParty in the Consignment Issue being created matches ConsignmentFillUpShipToParty then Consignment Fill Up exist for the ship to
If not, API create an error which can be checked in AIF (see error handling section for data errors approach).
1c: check Consignment Fill Up exist for the material for which the Consignment Issue sales order is being created (A_SalesOrderItem_Material)
For the Consignment Fill Up(s) found in step 1b, check each material for which consignment issue sales order is being created exist in them
Fetch VBAP-MATNR where
VBAP-VBELN = Consignment Fill Up(s) and
VBAP-POSNR = A_SalesOrderItem _PurchaseOrderLineItemNumber
If A_SalesOrderItem_Material = VBAP-MATNR, then material is found in the contract
If material is not found, API create an error which can be checked in AIF (see error handling section for data errors approach).
Duplicate PO check
API to check that sales order has not been created for the same Customer Purchase Order. If a sales order already exists with the Customer Purchase Order, the API should not create the sales order but should generate an error message.
Sales Order Purchase Order field: VBAK-BSTNK
API field for Customer Purchase Order Number: A_SalesOrderHeader_CustomerPurcaseOrder
At posting new sales order creation, compare A_SalesOrderHeader_CustomerPurcaseOrder with VBAK-BSTNK
If there is a match, API generates error message "Customer PO <A_SalesOrderHeader_CustomerPurcaseOrder> already exist in Sales Order" (see error handling section for data errors approach)
Cross Selling Quantity Determination
Implement logic to automatically determine cross selling quantity as defined in ERP-1750 Cross Selling quantity EDI Determination automatically
Please describe change tracking requirements, i.e. transferring only delta, or always full load
Please describe any alert & monitoring requirement for business users and support organization, i.e. AIF
Monitoring will be done via AIF.
Specify multi language requirements
English
User Interface Requirements
Capture the requirements for the user interface (UI) associated with the interface. It should provide a clear description of how users will interact with the interface and how information will be presented to ensure usability and accuracy.
NA
Please describe delivery requirements driven by message sequencing, i.e. specific order, impact of disruption of sequence, are duplicates allowed, etc.
N/A
Provide volumetrics details: Initial load volumes, Number of Records, Expected Frequency, Expected Long term Growth)
circa 450 inbound OrderCreate 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.
Detail how errors will be handled: Notification, Restart/ Recovery and Re-Processing Procedures
Error handling for this interface to align with the error handling process for interfaces as defined for SyWay (exact approach / process yet to be defined and below are indicative only to be refined based on the defined approach)
Integration errors:
All errors occurring during mapping rule execution and during posting to be added to the application log and AIF in a readable and user understandable format. These errors should trigger incident creation in SyRa (tbc)
Data errors or errors in S4 during translation, logic execution etc:
These should trigger a Fiori launchpad notification to the CSR highlighting the error in an understandable format in addition to logging the error in AIF (to be defined exactly how users will access and reprocess these failed messages)
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 | OrderCreate XML received from SAP CPI | Custom API processes received OrderCreate XML into the specified data structure |
| 2 | OrderCreate XML from SAP CPI maps to Custom API structure | Custom API structure is mapped successfully from received OrderCreate XML |
| 3 | Custom API executes defined logics, mapping and lookups in S/4HANA and creates a sales order | All defined logics, mapping and lookups in S/4HANA executed correctly and sales order is created |
| 4 | OrderCreate XML received with DUNS number not maintained in DUNS Reference Table (ZL2C_DUNS) | Custom API unable to integrate the OrderCreate XML into S/4HANA. Error generated as per error handling process |
| 5 | OrderCreate XML received with PartnerCode (buyer/ShipTo/Payer/BillTo) DUNS number not maintained in EDPAR table | Custom API execute Partner Look Up Logic but unable to find SAP customers to create sales order. Error generated as per error handling process |
| 6 | OrderCreate XML received with material not maintained in S/4HANA Customer Material Info Record (i.e. table KNMT with <MaterialByCustomer> or ShipToParty/SoldToParty) | Custom API execute Field Logic but unable to find Sales Organisation and Distribution Channel, therefore Sales Order is not created. Error generated as per error handling process |
| 7 | OrderCreate XML received with PurchaseOrderTypeCode not in the SalesOrderType mapping table | Sales Order not created as Sales Order Type cannot be derived. Error generated as per error handling process |
| 8 | OrderCreate XML received with PurchaseOrderTypeCode which maps to SalesOrderType that requires a reference contract and finds a valid contract for the sold to, ship to and material | Sales Order created successfully and references the contract. |
| 9 | OrderCreate XML received with PurchaseOrderTypeCode which maps to SalesOrderType that requires a reference contract but no contract exists for any of the sold to, ship to and material | Sales Order not created as reference contract not found. Error generated as per error handling process |
| 10 | OrderCreate XML received with PurchaseOrderTypeCode which maps to SalesOrderType that requires a reference consignment fill up order and consignment fill up order exists | Sales Order created successfully and references the consignment fill up order. |
| 11 | OrderCreate XML received with PurchaseOrderTypeCode which maps to SalesOrderType that requires a reference consignment fill up order but no consignment fill up order exists | Sales Order not created as reference consignment fill up order not found. Error generated as per error handling process |
| 12 | OrderCreate XML received with Purchase Order Number previously sent for which a sales order has been created for the Customer. | Sales Order not created due to duplicate Purchase Order Number. Error generated as per error handling process |
List any considerations essential for application test planning (e.g., test this before ABC along with DEF separate from GHI). If the development encompasses a user interface, explain how to test it. List any insights as to how this component could be tested the most efficiently.
| 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.
