P_VARCONFIGNPURCHASINGDOCUMENT

CDS View

Simulation - Purchasing Document private view

P_VARCONFIGNPURCHASINGDOCUMENT is a CDS View in S/4HANA. Simulation - Purchasing Document private view. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SimulationObjectSearch view left_outer CONSUMPTION Simulation - Simulation Objects Search

Fields (1)

KeyField CDS FieldsUsed in Views
PurchasingDocumentType PurchasingDocumentType 1 
@AbapCatalog.sqlViewName: 'PAVCPURGDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@VDM.private: true
define view P_VarConfignPurchasingDocument
  as select from ekko as PurchasingDocument
{
  key PurchasingDocument.ebeln                     as PurchasingDocument,

      PurchasingDocument.bstyp                     as PurchasingDocumentCategory,
      PurchasingDocument.ernam                     as CreatedByUser,
      PurchasingDocument.aedat                     as CreationDate,
      PurchasingDocument.ernam                     as LastChangedByUser,
      tstmp_to_dats( PurchasingDocument.lastchangedatetime ,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                      as LastChangeDate,


      //Authorization checks needed fields

      PurchasingDocument.iseopblocked              as IsEndOfPurposeBlocked,
      PurchasingDocument.bsart                     as PurchasingDocumentType,
      PurchasingDocument.ekorg                     as PurchasingOrganization,
      PurchasingDocument.ekgrp                     as PurchasingGroup


}
where
      bstyp  = 'F' //Purchase Order (PO)

  and loekz  = '' //Deletion marker

  and isaged = '' //PurchasingDocumentIsAged

Learn More