I_SalesOrderImportFieldList

DDL: I_SALESORDERIMPORTFIELDLIST SQL: ISLSORDFLDLIST Type: view BASIC

Field list for Sales Order Import

I_SalesOrderImportFieldList is a Basic CDS View that provides data about "Field list for Sales Order Import" in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 72 fields with key fields SalesOrder, SalesOrderItem.

1 data source(s) 72 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrder _SalesOrder from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISLSORDFLDLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Field list for Sales Order Import view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
KEY SalesOrderItem
SalesOrderType SalesOrderType
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesDistrict SalesDistrict
SalesOffice SalesOffice
SalesGroup SalesGroup
SoldToParty SoldToParty
ShipToParty
BillToParty
PayerParty
SalesEmployee
ResponsibleEmployee
PurchaseOrderByCustomer PurchaseOrderByCustomer
PurchaseOrderByShipToParty PurchaseOrderByShipToParty
CustomerPurchaseOrderDate CustomerPurchaseOrderDate
CustomerPurchaseOrderType CustomerPurchaseOrderType
RequestedDeliveryDate RequestedDeliveryDate
PricingDate PricingDate
SalesOrderDate SalesOrderDate
FixedValueDate FixedValueDate
ShippingCondition ShippingCondition
ShippingType ShippingType
SDDocumentReason SDDocumentReason
DeliveryBlockReason DeliveryBlockReason
HeaderBillingBlockReason HeaderBillingBlockReason
CompleteDeliveryIsDefined CompleteDeliveryIsDefined
IncotermsClassification IncotermsClassification
IncotermsVersion IncotermsVersion
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
TaxDepartureCountry TaxDepartureCountry
VATRegistrationCountry VATRegistrationCountry
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup
AssignmentReference AssignmentReference
PriceListType PriceListType
CustomerPriceGroup CustomerPriceGroup
CustomerGroup CustomerGroup
AdditionalCustomerGroup1 AdditionalCustomerGroup1
AdditionalCustomerGroup2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 AdditionalCustomerGroup3
AdditionalCustomerGroup4 AdditionalCustomerGroup4
AdditionalCustomerGroup5 AdditionalCustomerGroup5
TransactionCurrency TransactionCurrency
AccountingDocExternalReference AccountingDocExternalReference
ServicesRenderedDate ServicesRenderedDate
Material
MaterialByCustomer _Item MaterialByCustomer
ProductStandardID
RequestedQuantity _Item RequestedQuantity
RequestedQuantityUnit _Item RequestedQuantityUnit
SalesOrderItemText _Item SalesOrderItemText
SalesOrderItemCategory _Item SalesOrderItemCategory
Plant _Item Plant
StorageLocation _Item StorageLocation
Batch _Item Batch
ItemBillingBlockReason _Item ItemBillingBlockReason
ShippingPoint _Item ShippingPoint
DeliveryPriority _Item DeliveryPriority
DeliveryGroup _Item DeliveryGroup
MaterialGroup _Item MaterialGroup
MaterialPricingGroup _Item MaterialPricingGroup
ProfitCenter _Item ProfitCenter
MatlAccountAssignmentGroup _Item MatlAccountAssignmentGroup
ConditionRateValue
ConditionCurrency
ConditionQuantity
ConditionQuantityUnit 
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISLSORDFLDLIST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Field list for Sales Order Import'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true

