P_IntactvABOPRqmtAddlFields

DDL: P_INTACTVABOPRQMTADDLFIELDS Type: view_entity COMPOSITE
8 Fields 2 Data Sources

IBOP Requirements Additional Fields View

P_IntactvABOPRqmtAddlFields is a Composite CDS View that provides data about "IBOP Requirements Additional Fields View" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentScheduleLine, I_StockTransptOrdScheduleLine) and exposes 8 fields with key fields ATPRelevantDocument, ATPRelevantDocumentItem, ATPRelevantDocScheduleLine, ATPRelevantDocumentItem, ATPRelevantDocScheduleLine.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentScheduleLine _SalesDocumentScheduleLine from
I_StockTransptOrdScheduleLine _StockTransptOrdScheduleLine union

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IBOP Requirements Additional Fields View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ATPRelevantDocument SalesDocument SD Document
KEY ATPRelevantDocumentItem SalesDocumentItem Sales Document Item
KEY ATPRelevantDocScheduleLine ScheduleLine Schedule Line
ATPFCFSPriorityValue FCFS Priority
KEY ATPRelevantDocumentItem Sales Document Item
KEY ATPRelevantDocScheduleLine ScheduleLine Schedule Line
ATPFCFSPriorityValue FCFS Priority
ATPRelevantDocumentItemKey

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_IntactvABOPRqmtAddlFields.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_IntactvABOPRqmtAddlFields AS
SELECT
  SalesDocument AS ATPRelevantDocument,
  SalesDocumentItem AS ATPRelevantDocumentItem,
  ScheduleLine AS ATPRelevantDocScheduleLine,
  cast( ATPFCFSPriorityValue as ibop_fcfs_priority ) AS ATPFCFSPriorityValue,
  cast( concat( concat(ltrim(PurchaseOrder,'0'),'/'),ltrim(PurchaseOrderItem,'0') ) as ibop_relevant_doc_and_item ) AS ATPRelevantDocumentItemKey
FROM I_SalesDocumentScheduleLine AS _SalesDocumentScheduleLine
-- UNION with additional select branch(es): I_StockTransptOrdScheduleLine
;

Learn More