_CYCLE

_CYCLE is an SAP database table in S/4HANA. It contains 43 fields.

Fields (43)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 3
KEY AllocationCycleVersionValue AllocationCycleVersionValue 3
AllocActualPlanVariantText AllocActualPlanVariantText 1
AllocationActualPlanVariant AllocationActualPlanVariant 13
AllocationContextTypeText AllocationContextTypeText 1
AllocationCycleEndDate AllocationCycleEndDate,ValidityEndDate 6
AllocationCycleName AllocationCycleName 8
AllocationCycleStartDate AllocationCycleStartDate 1
AllocationCycleTagVersionValue AllocationCycleTagVersionValue 1
AllocationLastExecutedByUser AllocationLastExecutedByUser 4
AllocationLastExecutedDate AllocationLastExecutedDate 4
AllocationPostingType AllocationPostingType 16
AllocationPostingTypeText AllocationPostingTypeText 2
AllocationStatus AllocationStatus 1
AllocationType AllocationType 1
AllocCycFldMappingVersionValue AllocCycFldMappingVersionValue 2
AllocCycleElementVersionValue AllocCycleElementVersionValue 1
AllocCycleKeyFieldVersionValue AllocCycleKeyFieldVersionValue 1
AllocCycleSegmentVersionValue AllocCycleSegmentVersionValue 1
AllocCycleTemplateVersionValue AllocCycleTemplateVersionValue 1
AllocCycleTextVersionValue AllocCycleTextVersionValue 1
AllocSegmentNoteVersionValue AllocSegmentNoteVersionValue 1
CompanyCode CompanyCode 5
CompanyCodeName CompanyCodeName 1
ControllingArea ControllingArea 2
CreationDateTime CreationDateTime 1
cycleDesc cycleSelectionDescr 2
CycleIsAttributedLineItmEnbld CycleIsAttributedLineItmEnbld 1
LanguageCode LanguageCode 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 4
Ledger Ledger 9
MfgBuyOffInitiator MfgBuyOffInitiator 1
OpActyNtwkElement OpActyNtwkElement 2
OpActyNtwkElementElement OpActyNtwkElementElement 2
OpActyNtwkElementElmntVersCntr OpActyNtwkElementElmntVersCntr 2
OpActyNtwkInstance OpActyNtwkInstance 2
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 1
OpActySFIGroupName OpActySFIGroupName 1
OperationActivityNetwork OperationActivityNetwork 1
OperationActivitySFIGroup OperationActivitySFIGroup 1
ShopFloorItem ShopFloorItem 2
TopDwnDistrTmplName TopDwnDistrTmplName 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 _CYCLE (
    ALLOCATIONCYCLE,
    ALLOCATIONCYCLEVERSIONVALUE,
    ALLOCACTUALPLANVARIANTTEXT,
    ALLOCATIONACTUALPLANVARIANT,
    ALLOCATIONCONTEXTTYPETEXT,
    ALLOCATIONCYCLEENDDATE,
    ALLOCATIONCYCLENAME,
    ALLOCATIONCYCLESTARTDATE,
    ALLOCATIONCYCLETAGVERSIONVALUE,
    ALLOCATIONLASTEXECUTEDBYUSER,
    ALLOCATIONLASTEXECUTEDDATE,
    ALLOCATIONPOSTINGTYPE,
    ALLOCATIONPOSTINGTYPETEXT,
    ALLOCATIONSTATUS,
    ALLOCATIONTYPE,
    ALLOCCYCFLDMAPPINGVERSIONVALUE,
    ALLOCCYCLEELEMENTVERSIONVALUE,
    ALLOCCYCLEKEYFIELDVERSIONVALUE,
    ALLOCCYCLESEGMENTVERSIONVALUE,
    ALLOCCYCLETEMPLATEVERSIONVALUE,
    ALLOCCYCLETEXTVERSIONVALUE,
    ALLOCSEGMENTNOTEVERSIONVALUE,
    COMPANYCODE,
    COMPANYCODENAME,
    CONTROLLINGAREA,
    CREATIONDATETIME,
    CYCLEDESC,
    CYCLEISATTRIBUTEDLINEITMENBLD,
    LANGUAGECODE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LEDGER,
    MFGBUYOFFINITIATOR,
    OPACTYNTWKELEMENT,
    OPACTYNTWKELEMENTELEMENT,
    OPACTYNTWKELEMENTELMNTVERSCNTR,
    OPACTYNTWKINSTANCE,
    OPACTYNTWKVERSIONCOUNTER,
    OPACTYSFIGROUPNAME,
    OPERATIONACTIVITYNETWORK,
    OPERATIONACTIVITYSFIGROUP,
    SHOPFLOORITEM,
    TOPDWNDISTRTMPLNAME,
    PRIMARY KEY (ALLOCATIONCYCLE, ALLOCATIONCYCLEVERSIONVALUE)
);