FCOUA_UPLCYCLE_D
Draft table for entity R_UNIVALLOCATIONCYCLEUPLOADTP
FCOUA_UPLCYCLE_D is an SAP database table in S/4HANA. Draft table for entity R_UNIVALLOCATIONCYCLEUPLOADTP. It contains 30 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_UnivAllocCycleUploadDraft | view_entity | from | BASIC | Upload Cycle - Draft |
Fields (30)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | allocationuploadrowuuid | FCO_ROW_GUID | Row GUID | |||
| KEY | uploaduuid | FCO_UPLOAD_GUID | Upload GUID | |||
| allocationcycle | CYCLE | Cycle | ||||
| allocationcyclename | FCO_ALLOC_CYCLE | Allocation Cycle | ||||
| allocationtype | FCO_ALLOCATION_CONTEXT | Allocation Context | ||||
| ledger | FIS_RLDNR | Ledger | ||||
| allocationcyclestartdate | FCO_ALLOC_VALID_FROM | Valid From | ||||
| rowindex | FCO_ROW_INDEX | Row index | ||||
| allocationcycleenddate | FCO_ALLOC_VALID_TO | Valid To | ||||
| allocationcycledescription | FCO_ALLOC_CYCLE_NAME | Cycle Description | ||||
| companycode | FIS_BUKRS | Company Code | ||||
| controllingarea | FIS_KOKRS | Controlling Area | ||||
| allocationpostingtype | FCO_ALLOC_POSTING_TYPE | Allocation Type | ||||
| allocationactualplanvariant | FCO_ALLOC_IPKNZ | Actual / Plan | ||||
| allocationcyclecategory | FCOM_CATEGORY | Plan Category | ||||
| allocationisvariablequantity | FCO_ALLOC_QUANTITES_EXCEL_NOX | Quantities | ||||
| allocationisintransactioncrcy | FCO_TRANS_CURR_EXCEL_NOX | Trans. Currency | ||||
| allocationcycleisiterative | FCO_ALLOC_ITERATIVE_EXCEL_NOX | Iteration | ||||
| cycleisparallelledgerenabled | FCO_ALLO_PAR_LEDGER_EXCEL_NOX | Flex. Ledger | ||||
| allocationiscumulative | FCO_ALLOC_CUMULATIVE_EXCEL_NOX | Cumulative | ||||
| allocationcyclerungroup | ALLOC_CYCLE_RUN_GROUP | Cycle Run Group | ||||
| uploadedbyuser | FCO_ALLOC_CREATED_BY | Created By | ||||
| uploadcreationdatetime | TIMESTAMP | Time Stamp | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Draft Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Draft Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | Admin. UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Draft Changes |
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.
-- Draft table for entity R_UNIVALLOCATIONCYCLEUPLOADTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCOUA_UPLCYCLE_D (
MANDT, -- Client [MANDT]
ALLOCATIONUPLOADROWUUID, -- Row GUID [FCO_ROW_GUID]
UPLOADUUID, -- Upload GUID [FCO_UPLOAD_GUID]
ALLOCATIONCYCLE, -- Cycle [CYCLE]
ALLOCATIONCYCLENAME, -- Allocation Cycle [FCO_ALLOC_CYCLE]
ALLOCATIONTYPE, -- Allocation Context [FCO_ALLOCATION_CONTEXT]
LEDGER, -- Ledger [FIS_RLDNR]
ALLOCATIONCYCLESTARTDATE, -- Valid From [FCO_ALLOC_VALID_FROM]
ROWINDEX, -- Row index [FCO_ROW_INDEX]
ALLOCATIONCYCLEENDDATE, -- Valid To [FCO_ALLOC_VALID_TO]
ALLOCATIONCYCLEDESCRIPTION, -- Cycle Description [FCO_ALLOC_CYCLE_NAME]
COMPANYCODE, -- Company Code [FIS_BUKRS]
CONTROLLINGAREA, -- Controlling Area [FIS_KOKRS]
ALLOCATIONPOSTINGTYPE, -- Allocation Type [FCO_ALLOC_POSTING_TYPE]
ALLOCATIONACTUALPLANVARIANT, -- Actual / Plan [FCO_ALLOC_IPKNZ]
ALLOCATIONCYCLECATEGORY, -- Plan Category [FCOM_CATEGORY]
ALLOCATIONISVARIABLEQUANTITY, -- Quantities [FCO_ALLOC_QUANTITES_EXCEL_NOX]
ALLOCATIONISINTRANSACTIONCRCY, -- Trans. Currency [FCO_TRANS_CURR_EXCEL_NOX]
ALLOCATIONCYCLEISITERATIVE, -- Iteration [FCO_ALLOC_ITERATIVE_EXCEL_NOX]
CYCLEISPARALLELLEDGERENABLED, -- Flex. Ledger [FCO_ALLO_PAR_LEDGER_EXCEL_NOX]
ALLOCATIONISCUMULATIVE, -- Cumulative [FCO_ALLOC_CUMULATIVE_EXCEL_NOX]
ALLOCATIONCYCLERUNGROUP, -- Cycle Run Group [ALLOC_CYCLE_RUN_GROUP]
UPLOADEDBYUSER, -- Created By [FCO_ALLOC_CREATED_BY]
UPLOADCREATIONDATETIME, -- Time Stamp [TIMESTAMP]
DRAFTENTITYCREATIONDATETIME, -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
PRIMARY KEY (MANDT, ALLOCATIONUPLOADROWUUID, UPLOADUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA