CA

29 Fields

CA is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY ManufacturingExecutionDocument ManufacturingExecutionDocument 1
KEY MfgProcgExecAction MfgProcgExecAction 1
AlternativeItemGroup AlternativeItemGroup 1
AssembledBatch AssembledBatch 1
AssembledMfrSerialNumber AssembledMfrSerialNumber 1
AssembledSerialNumber AssembledSerialNumber 1
AssembledShopFloorItem AssembledShopFloorItem 1
BusinessProcessConfirmedQty BusinessProcessConfirmedQty 1
CompDisassemblyPermanence CompDisassemblyPermanence 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
EventDateTime EventDateTime 1
InventoryUsabilityCode InventoryUsabilityCode 1
MaterialComponent MaterialComponent 1
MaterialComponentHasReltdComp MaterialComponentHasReltdComp 1
MaterialComponentName MaterialComponentName 1
MfgExecHistMsgVarblField1 MfgExecHistMsgVarblField1 1
MfgExecHistMsgVarblField2 MfgExecHistMsgVarblField2 1
MfgExecHistMsgVarblField3 MfgExecHistMsgVarblField3 1
OpActyNtwkElement OpActyNtwkElement 1
OpActyNtwkInstance OpActyNtwkInstance 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
ProductionUnit ProductionUnit 1
ReferenceDesignatorValue ReferenceDesignatorValue 1
ShopFloorExecutionUser ShopFloorExecutionUser 1
ShopFloorItem ShopFloorItem 1
StorageLocation StorageLocation 1
SystemMessageNumber SystemMessageNumber 1
vktyp vktyp 8

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 CA (
    MANUFACTURINGEXECUTIONDOCUMENT,
    MFGPROCGEXECACTION,
    ALTERNATIVEITEMGROUP,
    ASSEMBLEDBATCH,
    ASSEMBLEDMFRSERIALNUMBER,
    ASSEMBLEDSERIALNUMBER,
    ASSEMBLEDSHOPFLOORITEM,
    BUSINESSPROCESSCONFIRMEDQTY,
    COMPDISASSEMBLYPERMANENCE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EVENTDATETIME,
    INVENTORYUSABILITYCODE,
    MATERIALCOMPONENT,
    MATERIALCOMPONENTHASRELTDCOMP,
    MATERIALCOMPONENTNAME,
    MFGEXECHISTMSGVARBLFIELD1,
    MFGEXECHISTMSGVARBLFIELD2,
    MFGEXECHISTMSGVARBLFIELD3,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    OPERATIONACTIVITYSFIGROUP,
    PRODUCTIONUNIT,
    REFERENCEDESIGNATORVALUE,
    SHOPFLOOREXECUTIONUSER,
    SHOPFLOORITEM,
    STORAGELOCATION,
    SYSTEMMESSAGENUMBER,
    VKTYP,
    PRIMARY KEY (MANUFACTURINGEXECUTIONDOCUMENT, MFGPROCGEXECACTION)
);

Learn More