I_PurgDocListStatus

DDL: I_PURGDOCLISTSTATUS SQL: IPURGDOCSTS Type: view COMPOSITE

Purchasing Document Status

I_PurgDocListStatus is a Composite CDS View that provides data about "Purchasing Document Status" in SAP S/4HANA. It reads from 4 data sources (dd07l, I_PurchaseOrderStatusValueHelp, I_Processingstatus, I_SupplierInvoiceStatusOrigin) and exposes 10 fields with key fields Status, PurchasingDocumentType, PurchasingDocumentType, PurchasingDocumentType, PurchasingDocumentType. It has 2 associations to related views.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
dd07l _GRStatus union_all
I_PurchaseOrderStatusValueHelp _POStatus union_all
I_Processingstatus _PRStatus union_all
I_SupplierInvoiceStatusOrigin _SIStatus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PurgDocTypeSubset _DocType $projection.PurchasingDocumentType = _DocType.PurchasingDocumentType
[0..1] dd07t _Text $projection.Status = _Text.domvalue_l and _Text.ddlanguage = $session.system_language and _Text.domname = 'MM_PUR_INV_DOC_STATUS'

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPURGDOCSTS view
EndUserText.label Purchasing Document Status view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey Status view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Status InvoiceStatusAndOrigin
KEY PurchasingDocumentType
StatusName
KEY PurchasingDocumentType
StatusName
KEY PurchasingDocumentType
StatusName PurchasingDocumentStatusName
KEY PurchasingDocumentType
StatusName _Text ddtext
_DocType _DocType 
@AbapCatalog.sqlViewName: 'IPURGDOCSTS'
@EndUserText.label: 'Purchasing Document Status'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'Status'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true

define view I_PurgDocListStatus
  as select from I_SupplierInvoiceStatusOrigin as _SIStatus

  association [0..1] to I_PurgDocTypeSubset as _DocType on $projection.PurchasingDocumentType = _DocType.PurchasingDocumentType

{
  key InvoiceStatusAndOrigin                                                                        as Status,
      @ObjectModel.foreignKey.association: '_DocType'
  key cast('3' as numc1)                                                                            as PurchasingDocumentType,
      _SupplierInvoiceStsOriginText[1:Language=$session.system_language].InvoiceStatusAndOriginDesc as StatusName,
      _DocType
}

union all select from I_Processingstatus as _PRStatus

association [0..1] to I_PurgDocTypeSubset as _DocType on $projection.PurchasingDocumentType = _DocType.PurchasingDocumentType
{
  key ProcessingStatus                                                as Status,
      @ObjectModel.foreignKey.association: '_DocType'
  key cast('0' as numc1)                                              as PurchasingDocumentType,
      _Text[1:Language=$session.system_language].ProcessingStatusName as StatusName,
      _DocType
}

union all select from I_PurchaseOrderStatusValueHelp as _POStatus

association [0..1] to I_PurgDocTypeSubset as _DocType on $projection.PurchasingDocumentType = _DocType.PurchasingDocumentType
{
  key PurchasingDocumentStatus     as Status,
      @ObjectModel.foreignKey.association: '_DocType'
  key cast('1' as numc1)           as PurchasingDocumentType,
      PurchasingDocumentStatusName as StatusName,
      _DocType
}

union all select from dd07l as _GRStatus

association [0..1] to I_PurgDocTypeSubset as _DocType on  $projection.PurchasingDocumentType = _DocType.PurchasingDocumentType

association [0..1] to dd07t               as _Text    on  $projection.Status = _Text.domvalue_l
                                                      and _Text.ddlanguage   = $session.system_language
                                                      and _Text.domname      = 'MM_PUR_INV_DOC_STATUS'
{
  key domvalue_l         as Status,
      @ObjectModel.foreignKey.association: '_DocType'
  key cast('2' as numc1) as PurchasingDocumentType,
      _Text.ddtext       as StatusName,
      _DocType
}
where
       _GRStatus.domname    = 'MM_PUR_INV_DOC_STATUS'
  and  _GRStatus.as4local   = 'A'
  and  _GRStatus.as4vers    = '0000'
  and(
       _GRStatus.domvalue_l = '14'
    or _GRStatus.domvalue_l = '22'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROCESSINGSTATUS",
"I_PROCESSINGSTATUSTEXT",
"I_PURCHASEORDERSTATUSVALUEHELP",
"I_SUPPLIERINVOICESTATUSORIGIN",
"I_SUPPLIERINVOICESTSORIGINTEXT",
"DD07L",
"DD07T"
],
"ASSOCIATED":
[
"I_PURGDOCTYPESUBSET"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More