P_PURORDMAINTAINHEADERDRAFT
P_PURORDMAINTAINHEADERDRAFT is a CDS View in S/4HANA. It contains 41 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_PurOrdMaintainHeaderAll | view | union_all | CONSUMPTION |
Fields (41)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | 1 |
| KEY | PurchaseOrderHeaderDraftUUID | PurchaseOrderHeaderDraftUUID | 1 |
| AddressCityName | AddressCityName | 1 | |
| AddressCorrespondenceLanguage | AddressCorrespondenceLanguage | 1 | |
| AddressCountry | AddressCountry | 1 | |
| AddressFaxNumber | AddressFaxNumber | 1 | |
| AddressHouseNumber | AddressHouseNumber | 1 | |
| AddressID | AddressID | 1 | |
| AddressName | AddressName | 1 | |
| AddressPhoneNumber | AddressPhoneNumber | 1 | |
| AddressPostalCode | AddressPostalCode | 1 | |
| AddressRegion | AddressRegion | 1 | |
| AddressStreetName | AddressStreetName | 1 | |
| CashDiscount1Days | CashDiscount1Days | 1 | |
| CashDiscount1Percent | CashDiscount1Percent | 1 | |
| CashDiscount2Days | CashDiscount2Days | 1 | |
| CashDiscount2Percent | CashDiscount2Percent | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| Currency | Currency | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| InvoicingParty | InvoicingParty | 1 | |
| IsHeld | IsHeld | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LastChangeUser | LastChangeUser | 1 | |
| NetPaymentDays | NetPaymentDays | 1 | |
| PaymentTerms | PaymentTerms | 1 | |
| PricingProcedure | PricingProcedure | 1 | |
| PurchaseOrderDate | PurchaseOrderDate | 1 | |
| PurchasingDocumentCategory | PurchasingDocumentCategory | 1 | |
| PurchasingDocumentCondition | PurchasingDocumentCondition | 1 | |
| PurchasingDocumentType | PurchasingDocumentType | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| ReleaseIsNotCompleted | ReleaseIsNotCompleted | 1 | |
| Supplier | Supplier | 1 |
// =========================================================================
// 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EKKO_PO_D"
],
"ASSOCIATED":
[
"P_PURORDMAINTDRAFTADMINDATA"
],
"BASE":
[],
"VERSION":0
}
}*/