PROJECTMATERIALCOMPONENT

67 Fields

PROJECTMATERIALCOMPONENT is an SAP database table in S/4HANA. It contains 67 fields.

Fields (67)

KeyField CDS FieldsUsed in Views
KEY RecordType RecordType 2
KEY Reservation Reservation 2
KEY ReservationItem ReservationItem 2
KEY Version Version 2
AccountAssignmentCategory AccountAssignmentCategory 2
Assembly Assembly 1
AssemblyName AssemblyName 2
BaseUnit BaseUnit 2
BillOfMaterial BillOfMaterial 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 2
BOMHeaderText BOMHeaderText 2
BOMItemCategory BOMItemCategory 2
BOMItemDescription BOMItemDescription 1
CommittedQuantity CommittedQuantity 2
ConsumptionPosting ConsumptionPosting 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Creditor Creditor 1
Currency Currency 2
DeliveryDurationInDays DeliveryDurationInDays 1
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore 1
FldLogsSupplyProcess FldLogsSupplyProcess 1
FldLogsVersion FldLogsVersion 1
FormulaKey FormulaKey 1
GLAccount GLAccount 1
GoodsMovementIsAllowed GoodsMovementIsAllowed 2
GoodsMovementType GoodsMovementType 1
GoodsRecipientName GoodsRecipientName 2
IsBulkMaterialComponent IsBulkMaterialComponent 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Material Material 1
MaterialCompIsCostRelevant MaterialCompIsCostRelevant 2
MaterialCompIsSpecialStock MaterialCompIsSpecialStock 1
MaterialCompMainAssemblyCat MaterialCompMainAssemblyCat 1
MaterialComponentIsMissing MaterialComponentIsMissing 2
MaterialComponentPrice MaterialComponentPrice 2
MaterialPriceUnitQty MaterialPriceUnitQty 2
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush 1
MatlCompIsMarkedForDeletion MatlCompIsMarkedForDeletion 2
MatlCompRequirementDate MatlCompRequirementDate 2
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit 2
NetworkActivity NetworkActivity 2
OpenQuantity OpenQuantity 2
OperationLeadTimeOffset OperationLeadTimeOffset 1
OperationLeadTimeOffsetUnit OperationLeadTimeOffsetUnit 1
Plant Plant 2
ProcurementType ProcurementType 2
ProductionSeries ProductionSeries 1
ProductTypeCode ProductTypeCode 1
ProjectNetwork ProjectNetwork 2
ProjectObjectChangeNumber ProjectObjectChangeNumber 1
ProjectWithCodingMask Project 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchasingGroup PurchasingGroup 1
ReceivedQuantity ReceivedQuantity 1
RequirementQuantityInBaseUnit RequirementQuantityInBaseUnit 2
ReservationIsFinallyIssued ReservationIsFinallyIssued 2
RqmtDateIsEnteredManually RqmtDateIsEnteredManually 1
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 1
ShortfallQuantity ShortfallQuantity 1
StorageLocation StorageLocation 2
Supplier Supplier 1
UnloadingPointName UnloadingPointName 2
WBSElementInternalID WBSElementInternalID 2
WithdrawnQuantity WithdrawnQuantity 2

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 PROJECTMATERIALCOMPONENT (
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    VERSION,
    ACCOUNTASSIGNMENTCATEGORY,
    ASSEMBLY,
    ASSEMBLYNAME,
    BASEUNIT,
    BILLOFMATERIAL,
    BILLOFMATERIALITEMNUMBER,
    BOMHEADERTEXT,
    BOMITEMCATEGORY,
    BOMITEMDESCRIPTION,
    COMMITTEDQUANTITY,
    CONSUMPTIONPOSTING,
    CREATEDBYUSER,
    CREATIONDATE,
    CREDITOR,
    CURRENCY,
    DELIVERYDURATIONINDAYS,
    FLDLOGSDELIVISHELDONSHORE,
    FLDLOGSSUPPLYPROCESS,
    FLDLOGSVERSION,
    FORMULAKEY,
    GLACCOUNT,
    GOODSMOVEMENTISALLOWED,
    GOODSMOVEMENTTYPE,
    GOODSRECIPIENTNAME,
    ISBULKMATERIALCOMPONENT,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MATERIAL,
    MATERIALCOMPISCOSTRELEVANT,
    MATERIALCOMPISSPECIALSTOCK,
    MATERIALCOMPMAINASSEMBLYCAT,
    MATERIALCOMPONENTISMISSING,
    MATERIALCOMPONENTPRICE,
    MATERIALPRICEUNITQTY,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MATLCOMPISMARKEDFORDELETION,
    MATLCOMPREQUIREMENTDATE,
    MRPREQUIREDQUANTITYINBASEUNIT,
    NETWORKACTIVITY,
    OPENQUANTITY,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONLEADTIMEOFFSETUNIT,
    PLANT,
    PROCUREMENTTYPE,
    PRODUCTIONSERIES,
    PRODUCTTYPECODE,
    PROJECTNETWORK,
    PROJECTOBJECTCHANGENUMBER,
    PROJECTWITHCODINGMASK,
    PURCHASEREQUISITIONITEM,
    PURCHASINGGROUP,
    RECEIVEDQUANTITY,
    REQUIREMENTQUANTITYINBASEUNIT,
    RESERVATIONISFINALLYISSUED,
    RQMTDATEISENTEREDMANUALLY,
    SALESORDER,
    SALESORDERITEM,
    SHORTFALLQUANTITY,
    STORAGELOCATION,
    SUPPLIER,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID,
    WITHDRAWNQUANTITY,
    PRIMARY KEY (RECORDTYPE, RESERVATION, RESERVATIONITEM, VERSION)
);

Learn More