C_GrantorAgreementItemDEX

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 C_GrantorAgreementItemDEX.
-- 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 C_GrantorAgreementItemDEX AS
SELECT
  Item.BusinessObjectType AS BusinessObjectType,
  Item.GrantorAgreement AS GrantorAgreement,
  Item.GrantorAgreementItem AS GrantorAgreementItem,
  Header.GrantorAgreementUUID AS GrantorAgreementUUID,
  Header.GrantorAgreementType AS GrantorAgreementType,
  Header.PostingDate AS DocumentPostingDate,
  Header.DocumentDescription AS DocumentDescription,
  Header.Language AS GrantorDocumentLanguage,
  Header.CreationDateTime AS DocumentCreationDateTime,
  Header.CreatedByUser AS DocumentCreatedByUser,
  Header.LastChangeDateTime AS DocumentLastChangeDateTime,
  Header.LastChangedByUser AS DocumentLastChangedByUser,
  Header.ContractAccount AS GrantorDocumentContractAccount,
  Item.ItemBusinessObjectType AS ItemBusinessObjectType,
  Item.GrantorAgreementItemUUID AS GrantorAgreementItemUUID,
  Item.CreationDateTime AS CreationDateTime,
  Item.CreatedByUser AS CreatedByUser,
  Item.LastChangeDateTime AS LastChangeDateTime,
  Item.LastChangedByUser AS LastChangedByUser,
  Item.PostingDateTime AS PostingDateTime,
  Item.DocumentItemDescription AS DocumentItemDescription,
  Item.Language AS Language,
  Item.GrantorAgreementItemCategory AS GrantorAgreementItemCategory,
  Item.GrantorPaymentType AS GrantorPaymentType,
  Header.DocumentStartDateTime AS DocumentStartDateTime,
  Header.DocumentStartDate AS DocumentStartDate,
  Header.DocumentEndDateTime AS DocumentEndDateTime,
  Header.DocumentEndDate AS DocumentEndDate,
  Item.DocumentItemStartDateTime AS DocumentItemStartDateTime,
  Item.DocumentItemStartDate AS DocumentItemStartDate,
  Item.DocumentItemEndDateTime AS DocumentItemEndDateTime,
  Item.DocumentItemEndDate AS DocumentItemEndDate,
  Item.DocumentItemDueDateTime AS DocumentItemDueDateTime,
  Item.DocumentItemDueDate AS DocumentItemDueDate,
  Header.GrantorAgreementStatus AS GrantorAgreementStatus,
  Header.IsReleased AS DocumentIsReleased,
  Header.IsOpen AS DocumentIsOpen,
  Header.IsRejected AS DocumentIsRejected,
  Header.HasError AS DocumentHasError,
  Header.GrantorDocumentIsCancelled AS GrantorDocumentIsCancelled,
  Item.GrantorAgreementItemStatus AS GrantorAgreementItemStatus,
  Item.IsReleased AS IsReleased,
  Item.IsOpen AS IsOpen,
  Item.IsRejected AS IsRejected,
  Item.HasError AS HasError,
  Item.GrantorDocumentItemIsCancelled AS GrantorDocumentItemIsCancelled,
  Item.GrantorDocumentGrantee AS GrantorDocumentGrantee,
  Item.GrntoDocGranteeAddressNumber AS GrntoDocGranteeAddressNumber,
  Item.GrantorDocumentBillToParty AS GrantorDocumentBillToParty,
  Item.GrntoDocResponsibleEmployee AS GrntoDocResponsibleEmployee,
  Item.GrantorDocumentContactPerson AS GrantorDocumentContactPerson,
  Item.GrantorDocumentPayer AS GrantorDocumentPayer,
  Item.GrntoDocumentPaymentRecipient AS GrntoDocumentPaymentRecipient,
  Item.GrantorDocumentItemGrantee AS GrantorDocumentItemGrantee,
  Item.GrntoDocItemGranteeAddressNmbr AS GrntoDocItemGranteeAddressNmbr,
  Item.GrantorDocumentItemBillToParty AS GrantorDocumentItemBillToParty,
  Item.GrntoDocItmResponsibleEmployee AS GrntoDocItmResponsibleEmployee,
  Item.GrntoDocumentItemContactPerson AS GrntoDocumentItemContactPerson,
  Item.GrantorDocumentItemPayer AS GrantorDocumentItemPayer,
  Item.GrntoDocItemPaymentRecipient AS GrntoDocItemPaymentRecipient,
  Item.GrantorDocItemGranteeExtRef AS GrantorDocItemGranteeExtRef,
  Item.GrantorDocItemRejectionReason AS GrantorDocItemRejectionReason,
  Item.ResponsibleSalesOrganization AS ResponsibleSalesOrganization,
  Item.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  Item.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  Item.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  Item.SalesOrganization AS SalesOrganization,
  Item.SalesOffice AS SalesOffice,
  Item.SalesGroup AS SalesGroup,
  Item.DistributionChannel AS DistributionChannel,
  Item.Division AS Division,
  Item.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
  Item.ServiceOrganization AS ServiceOrganization,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.StatisticsCurrency AS StatisticsCurrency,
  Item.PaymentTerms AS PaymentTerms,
  Item.CustomerGroup AS CustomerGroup,
  Item.NetAmount AS NetAmount,
  Item.GrantorDocumentItemIsCredit AS GrantorDocumentItemIsCredit,
  Item.ContractAccount AS ContractAccount,
  cast( tstmp_to_dats( Item.BillingDateTime, Item.BillingTimeZone, $session.client, 'NULL' ) as vdm_billing_date preserving type ) AS BillingDate,
  Item.BillingBlockReason AS BillingBlockReason,
  cast( tstmp_to_dats( Item.BillingPlanStartDateTime, Item.BillingPlanTimeZone, $session.client, 'NULL' ) as vdm_billingplan_start_date preserving type ) AS BillingPlanStartDate,
  cast( tstmp_to_dats( Item.BillingPlanEndDateTime, Item.BillingPlanTimeZone, $session.client, 'NULL' ) as vdm_billingplan_end_date preserving type ) AS BillingPlanEndDate,
  Item.BillingPlanType AS BillingPlanType,
  Item._GrantorProgram.GrantorProgramUUID AS GrantorProgramUUID,
  Item.GrantorProgram AS GrantorProgram,
  Item.GrantorApplication AS GrantorApplication,
  Item.GrantorApplicationItem AS GrantorApplicationItem,
  Item.GrantorAuthorizedAmount AS GrantorAuthorizedAmount,
  Item.GrantorHoldbackAmount AS GrantorHoldbackAmount,
  Item.GrantorClearedAmount AS GrantorClearedAmount,
  Item.GrantorReleasedHoldbackAmount AS GrantorReleasedHoldbackAmount,
  Item.GrntoCumulatedAuthorizedAmount AS GrntoCumulatedAuthorizedAmount,
  Item.GrantorCumulatedClearedAmount AS GrantorCumulatedClearedAmount,
  Item.GrantorCumulatedHoldbackAmount AS GrantorCumulatedHoldbackAmount,
  Item.GrntoCumulatedClmdAuthzdAmount AS GrntoCumulatedClmdAuthzdAmount,
  Item.GrntoCumulatedClmdClrdAmount AS GrntoCumulatedClmdClrdAmount,
  Item.GrntoCumulatedClmdHoldbackAmt AS GrntoCumulatedClmdHoldbackAmt,
  Item.GrantorOpenBalance AS GrantorOpenBalance,
  Item.GrntoOutstandingAdvanceAmount AS GrntoOutstandingAdvanceAmount,
  Item._GrantorAdvanceReferenceItem.GrantorAgreementItemUUID AS GrntoAdvanceReferenceItemUUID,
  Item.GrantorAdvanceReferenceItem AS GrantorAdvanceReferenceItem,
  Item._GrantorHoldbackReferenceItem.GrantorAgreementItemUUID AS GrntoHoldbackReferenceItemUUID,
  Item.GrantorHoldbackReferenceItem AS GrantorHoldbackReferenceItem,
  Item.GrantorExpenseCatalog AS GrantorExpenseCatalog,
  Item.GrantorExpenseGroup AS GrantorExpenseGroup,
  Item.GrantorExpenseType AS GrantorExpenseType,
  Item.GrantorFinancialExecutionType AS GrantorFinancialExecutionType,
  Item._BusinessObjectType AS _BusinessObjectType,
  Item._GrantorAgreement AS _GrantorAgreement
FROM I_GrantorAgreementItemEnhcd AS Item
;