P_INFORECORDMANAGESOSDRAFT

CDS View

P_INFORECORDMANAGESOSDRAFT is a CDS View in S/4HANA. It contains 50 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_InfoRecordManageSOSAll view union_all CONSUMPTION

Fields (50)

KeyField CDS FieldsUsed in Views
AvailableFromDate AvailableFromDate 1
AvailableToDate AvailableToDate 1
BaseUnit BaseUnit 1
bpumn bpumn 1
bpumz bpumz 1
Creator DraftCreator 1
CreatorName DraftCreatorName 1
Currency Currency 1
DraftChangeDate DraftChangeDate 1
DraftCreationDate DraftCreationDate 1
ebeln ebeln 1
ebelp ebelp 1
Entitystate Entitystate 1
GeneralDataDeleted GeneralDataDeleted 1
IncotermsClassification IncotermsClassification 1
IncotermsTransferLocation IncotermsTransferLocation 1
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased 1
isMarkedForDeletion isMarkedForDeletion 1
IsRelevantForAutomSrcg IsRelevantForAutomSrcg 1
Material Material 1
MaterialGroup MaterialGroup 1
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
MaterialPriceUnitQty MaterialPriceUnitQty 1
MaximumOrderQuantity MaximumOrderQuantity 1
MinimumPurchaseOrderQuantity MinimumPurchaseOrderQuantity 1
NetPriceAmount NetPriceAmount 1
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 1
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 1
OrderUnit OrderUnit 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
Plant Plant 1
PriceValidityEndDate PriceValidityEndDate 1
PriorSupplier PriorSupplier 1
PurchaseOrderPriceUnit PurchaseOrderPriceUnit 1
PurchasingGroup PurchasingGroup 1
PurchasingInfoRecord PurchasingInfoRecord 1
PurchasingInfoRecordCategory PurchasingInfoRecordCategory 1
PurchasingInfoRecordDesc PurchasingInfoRecordDesc 1
PurchasingOrganization PurchasingOrganization 1
relif relif 1
SalesPerson SalesPerson 1
StandardPurchaseOrderQuantity StandardPurchaseOrderQuantity 1
Supplier Supplier 1
SupplierMaterialGroup SupplierMaterialGroup 1
SupplierMaterialNumber SupplierMaterialNumber 1
SupplierPhoneNumber SupplierPhoneNumber 1
TaxCode TaxCode 1
uebtk uebtk 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 1
vabme vabme 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_INFORECORDMANAGESOSDRAFT (
    AVAILABLEFROMDATE,
    AVAILABLETODATE,
    BASEUNIT,
    BPUMN,
    BPUMZ,
    CREATOR,
    CREATORNAME,
    CURRENCY,
    DRAFTCHANGEDATE,
    DRAFTCREATIONDATE,
    EBELN,
    EBELP,
    ENTITYSTATE,
    GENERALDATADELETED,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INVOICEISGOODSRECEIPTBASED,
    ISMARKEDFORDELETION,
    ISRELEVANTFORAUTOMSRCG,
    MATERIAL,
    MATERIALGROUP,
    MATERIALPLANNEDDELIVERYDURN,
    MATERIALPRICEUNITQTY,
    MAXIMUMORDERQUANTITY,
    MINIMUMPURCHASEORDERQUANTITY,
    NETPRICEAMOUNT,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERUNIT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PLANT,
    PRICEVALIDITYENDDATE,
    PRIORSUPPLIER,
    PURCHASEORDERPRICEUNIT,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDCATEGORY,
    PURCHASINGINFORECORDDESC,
    PURCHASINGORGANIZATION,
    RELIF,
    SALESPERSON,
    STANDARDPURCHASEORDERQUANTITY,
    SUPPLIER,
    SUPPLIERMATERIALGROUP,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERPHONENUMBER,
    TAXCODE,
    UEBTK,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    VABME
);