define view I_SalesOrderImportFieldList
  as select from I_SalesOrder as _SalesOrder
{
      //Header Fields

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 10
      }
      ]
  key cast (SalesOrder as slsdoc_temporaryid)               as SalesOrder,

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 10
      }
      ]
  key cast (_Item.SalesOrderItem as slsdoc_itemtemporaryid) as SalesOrderItem,

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 20
      }
      ]
      SalesOrderType,

      //Enterprise Structure

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 30
      }
      ]
      SalesOrganization,

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 40
      }
      ]
      DistributionChannel,

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 50
      }
      ]
      OrganizationDivision,


      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 60
      }
      ]
      SalesDistrict,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 70
      }
      ]
      SalesOffice,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 80
      }
      ]
      SalesGroup,

      //Business Partner

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 90
      }
      //      ,

      //      {

      //      groupLabel: 'Item',

      //      qualifier: 'Item',

      //      position: 500

      //      }

      ]
      SoldToParty,

      @ObjectModel.virtualElement: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 100
      },
      {
      groupLabel: 'Item',
      qualifier: 'Item',
      position: 510
      }
      ]
      cast( '' as kunwe )                                   as ShipToParty,

      @ObjectModel.virtualElement: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 110
      },
      {
      groupLabel: 'Item',
      qualifier: 'Item',
      position: 520
      }]
      cast( '' as kunre )                                   as BillToParty,

      @ObjectModel.virtualElement: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 120
      },
      {
      groupLabel: 'Item',
      qualifier: 'Item',
      position: 530
      }]
      cast( '' as kunrg )                                   as PayerParty,

      @ObjectModel.virtualElement: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 130
      },
      {
      groupLabel: 'Item',
      qualifier: 'Item',
      position: 540
      }]
      cast( '' as sales_empl )                              as SalesEmployee,

      @ObjectModel.virtualElement: true
      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 140
      },
      {
      groupLabel: 'Item',
      qualifier: 'Item',
      position: 550
      }]
      cast( '' as resp_empl )                               as ResponsibleEmployee,

      //Puchase Order in Customer System

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 150
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 200
      }
      ]
      PurchaseOrderByCustomer,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 160
      }
      ]
      PurchaseOrderByShipToParty,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 170
      }
      ]
      CustomerPurchaseOrderDate,

      @UI.fieldGroup: [{
         groupLabel: 'Header',
         qualifier: 'Header',
         position: 180
       }
       ]
      CustomerPurchaseOrderType,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 190
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 70
      }
      ]
      RequestedDeliveryDate,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 200
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 140
      }
      ]
      PricingDate,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 210
      }
      ]
      SalesOrderDate,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 220
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 590
      }
      ]
      FixedValueDate,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 230
      }
      ]
      ShippingCondition,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 240
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 120
      }
      ]
      ShippingType,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 250
      }
      ]
      SDDocumentReason,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 260
      }
      ]
      DeliveryBlockReason,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 270
      }
      ]
      HeaderBillingBlockReason,

      @UI.fieldGroup: [{
         groupLabel: 'Header',
         qualifier: 'Header',
         position: 280
       }
       ]
      CompleteDeliveryIsDefined,

      @UI.fieldGroup: [{
         groupLabel: 'Header',
         qualifier: 'Header',
         position: 290
       },
       {
         groupLabel: 'Item',
         qualifier: 'Item',
         position: 560
       }
       ]
      IncotermsClassification,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 300
      }
      ]
      IncotermsVersion,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 310
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 570
      }
      ]
      IncotermsLocation1,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 320
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 580
      }
      ]
      IncotermsLocation2,

      @UI.fieldGroup: [{
         groupLabel: 'Header',
         qualifier: 'Header',
         position: 330
       },
       {
         groupLabel: 'Item',
         qualifier: 'Item',
         position: 590
       }
       ]
      CustomerPaymentTerms,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 340
      }
      ]
      PaymentMethod,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 350
      }
      ]
      TaxDepartureCountry,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 360
      }
      ]
      VATRegistrationCountry,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 370
      }
      ]
      CustomerAccountAssignmentGroup,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 380
      }
      ]
      AssignmentReference,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 390
      }
      ]
      PriceListType,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 400
      }
      ]
      CustomerPriceGroup,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 410
      },
      {
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 620
      }
      ]
      CustomerGroup,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 420
      }
      ]
      AdditionalCustomerGroup1,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 430
      }
      ]
      AdditionalCustomerGroup2,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 440
      }
      ]
      AdditionalCustomerGroup3,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 450
      }
      ]
      AdditionalCustomerGroup4,

      @UI.fieldGroup: [{
       groupLabel: 'Header',
       qualifier: 'Header',
       position: 460
      }
      ]
      AdditionalCustomerGroup5,

      @UI.fieldGroup: [{
        groupLabel: 'Header',
        qualifier: 'Header',
        position: 470
      }
      ]
      TransactionCurrency,
      @UI.fieldGroup: [
         {
           groupLabel: 'Header',
           qualifier: 'Header',
           position: 480
         }
         ]
      AccountingDocExternalReference,
      @UI.fieldGroup: [
         {
           groupLabel: 'Header',
           qualifier: 'Header',
           position: 490
         },
         {
           groupLabel: 'Item',
           qualifier: 'Item',
           position: 620
         }
         ]
      ServicesRenderedDate,      

      //Item Fields

      @ObjectModel.mandatory: true
      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 20
      }
      ]
      cast(_Item.Material as productnumber preserving type) as Material,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 30
      }
      ]
      _Item.MaterialByCustomer,

      @ObjectModel.virtualElement: true
      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 40
      }]
      cast( '' as globaltradeitemnumber )                   as ProductStandardID,

      @ObjectModel.mandatory: true
      @Semantics.quantity.unitOfMeasure: 'RequestedQuantityUnit'
      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 50
      }
      ]
      _Item.RequestedQuantity,

      @Semantics.unitOfMeasure: true
      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 60
      }
      ]
      _Item.RequestedQuantityUnit,

      //Item Description in position 80 (Item Requested Delivery Date in position 70)

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 80
      }
      ]
      _Item.SalesOrderItemText,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 90
      }
      ]
      _Item.SalesOrderItemCategory,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 100
      }
      ]
      _Item.Plant,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 110
      }
      ]
      _Item.StorageLocation,


      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 130
      }
      ]
      _Item.Batch,


      //Item Pricing Date in Postion 130

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 150
      }
      ]
      _Item.ItemBillingBlockReason,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 160
      }
      ]
      _Item.ShippingPoint,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 170
      }
      ]
      _Item.DeliveryPriority,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 180
      }
      ]
      _Item.DeliveryGroup,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 190
      }
      ]
      _Item.MaterialGroup,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 210
      }
      ]
      _Item.MaterialPricingGroup,

      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 220
      }
      ]
      _Item.ProfitCenter,


      @UI.fieldGroup: [{
        groupLabel: 'Item',
        qualifier: 'Item',
        position: 610
      }
      ]
      _Item.MatlAccountAssignmentGroup,

      //Item Condition Fields

      @UI.fieldGroup: [
      {
        groupLabel: 'Header',
        qualifier: 'HEADER_PRICE',
        valueQualifier: 'CONDTYPE',
        position: 1000
      },
      {
        groupLabel: 'Item',
        qualifier: 'ITEM_PRICE',
        valueQualifier: 'CONDTYPE',
        position: 1000
      }
      ]
      cast( 1 as vfprc_rate_amount )                        as ConditionRateValue,

      @UI.fieldGroup: [
      {
        groupLabel: 'Header',
        qualifier: 'HEADER_PRICE',
        valueQualifier: 'CONDTYPE',
        position: 1010
      },
      {
      groupLabel: 'Item',
      qualifier: 'ITEM_PRICE',
      valueQualifier: 'CONDTYPE',
      position: 1010
      }
      ]
      cast( '' as waers )                                   as ConditionCurrency,

      @Semantics.quantity.unitOfMeasure: 'ConditionQuantityUnit'
      @UI.fieldGroup: [
      {
        groupLabel: 'Header',
        qualifier: 'HEADER_PRICE',
        valueQualifier: 'CONDTYPE',
        position: 1020
      },
      {
        groupLabel: 'Item',
        qualifier: 'ITEM_PRICE',
        valueQualifier: 'CONDTYPE',
        position:1020
      }
      ]
      cast( 1 as kpein )                                    as ConditionQuantity,

      @UI.fieldGroup: [
      {
        groupLabel: 'Header',
        qualifier: 'HEADER_PRICE',
        valueQualifier: 'CONDTYPE',
        position: 1030
      },
      {
        groupLabel: 'Item',
        qualifier: 'ITEM_PRICE',
        valueQualifier: 'CONDTYPE',
        position: 1030
      }
      ]
      cast( '' as kvmei )                                   as ConditionQuantityUnit

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESORDER",
"I_SALESORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More