P_ABOPFieldCatalog__Text
P_ABOPFieldCatalog__Text is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_ABOP_DOCUMENT) and exposes 53 fields with key fields ATPRelevantDocumentCategory, ATPRelevantDocument, ATPRelevantDocumentItem, ATPRelevantDocScheduleLine.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_ABOP_DOCUMENT | P_ABOP_DOCUMENT | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_language | sylangu |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PABOPFC__TEXT | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view |
Fields (53)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ATPRelevantDocumentCategory | ATPRelevantDocumentCategory | ATP: Category of Stock / Receipts / Issues | |
| KEY | ATPRelevantDocument | ATPRelevantDocument | MRP element number | |
| KEY | ATPRelevantDocumentItem | ATPRelevantDocumentItem | MRP elemnt item | |
| KEY | ATPRelevantDocScheduleLine | ATPRelevantDocScheduleLine | Scheduling | |
| ATPRelevantDocumentCategoryTex | ||||
| Material | Material | Vehicle Model | ||
| MaterialText | ||||
| SupplyingPlant | SupplyingPlant | Supplying Plant | ||
| SupplyingPlantText | _Plant | PlantName | Plant Name | |
| StorageLocation | StorageLocation | StorageLocation | ||
| StorageLocationText | _StorageLocation | StorageLocationName | Storage Loc. Name | |
| Batch | Batch | Lot No. | ||
| DeliveryGroup | DeliveryGroup | Delivery Group | ||
| ProductAvailabilityDate | ProductAvailabilityDate | Mat.Avail.Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| CreatedByUser | CreatedByUser | User Name | ||
| CreatedByUserText | _CreatedByUser | UserDescription | Full Name | |
| OrderCreationDate | OrderCreationDate | |||
| SoldToParty | SoldToParty | Sold-to Party | ||
| SoldToPartyText | _SoldToParty | CustomerName | Name of Customer | |
| ShippingPoint | ShippingPoint | Shipping Point | ||
| ShippingPointText | ||||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| SalesOrganizationText | ||||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| DistributionChannelText | ||||
| OrganizationDivision | OrganizationDivision | Org. Division | ||
| OrganizationDivisionText | ||||
| MaterialGroup | MaterialGroup | Product Group | ||
| MaterialGroupText | ||||
| SDDocumentCategory | SalesData | SDDocumentCategory | Document Cat. | |
| SDDocumentCategoryText | ||||
| SalesGroup | SalesData | SalesGroup | Sales Group | |
| SalesGroupText | ||||
| SalesOffice | SalesData | SalesOffice | Sales Office | |
| SalesOfficeText | ||||
| SalesDocumentType | SalesData | SalesDocumentType | Sales Doc. Type | |
| SalesDocumentTypeText | ||||
| SalesDocumentItemCategory | SalesData | SalesDocumentItemCategory | Item Category | |
| SalesDocumentItemCategoryText | ||||
| CustomerGroup | SalesData | CustomerGroup | Customer Group | |
| CustomerGroupText | ||||
| DeliveryPriority | SalesData | DeliveryPriority | Delivery Prior. | |
| DeliveryPriorityText | ||||
| PurchasingOrganization | StockTranspData | PurchasingOrganization | Purchasing Organization | |
| PurchasingOrganizationText | ||||
| PurchasingGroup | StockTranspData | PurchasingGroup | Purchasing Group | |
| PurchasingGroupText | ||||
| PurchaseOrderType | StockTranspData | PurchaseOrderType | PO Type | |
| PurchaseOrderTypeText | ||||
| PurchaseOrderItemCategory | StockTranspData | PurchaseOrderItemCategory | Item Category | |
| PurchaseOrderItemCategoryText | ||||
| _SoldToParty | _SoldToParty |
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_ABOPFieldCatalog__Text.
-- 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.
-- SQL view name: PABOPFC__TEXT
-- Parameters: P_language : sylangu
CREATE VIEW P_ABOPFieldCatalog__Text AS
SELECT
ATPRelevantDocumentCategory,
ATPRelevantDocument,
ATPRelevantDocumentItem,
ATPRelevantDocScheduleLine,
_ATPRlvtDocumentCategory._Text[Language=$parameters.P_language].ATPRlvtDocumentCategoryText AS ATPRelevantDocumentCategoryTex,
Material,
_Material._Text[Language=$parameters.P_language].MaterialName AS MaterialText,
SupplyingPlant,
_Plant.PlantName AS SupplyingPlantText,
StorageLocation,
_StorageLocation.StorageLocationName AS StorageLocationText,
Batch,
DeliveryGroup,
ProductAvailabilityDate,
RequestedDeliveryDate,
CreatedByUser,
_CreatedByUser.UserDescription AS CreatedByUserText,
OrderCreationDate,
SoldToParty,
_SoldToParty.CustomerName AS SoldToPartyText,
ShippingPoint,
_ShippingPoint._Text[Language=$parameters.P_language].ShippingPointName AS ShippingPointText,
SalesOrganization,
_SalesOrganization._Text[Language=$parameters.P_language].SalesOrganizationName AS SalesOrganizationText,
DistributionChannel,
_DistributionChannel._Text[Language=$parameters.P_language].DistributionChannelName AS DistributionChannelText,
OrganizationDivision,
_Division._Text[Language=$parameters.P_language].DivisionName AS OrganizationDivisionText,
MaterialGroup,
_MaterialGroup._Text[Language=$parameters.P_language].MaterialGroupName AS MaterialGroupText,
SalesData.SDDocumentCategory AS SDDocumentCategory,
SalesData._SDDocumentCategory._Text[Language=$parameters.P_language].SDDocumentCategoryName AS SDDocumentCategoryText,
SalesData.SalesGroup AS SalesGroup,
SalesData._SalesGroup._Text[Language=$parameters.P_language].SalesGroupName AS SalesGroupText,
SalesData.SalesOffice AS SalesOffice,
SalesData._SalesOffice._Text[Language=$parameters.P_language].SalesOfficeName AS SalesOfficeText,
SalesData.SalesDocumentType AS SalesDocumentType,
SalesData._SalesDocumentType._Text[Language=$parameters.P_language].SalesDocumentTypeName AS SalesDocumentTypeText,
SalesData.SalesDocumentItemCategory AS SalesDocumentItemCategory,
SalesData._ItemCategory._Text[Language=$parameters.P_language].SalesDocumentItemCategoryName AS SalesDocumentItemCategoryText,
SalesData.CustomerGroup AS CustomerGroup,
SalesData._CustomerGroup._Text[Language=$parameters.P_language].CustomerGroupName AS CustomerGroupText,
SalesData.DeliveryPriority AS DeliveryPriority,
SalesData._DeliveryPriority._Text[Language=$parameters.P_language].DeliveryPriorityDesc AS DeliveryPriorityText,
StockTranspData.PurchasingOrganization AS PurchasingOrganization,
StockTranspData._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationText,
StockTranspData.PurchasingGroup AS PurchasingGroup,
StockTranspData._PurchasingGroup.PurchasingGroupName AS PurchasingGroupText,
StockTranspData.PurchaseOrderType AS PurchaseOrderType,
StockTranspData._PurchaseOrderType._Text[Language=$parameters.P_language].PurchasingDocumentTypeName AS PurchaseOrderTypeText,
StockTranspData.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
StockTranspData._PurgDocumentItemCategory._Text[Language=$parameters.P_language].PurgDocItemCategoryName AS PurchaseOrderItemCategoryText
FROM P_ABOP_DOCUMENT
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA