P_VarConfignPurchasingDocument

DDL: P_VARCONFIGNPURCHASINGDOCUMENT SQL: PAVCPURGDOC Type: view BASIC

P_VarConfignPurchasingDocument is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 10 fields with key field PurchasingDocument.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
ekko PurchasingDocument from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PAVCPURGDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument ekko ebeln
PurchasingDocumentCategory ekko bstyp
CreatedByUser ekko ernam
CreationDate ekko aedat
LastChangedByUser ekko ernam
clientNULLasLastChangeDate
IsEndOfPurposeBlocked ekko iseopblocked
PurchasingDocumentType ekko bsart
PurchasingOrganization ekko ekorg
PurchasingGroup ekko ekgrp 
@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

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

Learn More