Atpc_Cds_Stock_M

DDL: ATPC_CDS_STOCK_M SQL: ATPC_STOCK_M Type: view
15 Fields 1 Data Sources

CDS View for Mapping Stock Table for ATp

Atpc_Cds_Stock_M is a CDS View that provides data about "CDS View for Mapping Stock Table for ATp" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 15 fields.

Data Sources (1)

SourceAliasJoin Type
matdoc_extract matdoc_extract from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_STOCK_M view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label CDS View for Mapping Stock Table for ATp view

Fields (15)

KeyFieldSource TableSource FieldDescription
mandt mandt Editing Client
key1 key1 INT4
key2 key2 Character Field of Length 12
matbf matbf Stock Mat.
werks werks Receiving Plant
lgort_sid lgort_sid Stor. Location SID
charg_sid charg_sid Batch SID
sobkz sobkz Special Stock
mat_kdauf mat_kdauf SD Doc of Inv.
mat_kdpos mat_kdpos SD Item of Inv.
mat_pspnr mat_pspnr WBSElem of Inv.
lifnr_sid lifnr_sid Supplier SID
kunnr_sid kunnr_sid Customer SID
stock_qty stock_qty_l1 Stock Qty CDS on BL
lbbsa_sid lbbsa_sid Stock Type

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 Atpc_Cds_Stock_M.
-- 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: ATPC_STOCK_M

CREATE VIEW Atpc_Cds_Stock_M AS
SELECT
  mandt,
  key1,
  key2,
  matbf,
  werks,
  lgort_sid,
  charg_sid,
  sobkz,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  lifnr_sid,
  kunnr_sid,
  stock_qty_l1 AS stock_qty,
  lbbsa_sid
FROM matdoc_extract
;

Learn More