CDS View Sales Order Information

-
@AbapCatalog.sqlViewName: 'ZSALESORDER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Order Information'
define view ZTest1 as select from afko as salesOrderHeader
  inner join afpo as salesOrderItem on salesOrderHeader.aufnr = salesOrderItem.aufnr
  inner join resb as reservation on salesOrderHeader.rsnum = reservation.rsnum
  inner join mara as materialMaster on reservation.matnr = materialMaster.matnr
  inner join marc as plantSpecific on reservation.matnr = plantSpecific.matnr and salesOrderItem.dwerk = plantSpecific.werks
  inner join mara as materialMasterPlanned on salesOrderHeader.plnbez = materialMasterPlanned.matnr
  inner join t023t as materialTypeDescription on materialMasterPlanned.matkl = materialTypeDescription.matkl
{
  key salesOrderHeader.aufnr as SalesOrderNumber,
      salesOrderHeader.plnbez as PlannedMaterialNumber,
      salesOrderHeader.gamng as TotalOrderQuantity,
      salesOrderHeader.gmein as OrderQuantityUnit,
      salesOrderHeader.gstri as OrderStart,
      salesOrderHeader.dispo as MRPController,
      salesOrderHeader.aprio as MRPPriority,
      salesOrderItem.ltrmi as VendorConfirmationDate,
      salesOrderItem.ablad as UnloadingPoint,
      salesOrderItem.charg as Batch,
      salesOrderItem.wempf as ShippingPoint,
      salesOrderItem.kdauf as SalesDocument,
      salesOrderItem.kdpos as SalesDocumentItem,
      reservation.matnr as ReservationMaterialNumber,
      reservation.bdmng as ReservationQuantity,
      reservation.meins as ReservationUnit,
      reservation.xloek as MaterialDeletionIndicator,
      salesOrderHeader.gstrp as OrderStartPlanned,
      salesOrderHeader.gltrp as OrderEndPlanned,
      salesOrderItem.wemng as GoodsMovementQuantity,
      salesOrderItem.lgort as StorageLocation,
      salesOrderHeader.cy_seqnr as CycleSequenceNumber,
      salesOrderHeader.aufpl as PlannedOrderNumber,
      materialMasterPlanned.bismt as AssemblyMaterial
} 

Comments

Post a Comment

Popular posts from this blog

all user exit mv45afzz (implicit user exit )

-
MV45AFZZ this is included here all code put related to sales order creation while creating a sales order  va01 this exit trigger so as per your requirement we can write your code here I going to listed different type exit as per the real requirement you find the code and develop your business scenario INCLUDE MV45AFZZ . Modify Screen VA01/VA02/VA03 How to Activated and Deactivated Screen  Export Memory example While Creating a sales order  How to Call workflow While Creating a sales order  TYPES  :  BEGIN  OF  ty_vbak ,           KVGR1  TYPE  vbak - KVGR1 ,           KVGR2  TYPE  vbak - KVGR2 ,          END  OF  ty_vbak . DATA  :  ls_vbak  TYPE  ty_vbak . IF  sy - tcode  =  'VA02'  and  sy - uname  =  'FREDDIE' . BREAK freddie . *SELECT SINGLE KVGR1 KVGR2 *  FROM vbak *  INTO ls_vbak * WHERE vbeln = vbak-vbeln. * *IF vbak-KVGR1 <> ls_vbak-KVGR1 or vbak-KVGR2 <> ls_vbak-KVGR2. *  VBAK-FAKSK = '05'.
Read more

Long Text in input and output field in module pool

-
Image
display long text in input and output field then below code help you how to display long text your input and output fields in sap ************************************************************************ * Program Name      :  ZLONG_TEXT_EDITOR           Object ID:   p002    * * Description       :  Long text with function module                   * * Create Date       :  26.12.2018                                      * * FO Owner          :  Rohini kumar                                    * * Tech Owner        :  Rohini Kumar                                    * * Project Module    :  SD                                              * ************************************************************************ *                        Change Log                                    * ************************************************************************ *  REQ#         DATE         WHO            CHANGE_ID        DESCR     * *-------------------------------------------
Read more

MB_MIGO_BADI THIS BADI USED TO POSTING DATA IN MIGO

-
Here this badi used to how to work migo data migration and help to creating magi used to save  and validation of data  MB_DOCUMENT_UPDATE method  IF_EX_MB_MIGO_BADI ~ POST_DOCUMENT .    BREAK-POINT .    IF  is_mkpf - budat < is_mkpf - BLDAT .     sy - ucomm  =  'ENT1' .      MESSAGE  'Posting Date Should Not Be Less Than Document Date'   TYPE  'E'  .      SET SCREEN  syst - dynnr .      LEAVE SCREEN .    ENDIF . endmethod .
Read more