P_PurOrdMaintainHeaderDraft

// =========================================================================

//   PO Maintenance:Purchase Order Header Draft

// =========================================================================


@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.sqlViewName: 'PPOMAINTHDRDRAFT'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

define view P_PurOrdMaintainHeaderDraft

  as select from ekko_po_d as ekkod
  association [0..1] to P_PurOrdMaintDraftAdminData as _DraftAdministrativeData on
                                   ekkod.db_key = _DraftAdministrativeData.DraftID  and  _DraftAdministrativeData.EntityName = 'MM_PO_DRAFT'         
{
    key guid                                         as PurchaseOrderHeaderDraftUUID,
        ekkod.ebeln                                  as PurchaseOrder,
        cast('F' as abap.char(1))                    as PurchasingDocumentCategory,
        ekkod.bsart                                  as PurchasingDocumentType,
        ekkod.bukrs                                  as CompanyCode,
        ekkod.ekorg                                  as PurchasingOrganization,
        ekkod.ekgrp                                  as PurchasingGroup,
        ekkod.lifnr                                  as Supplier,
        ekkod.waers                                  as Currency,
        ekkod.zterm                                  as PaymentTerms,
        ekkod.zbd1t                                  as CashDiscount1Days,
        ekkod.zbd2t                                  as CashDiscount2Days,
        ekkod.zbd3t                                  as NetPaymentDays,
        ekkod.zbd1p                                  as CashDiscount1Percent,
        ekkod.zbd2p                                  as CashDiscount2Percent,    
        cast(ekkod.wkurs as abap.dec(19,5))          as ExchangeRate,
        ekkod.inco1                                  as IncotermsClassification,
        ekkod.inco2                                  as IncotermsTransferLocation,
        ekkod.incov                                  as IncotermsVersion,
        ekkod.inco2_l                                as IncotermsLocation1,
        ekkod.inco3_l                                as IncotermsLocation2,
        ekkod.crea_uname                             as CreatedByUser,
        ekkod.bedat                                  as PurchaseOrderDate,
        ekkod.lchg_date_time                         as LastChangeDateTime,
        ekkod.lchg_uname                             as LastChangeUser,
        ekkod.lifre                                  as InvoicingParty,
        cast('' as abap.char(1))                     as ReleaseIsNotCompleted,
        ekkod.memory                                 as IsHeld,
        ekkod.knumv                                  as PurchasingDocumentCondition,
        ekkod.kalsm                                  as PricingProcedure,
        ekkod.adrnr                                  as AddressID,
        ekkod.ad_name1                               as AddressName,    
        ekkod.ad_street                              as AddressStreetName,
        ekkod.ad_hsnm1                               as AddressHouseNumber,
        ekkod.ad_pstcd1                              as AddressPostalCode,
        ekkod.ad_city1                               as AddressCityName,
        ekkod.ad_tlnmbr1                             as AddressPhoneNumber,
        ekkod.ad_fxnmbr1                             as AddressFaxNumber,    
        ekkod.regio                                  as AddressRegion,    
        ekkod.land1                                  as AddressCountry,
        ekkod.langu                                  as AddressCorrespondenceLanguage
}