I_SlsDocAutomCompltnDataSet

DDL: I_SLSDOCAUTOMCOMPLTNDATASET Type: view_entity COMPOSITE Package: VDM_SD_SLS_AUTOCOMPLTN

Training Dataset for Sales Order Automatic Completion

I_SlsDocAutomCompltnDataSet is a Composite CDS View that provides data about "Training Dataset for Sales Order Automatic Completion" in SAP S/4HANA. It reads from 5 data sources (I_Customer, I_Customer, I_Customer, I_Customer, P_SlsDocAutomCompltnSrceData) and exposes 31 fields with key fields SalesDocument, SalesDocumentItem. Part of development package VDM_SD_SLS_AUTOCOMPLTN.

5 data source(s) 31 fields

Data Sources (5)

SourceAliasJoin Type
I_Customer BillToParty inner
I_Customer PayerParty inner
I_Customer ShipToParty inner
I_Customer SoldToParty inner
P_SlsDocAutomCompltnSrceData SourceDataSet from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Training Dataset for Sales Order Automatic Completion view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument P_SlsDocAutomCompltnSrceData SalesDocument
KEY SalesDocumentItem P_SlsDocAutomCompltnSrceData SalesDocumentItem
SalesOffice
SalesGroup
CustomerPaymentTerms
ShippingCondition
Plant P_SlsDocAutomCompltnSrceData Plant
ShippingPoint P_SlsDocAutomCompltnSrceData ShippingPoint
SalesDocumentType
SalesOrganization
DistributionChannel
OrganizationDivision
BillingCompanyCode
TransactionCurrency
SalesDocumentItemCategory P_SlsDocAutomCompltnSrceData SalesDocumentItemCategory
Product P_SlsDocAutomCompltnSrceData Product
SoldToParty P_SlsDocAutomCompltnSrceData SoldToParty
SoldToPartyCountry SoldToPartyAddress Country
SoldToPartyRegion SoldToPartyAddress Region
ShipToParty P_SlsDocAutomCompltnSrceData ShipToParty
ShipToCountry ShipToPartyAddress Country
ShipToPartyRegion ShipToPartyAddress Region
BillToParty P_SlsDocAutomCompltnSrceData BillToParty
BillToPartyCountry BillToPartyAddress Country
BillToPartyRegion BillToPartyAddress Region
PayerParty P_SlsDocAutomCompltnSrceData PayerParty
PayerCountry BillToPartyAddress Country
PayerRegion PayerPartyAddress Region
SDDocumentCategory
CreationDate
CreationTime 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Training Dataset for Sales Order Automatic Completion'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view entity I_SlsDocAutomCompltnDataSet
  as select from           P_SlsDocAutomCompltnSrceData as SourceDataSet
    inner join             I_Customer                   as SoldToParty        on SoldToParty.Customer = SourceDataSet.SoldToParty
    inner join             I_Customer                   as ShipToParty        on ShipToParty.Customer = SourceDataSet.ShipToParty
    inner join             I_Customer                   as BillToParty        on BillToParty.Customer = SourceDataSet.BillToParty
    inner join             I_Customer                   as PayerParty         on PayerParty.Customer = SourceDataSet.PayerParty
    left outer to one join I_AddrOrgNamePostalAddress   as SoldToPartyAddress on SoldToPartyAddress.AddressID = SourceDataSet.SoldToPartyAddressID
                                                                             and SoldToPartyAddress.AddressRepresentationCode is initial
    left outer to one join I_AddrOrgNamePostalAddress   as ShipToPartyAddress on ShipToPartyAddress.AddressID = SourceDataSet.ShipToPartyAddressID
                                                                             and ShipToPartyAddress.AddressRepresentationCode is initial
    left outer to one join I_AddrOrgNamePostalAddress   as BillToPartyAddress on BillToPartyAddress.AddressID = SourceDataSet.BillToPartyAddressID
                                                                             and BillToPartyAddress.AddressRepresentationCode is initial
    left outer to one join I_AddrOrgNamePostalAddress   as PayerPartyAddress  on PayerPartyAddress.AddressID = SourceDataSet.PayerPartyAddressID
                                                                             and PayerPartyAddress.AddressRepresentationCode is initial
{
      //Keys should be excluded from DataSet

  key SourceDataSet.SalesDocument,
  key SourceDataSet.SalesDocumentItem,


      SourceDataSet._SalesDocument.SalesOffice,
      SourceDataSet._SalesDocument.SalesGroup,
      SourceDataSet._SalesDocument.CustomerPaymentTerms,
      SourceDataSet._SalesDocument.ShippingCondition,
      SourceDataSet.Plant,
      SourceDataSet.ShippingPoint,


      SourceDataSet._SalesDocument.SalesDocumentType,
      SourceDataSet._SalesDocument.SalesOrganization,
      SourceDataSet._SalesDocument.DistributionChannel,
      SourceDataSet._SalesDocument.OrganizationDivision,
      SourceDataSet._SalesDocument.BillingCompanyCode,
      SourceDataSet._SalesDocument.TransactionCurrency,
      SourceDataSet.SalesDocumentItemCategory,
      SourceDataSet.Product,

      SourceDataSet.SoldToParty  as SoldToParty,
      SoldToPartyAddress.Country as SoldToPartyCountry,
      SoldToPartyAddress.Region  as SoldToPartyRegion,

      SourceDataSet.ShipToParty  as ShipToParty,
      ShipToPartyAddress.Country as ShipToCountry,
      ShipToPartyAddress.Region  as ShipToPartyRegion,

      SourceDataSet.BillToParty  as BillToParty,
      BillToPartyAddress.Country as BillToPartyCountry,
      BillToPartyAddress.Region  as BillToPartyRegion,

      SourceDataSet.PayerParty   as PayerParty,
      BillToPartyAddress.Country as PayerCountry,
      PayerPartyAddress.Region   as PayerRegion,


      //Fields for filter

      SourceDataSet._SalesDocument.SDDocumentCategory,
      SourceDataSet._SalesDocument.CreationDate,
      SourceDataSet._SalesDocument.CreationTime
}
where
       SourceDataSet._SalesDocument.SDDocumentCategory     = 'C'
  and  SourceDataSet._SalesDocument.OverallSDProcessStatus = 'C'
  and  SoldToParty.IsBusinessPurposeCompleted = ''
  and  ShipToParty.IsBusinessPurposeCompleted = ''
  and  BillToParty.IsBusinessPurposeCompleted = ''
  and  PayerParty.IsBusinessPurposeCompleted = ''

Learn More