I_GrantorApplication

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_GrantorApplication.
-- 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 I_GrantorApplication AS
SELECT
  objtype_h AS BusinessObjectType,
  cast(object_id as crms4_grm_application preserving type ) AS GrantorApplication,
  header_guid AS GrantorApplicationUUID,
  cast(header_guid_char as crmt_object_charguid32 preserving type ) AS GrantorApplicationCharUUID,
  process_type AS GrantorApplicationType,
  description_h AS DocumentDescription,
  descr_language AS Language,
  posting_date AS PostingDate,
  created_at_h AS CreationDateTime,
  created_by_h AS CreatedByUser,
  changed_at_h AS LastChangeDateTime,
  changed_by_h AS LastChangedByUser,
  pricing_document AS PricingDocument,
  pricing_procedure AS PricingProcedure,
  cast(grantee as crms4_grm_grantee preserving type ) AS GrantorDocumentGrantee,
  grantee_address_number AS GrntoDocGranteeAddressNumber,
  employee_resp AS GrntoDocResponsibleEmployee,
  grantee_contact AS GrantorDocumentContactPerson,
  bill_to_party AS GrantorDocumentBillToParty,
  payer AS GrantorDocumentPayer,
  payment_recipient AS GrntoDocumentPaymentRecipient,
  cast( valid_from as crms4_valid_from preserving type ) AS DocumentStartDateTime,
  valid_from_date AS DocumentStartDate,
  cast( valid_to as crms4_valid_to preserving type ) AS DocumentEndDateTime,
  valid_to_date AS DocumentEndDate,
  stat_lifecycle AS GrantorApplicationStatus,
  stat_released AS IsReleased,
  stat_open AS IsOpen,
  stat_error AS HasError,
  cast( stat_cancelled as vdm_document_is_rejected preserving type ) AS IsRejected,
  stat_transfer_ok AS GrantorDocIsSuccessfullyTrnsfd,
  stat_transfer_failed AS GrantorDocHasTransferError,
  stat_grm_cancelled AS GrantorDocumentIsCancelled,
  sales_org AS SalesOrganizationOrgUnitID,
  sales_office AS SalesOfficeOrgUnitID,
  sales_group AS SalesGroupOrgUnitID,
  dis_channel AS DistributionChannel,
  Division,
  service_org AS ServiceOrganization,
  service_org_resp AS ResponsibleServiceOrganization,
  sales_org_resp AS ResponsibleSalesOrganization,
  sales_org_sd AS SalesOrganization,
  sales_office_sd AS SalesOffice,
  sales_group_sd AS SalesGroup,
  cast(grantor_program_id as crmt_gpm_extid preserving type ) AS GrantorProgram,
  cast(grantor_agreement_id as crms4_grm_agreement preserving type ) AS GrantorAgreement,
  currency AS TransactionCurrency,
  contract_account AS ContractAccount
FROM crms4d_grap_h
;