I_FLDLOGSEXTLINKSFORPURDOCS

CDS View

Field Logistics : Doc Flow STO Linkage

I_FLDLOGSEXTLINKSFORPURDOCS is a CDS View in S/4HANA. Field Logistics : Doc Flow STO Linkage. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FldLogsKitOutbDelivGRRef view_entity from COMPOSITE Kit Outbound delivery from goods receipt reference
I_FldLogsLinksForSTO view_entity from COMPOSITE Field Logistics links for STOs

Fields (5)

KeyField CDS FieldsUsed in Views
KEY StockTransportOrder StockTransportOrder 1
KEY StockTransportOrderItem StockTransportOrderItem 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1 
@AbapCatalog.sqlViewName: 'IFLMMDOCLINKS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #M
@EndUserText.label: 'Field Logistics : Doc Flow STO Linkage'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_FldLogsExtLinksForPurDocs
  // Document links

  as select from mmdoc_ext_links
{
  key    cast(SUBSTRING( businessdocumentuniqueid, 1, 10 ) as ebeln) as StockTransportOrder,
  key    cast(SUBSTRING( businessdocumentuniqueid, 11, 5 ) as ebelp) as StockTransportOrderItem,
         SUBSTRING( externaldocumentid, 1, 10)                       as MaterialDocument,
         cast(SUBSTRING( externaldocumentid, 11, 4) as mjahr)        as MaterialDocumentYear,
         cast(SUBSTRING( externaldocumentid, 15, 4) as mblpo)        as MaterialDocumentItem
}
where
      linktype                 = 'PD'
  // Preceding Document

  and sapbonodetype            = 'PurchaseOrderItem'
  and businessdocumentuniqueid is not initial // STO

  and externaldocumenttype     = 'MaterialDocumentItem'
  and externaldocumentid       is not initial; // Material Document

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

Learn More