A_PRACheckInputCDEXHdrExecTP

DDL: A_PRACHECKINPUTCDEXHDREXECTP Type: view_entity CONSUMPTION

Input CDEX Exec Header

A_PRACheckInputCDEXHdrExecTP is a Consumption CDS View that provides data about "Input CDEX Exec Header" in SAP S/4HANA. It reads from 1 data source (R_PRACheckInputCDEXHdrExecTP) and exposes 20 fields with key fields PRACheckInputCDEXCompany, PRACheckInputOwnerNumber, PRACheckInputCDEXCheckNumber. It is exposed through 1 OData service (API_PRACHECKINPUTCDEXEXEC).

Data Sources (1)

SourceAliasJoin Type
R_PRACheckInputCDEXHdrExecTP R_PRACheckInputCDEXHdrExecTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Input CDEX Exec Header view
OData.entityType.name PRACheckInputCDEXHdrExec_Type view
OData.entitySet.name PRACheckInputCDEXHdrExec view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PRAInboundCheckCDEXHdr view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_PRACHECKINPUTCDEXEXEC API_PRACHECKINPUTCDEXEXEC V4 C2 C1

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PRACheckInputCDEXCompany PRACheckInputCDEXCompany
KEY PRACheckInputOwnerNumber PRACheckInputOwnerNumber
KEY PRACheckInputCDEXCheckNumber PRACheckInputCDEXCheckNumber
PRACheckInputRecordValue PRACheckInputRecordValue
PRACheckInputActualCheckAmount PRACheckInputActualCheckAmount
PRAIsCheckInputNetOut PRAIsCheckInputNetOut
PRAIsCheckInputPayment PRAIsCheckInputPayment
PRACheckInputEffectiveDateVal PRACheckInputEffectiveDateVal
PRAChkInptTotLeaseGrossVolVal PRAChkInptTotLeaseGrossVolVal
PRATotLeaseGrossSvrncTaxAmt PRATotLeaseGrossSvrncTaxAmt
PRAChkInptTotalLeaseNetAmount PRAChkInptTotalLeaseNetAmount
TotChrgReimbmtTaxLeaseGrossAmt TotChrgReimbmtTaxLeaseGrossAmt
PRAChkInptTotalOwnerNetAmount PRAChkInptTotalOwnerNetAmount
TotChrgReimbmtTaxOwnerAmount TotChrgReimbmtTaxOwnerAmount
PRAChkInptTransDateValue PRAChkInptTransDateValue
CreatedByUser CreatedByUser User Name
PRACreationDateTime PRACreationDateTime Time Stamp
PRATransmissionCDEXDate PRATransmissionCDEXDate
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PRACashCompanyCode PRACashCompanyCode

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 A_PRACheckInputCDEXHdrExecTP.
-- 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 A_PRACheckInputCDEXHdrExecTP AS
SELECT
  PRACheckInputCDEXCompany,
  PRACheckInputOwnerNumber,
  PRACheckInputCDEXCheckNumber,
  PRACheckInputRecordValue,
  PRACheckInputActualCheckAmount,
  PRAIsCheckInputNetOut,
  PRAIsCheckInputPayment,
  PRACheckInputEffectiveDateVal,
  PRAChkInptTotLeaseGrossVolVal,
  PRATotLeaseGrossSvrncTaxAmt,
  PRAChkInptTotalLeaseNetAmount,
  TotChrgReimbmtTaxLeaseGrossAmt,
  PRAChkInptTotalOwnerNetAmount,
  TotChrgReimbmtTaxOwnerAmount,
  PRAChkInptTransDateValue,
  CreatedByUser,
  PRACreationDateTime,
  PRATransmissionCDEXDate,
  CompanyCodeCurrency,
  PRACashCompanyCode
FROM R_PRACheckInputCDEXHdrExecTP
;