P_PTXPI

DDL: P_PTXPI SQL: PPTXPI Type: view BASIC
38 Fields 1 Data Sources

Primary key switch for PTXPI

P_PTXPI is a Basic CDS View that provides data about "Primary key switch for PTXPI" in SAP S/4HANA. It reads from 1 data source (ptxpi) and exposes 38 fields with key field ptxpiuuid.

Data Sources (1)

SourceAliasJoin Type
ptxpi ptxpi from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPTXPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Primary key switch for PTXPI view
VDM.viewType #BASIC view
VDM.private true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ptxpiuuid ptxpiuuid UUID
ptxnr ptxnr Proposal Tax Posting UUID
ptxit ptxit Proposal Tax Posting Item No.
werks werks Receiving Plant
umwrk umwrk Receiving plant
zeile zeile Mat. Doc.Item
posnr posnr WBS Element
charg charg Chargeable Proc.
uecha uecha HghLevItmBatch
xchar xchar HU assignment
smblp smblp Reversed Doc Item
matnr matnr Vehicle Model
fkimg fkimg Invoiced Qty
vrkme vrkme UoM for SubItm CCD
fklmg fklmg Bill.Qty in SKU
meins meins Valuation Unit
ntgew ntgew Net Weight
gewei gewei Weight Unit
fbuda fbuda Services Rendered Date
kursk kursk Exchange Rate
netwr netwr Value
vgtyp vgtyp Trans. Type
aubel aubel Trigger doc
aupos aupos Item
arktx arktx Short Text
pstyv pstyv Item Category
autyp autyp Order category
brtwr brtwr Gross value
grwrt grwrt Statist. Value
spe_herkl spe_herkl C/R of Origin
spe_herkr spe_herkr Reg. of Origin
itm_comco itm_comco Commodity Code
nsdm_kunnr nsdm_kunnr Customer SID
kunag kunag Sold-to Party
kunag_adr kunag_adr Sold-To Address
kunwe kunwe Ship-to Party
kunwe_adr kunwe_adr Ship-to address
version version XML Vers.

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_PTXPI.
-- 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: PPTXPI

CREATE VIEW P_PTXPI AS
SELECT
  ptxpiuuid,
  ptxnr,
  ptxit,
  werks,
  umwrk,
  zeile,
  posnr,
  charg,
  uecha,
  xchar,
  smblp,
  matnr,
  fkimg,
  vrkme,
  fklmg,
  meins,
  ntgew,
  gewei,
  fbuda,
  kursk,
  netwr,
  vgtyp,
  aubel,
  aupos,
  arktx,
  pstyv,
  autyp,
  brtwr,
  grwrt,
  spe_herkl,
  spe_herkr,
  itm_comco,
  nsdm_kunnr,
  kunag,
  kunag_adr,
  kunwe,
  kunwe_adr,
  version
FROM ptxpi
;

Learn More