C_SlsDocFlfmtPurgDoc

DDL: C_SLSDOCFLFMTPURGDOC SQL: CSOFPURGDOC Type: view CONSUMPTION

Sales Doc Fulfillment: Purchasing Doc

C_SlsDocFlfmtPurgDoc is a Consumption CDS View that provides data about "Sales Doc Fulfillment: Purchasing Doc" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocument) and exposes 13 fields with key field PurchasingDocument. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocument PurchasingDocument from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderStatus _PurchaseOrderStatus $projection.PurchasingDocument = _PurchaseOrderStatus.PurchaseOrder
[0..1] I_PurchasingDocumentStatus _Status $projection.PurchasingDocumentStatus = _Status.PurchasingDocumentStatus
[0..1] E_PurchasingDocument _Extension $projection.PurchasingDocument = _Extension.PurchasingDocument

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Doc Fulfillment: Purchasing Doc view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
Search.searchable false view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CSOFPURGDOC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocument PurchasingDocument
PurchasingDocumentType I_PurchasingDocument PurchasingDocumentType
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory
PurchasingDocumentStatus
PurchasingGroup PurchasingGroup
PurchasingGroupName _PurchasingGroup PurchasingGroupName
PurchasingOrganization PurchasingOrganization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName
Supplier Supplier
SupplierName _Supplier SupplierName
_PurchasingDocumentType _PurchasingDocumentType
_PurchasingDocumentCategory _PurchasingDocumentCategory
_Status _Status 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S

@EndUserText.label: 'Sales Doc Fulfillment: Purchasing Doc'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@Search.searchable: false
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'CSOFPURGDOC'

define view C_SlsDocFlfmtPurgDoc
  as select from I_PurchasingDocument as PurchasingDocument

  association [1..1] to I_PurchaseOrderStatus      as _PurchaseOrderStatus on $projection.PurchasingDocument = _PurchaseOrderStatus.PurchaseOrder
  association [0..1] to I_PurchasingDocumentStatus as _Status              on $projection.PurchasingDocumentStatus = _Status.PurchasingDocumentStatus

  //Extensibility

  association [0..1] to E_PurchasingDocument       as _Extension           on $projection.PurchasingDocument = _Extension.PurchasingDocument
{
      // Key

  key PurchasingDocument.PurchasingDocument,

      PurchasingDocument.PurchasingDocumentType,
      PurchasingDocument.PurchasingDocumentCategory,

      @ObjectModel.foreignKey.association: '_Status'
      cast ( _PurchaseOrderStatus.PurchasingDocumentStatus as meprocstate ) as PurchasingDocumentStatus,

      // Organization

      @ObjectModel.text.element:  [ 'PurchasingGroupName' ]
      PurchasingGroup,
      @Semantics.text: true
      _PurchasingGroup.PurchasingGroupName,

      @ObjectModel.text.element:  [ 'PurchasingOrganizationName' ]
      PurchasingOrganization,
      @Semantics.text: true
      _PurchasingOrganization.PurchasingOrganizationName,

      // Partner

      @ObjectModel.text.element:  [ 'SupplierName' ]
      Supplier,
      @Semantics.text: true
      _Supplier.SupplierName,

      //Associations

      _PurchasingDocumentType,
      _PurchasingDocumentCategory,
      _Status

}

where
      PurchasingDocumentDeletionCode <> 'X'
  and PurchasingDocumentCategory     =  'F' // more categories maybe later

  and IsEndOfPurposeBlocked = '' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERSTATUS",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"E_PURCHASINGDOCUMENT",
"I_PURCHASEORDERSTATUS",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGDOCUMENTSTATUS",
"I_PURCHASINGDOCUMENTTYPE"
],
"BASE":
[
"I_PURCHASINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More