P_SLSDOCAUTOMCOMPLTNSRCEDATA

CDS View

Source Dataset for Sales Document Automatic Completion

P_SLSDOCAUTOMCOMPLTNSRCEDATA is a CDS View in S/4HANA. Source Dataset for Sales Document Automatic Completion. It contains 10 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 10 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsDocAutomCompltnDataSet view_entity from COMPOSITE Training Dataset for Sales Order Automatic Completion

Fields (10)

KeyField CDS FieldsUsed in Views
KEY SalesDocument SalesDocument 1
KEY SalesDocumentItem SalesDocumentItem 1
BillToParty BillToParty 1
PayerParty PayerParty 1
Plant Plant 1
Product Product 1
SalesDocumentItemCategory SalesDocumentItemCategory 1
ShippingPoint ShippingPoint 1
ShipToParty ShipToParty 1
SoldToParty SoldToParty 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Source Dataset for Sales Document Automatic Completion'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #COMPOSITE,
  private: true,
  lifecycle.contract.type: #NONE
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity P_SlsDocAutomCompltnSrceData
  as select from I_SalesDocumentItem as SalesDocumentItem
{
      
  key SalesDocumentItem.SalesDocument,
  key SalesDocumentItem.SalesDocumentItem,


      SalesDocumentItem._SalesDocument.SalesOffice,
      SalesDocumentItem._SalesDocument.SalesGroup,
      SalesDocumentItem._SalesDocument.CustomerPaymentTerms,
      SalesDocumentItem._SalesDocument.IncotermsClassification,
      SalesDocumentItem._SalesDocument.ShippingCondition,
      SalesDocumentItem.Plant,
      SalesDocumentItem.ShippingPoint,


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

      SalesDocumentItem.SoldToParty            as SoldToParty,
      SalesDocumentItem._SoldToParty.AddressID as SoldToPartyAddressID,

      SalesDocumentItem.ShipToParty            as ShipToParty,
      SalesDocumentItem._ShipToParty.AddressID as ShipToPartyAddressID,

      SalesDocumentItem.BillToParty            as BillToParty,
      SalesDocumentItem._BillToParty.AddressID as BillToPartyAddressID,

      SalesDocumentItem.PayerParty             as PayerParty,
      SalesDocumentItem._PayerParty.AddressID  as PayerPartyAddressID,

      //Fields for filter

      SalesDocumentItem._SalesDocument.SDDocumentCategory,
      SalesDocumentItem._SalesDocument.CreationDate,
      SalesDocumentItem._SalesDocument.CreationTime,
      SalesDocumentItem._SalesDocument.OverallSDProcessStatus,

      //Association

      _SalesDocument

}

Learn More