| Status | Approved |
|---|---|
| Owner | |
| Stakeholders | GONZALVEZ-ext, Antonio Jean-christophe Pham ngoc thuan |
| Jira Request ID | ERP-1740 - Getting issue details... STATUS |
| Jira Development ID | ERP-2097 - Getting issue details... STATUS |
High- Level Specification
| Implementing System | SAP S/4HANA |
|---|---|
| Invoked by/Invokes | ERP-1138 - Getting issue details... STATUS |
| Business Process Reference | 02.04.02.01. Manage Standard Sales Order |
Functional Overview
EDI customers sends their Sales Order creation message through Elemica to Syensqo. Elemica sends the OrderCreate XML to SAP CPI which then calls a custom API to create the Sales Order in Syensqo's S/4HANA system.
The purpose of this functional specification is to create the custom API for the creation of a sales order in S/4HANA either
- From data directly available in the Elemica XML or
- from data derived from S/4HANA based on data in the Elemica XML.
Scope and Objectives
This System Interface, a custom implementation in SAP S/4HANA,
- consumes the OrderCreate data from SAP CPI
- maps this data into a structure to create a sales order in SAP S/4HANA
- transform some data OrderCreate message from SAP CPI into the Sales Order structure in S/4HANA
- performs lookup of specified data (as applicable) in S/4HANA
- stored certain data from OrderCreate message from SAP CPI into a S/4HANA custom table
The standard SAP Sales Order API is unable to support the above functions, hence the need for a custom API.
Process Flow Diagram
Step | Description | Comment |
|---|---|---|
1 | Based on the purchase order received from Syensqo's EDI customer, Elemica converts this into OrderCreate message and sends to SAP CPI via API Management |
|
2. | SAP CPI receives the OrderCreate XML message from Elemica and maps to SAP Sales Order in S/4HANA. To create the Sales Order, SAP CPI calls the custom API which is the scope of this functional specification | This is covered in Integration Process functional specification ERP-1138 - Getting issue details... STATUS |
3 | Sales Order is created in SAP S/4HANA based on the message received from SAP CPI |
Assumptions
- The custom Sales Order Create API will be called from SAP CPI and be able to lookup data from SAP S/4HANA to feed the target structure to create the sales order
- The source object and S/4HANA System target field mappings, including custom fields, will be updated based on mapping requirements in S/4HANA System.
- The Custom API should be able to map all source and target mappings to successfully create a sales order
Dependencies
- All configurations in S/4HANA from where the custom API should look up values should already be implemented before the interface is deployed.
- Connection between SAP CPI and S/4HANA already set up
- Required master data in S/4HANA already loaded
Security, Integrity and Controls
- Required authorisations to execute the custom API need to be defined.
- Existing secure connectivity for communication between SAP S/4HANA and SAP CPI will be applied.
Configuration Requirements
- Text IDs VBBK-Z002, VBBK-Z004, VBBK-Z999, VBBP-Z999
- User status ZECB
- Sales Order Types
Special Requirements
N/A
Design Rationale
API Use
Custom API based on API_SALES_ORDER_SRV_0001
Data Structure
The following fields will be used to provide the required data structure of the interface:
| Parent | Cardinality | Field | Description | Mandatory (Y/N) | Data Type |
|---|---|---|---|---|---|
| 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 |
Calculation and Mapping
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 sales order field | 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 | 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 |
Processing Logic
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 stored this sets of data, keep them updated (where required) and reference them when outbound messages 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, move to step 2
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
Move to step 2
Step 2: Find check pricing validity
For each of the materials in the sales order being created, for which a contract is found, check the condition record for the material that the valid to date is same or later than the requested delivery date of the sales order being created
Assumption: Pricing condition record will use key combination: Customer / Contract No / Contract Item / Material (exact condition table / key combination will be confirmed after configuration)
Step 2a: check the pricing “valid to” date in condition table (ZXXX – exact value to be determined after configuration)
Valid to date is AXXX-DATBI
From table AXXX, read AXXX-DATBI where:
AXXX-KSCHL = PPR0
AXXX-KUNNR = SoldToParty
AXXX-VGBEL = Contract Number (VBAK-VBELN)
AXXX-VGPOS = ContractItem (VBAP-POSNR)
AXXX-MATNR = Material (VBAP-MATNR)
Step 2b: Compare Valid to date with Requested Delivery Date
If valid to date is greater than Requested Delivery Date, then pricing is valid and sales order can be created
If Requested Delivery Date is greater than valid to date, then there is no valid price. Sales Order should be created without price (and goes to incompletion log)
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)
Delta or Full Load Requirements
Interface Alert & Monitoring
Monitoring will be done via AIF.
Language Requirements
English
User Interface Requirements
NA
Sequencing
N/A
Volumetrics
circa 450 inbound OrderCreate messages per month
Performance Consideration
Error Handling
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)
Testing
How to Test
Test Conditions and Expected Results
| 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 |
Test Considerations/Dependencies
Other Information
Development Details
Package
| Package Name | Parent Package |
|---|---|
Other Development Objects
| Object Type | Object Name | Purpose/High Level Logic | Design Rationale Reference |
|---|---|---|---|