I_GdsMvtGnrtdCustCsgnmtReg

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 I_GdsMvtGnrtdCustCsgnmtReg.
-- 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: IGMCSGNMTREG

CREATE VIEW I_GdsMvtGnrtdCustCsgnmtReg AS
SELECT
  cast( ptxpiuuid as custcsgnmtreguuid preserving type ) AS CustomerConsignmentRegUUID,
  cast ( _ptxph.ptxsubtype as proc_type ) AS CustomerConsignmentProcessType,
  _ptxph.bukrs AS CompanyCode,
  _ptxph.vkorg AS SalesOrganization,
  _ptxph.vbeln AS DeliveryDocument,
  posnr AS DeliveryDocumentItem,
  _ptxph.otaxcnty AS TaxDepartureCountry,
  _ptxph.itaxcnty AS TaxDestinationCountry,
  nsdm_kunnr AS SpecialStockIdfgCustomer,
  _ptxph.stceg AS CustomerVATRegistration,
  kunag AS SoldToParty,
  kunag_adr AS SoldToPartyAddressID,
  kunwe AS ShipToParty,
  kunwe_adr AS ShipToPartyAddressID,
  _ptxph.budat AS GoodsMovementDate,
  matnr AS Product,
  meins AS BaseUnit,
  cast( netwr as fwbas_bses_cs ) AS TaxBaseAmount,
  _ptxph.waerk AS SDTransactionCurrency,
  werks AS DeliveringPlant,
  _ptxph.mblnr AS MaterialDocument,
  zeile AS MaterialDocumentItem,
  _ptxph.mjahr AS MaterialDocumentYear,
  _ptxph.smbln AS ReversedMaterialDocument,
  smblp AS ReversedMaterialDocumentItem,
  _ptxph.sjahr AS ReversedMaterialDocumentYear,
  cast ( '' as vbeln_vf ) AS BillingDocument,
  cast ( '' as posnr_vf ) AS BillingDocumentItem,
  cast ( '' as sfakn ) AS CancelledBillingDocument,
  _ptxph.belnr AS AccountingDocument,
  cast(_ptxph.gjahr as fis_gjahr_no_conv preserving type) AS FiscalYear,
  cast( _ptxpi.aubel as vbeln_va ) AS SalesOrder,
  cast( _ptxpi.aupos as posnr_va ) AS SalesOrderItem,
  charg AS Batch,
  cast ( '' as registerupldremark ) AS CsgnmtRegUpldEntryRemarkTxt
FROM P_PTXPI AS _ptxpi
INNER JOIN ptxph AS _ptxph ON /* join condition not captured in parsed metadata */
;