WLF_D_FCADOC_D
Draft table for entity R_FRTCOSTALLOCDOCTP
WLF_D_FCADOC_D is an SAP database table in S/4HANA. Draft table for entity R_FRTCOSTALLOCDOCTP. It contains 62 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_FrtCostAllocDocDraft | view_entity | from | EXTENSION | Frt Cost Alloc Doc Drft - Extension |
| R_FrtCostAllocDocDraft | view_entity | from | BASIC | Frt Cost Alloc Doc Drft Query |
Fields (62)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | freightcostallocationdocument | WLF_FCADOC_WBELN | Freight Cost Allocation Document | |||
| KEY | draftuuid | SDRAFT_UUID | Draft Document ID | |||
| settlmtdoctype | WLF_SETTLMT_DOC_TYPE | Settlement Document Type | ||||
| settlmtdoccat | WLF_SETTLMT_DOC_CAT | Settlement Document Category | ||||
| settlmtprocesstype | WLF_SETTLMT_PROCESS_TYPE | Settlement Process Type | ||||
| settlmtprocesscat | WLF_SETTLMT_PROCESS_CAT | Settlement Process Category | ||||
| logisticsdataentrycat | WRTYP | Entry Category | ||||
| settlmtcat | NAFKT | Settl. Category | ||||
| postingdate | WFDAT | Posting Date | ||||
| frtcostallocacctgtransfsts | WFBSK | Posting Status | ||||
| documentdate | WLF_DOCUMENT_DATE | Document Date | ||||
| documentreferenceid | XBLNR1 | Reference | ||||
| assignmentreference | DZUONR | Assignment | ||||
| settlmtapplsts | WSTATE | Appl. Status | ||||
| settlmtapplstsgrp | WSTATG | Status Group | ||||
| pricingprocedure | WLF_KALSM | Pricing Procedure | ||||
| pricingdocument | WLF_KNUMV | Document Condition | ||||
| companycode | FIS_BUKRS | Company Code | ||||
| purchasingorganization | EKORG | Purchasing Org. | ||||
| purchasinggroup | EKGRP | Purch. Group | ||||
| salesorganization | VKORG | Sales Org. | ||||
| distributionchannel | VTWEG | Distr. Channel | ||||
| division | SPART | Division | ||||
| salesoffice | VKBUR | Sales Office | ||||
| salesgroup | VKGRP | Sales Group | ||||
| createdbyuser | WLF_CREATED_BY | Created By | ||||
| creationdate | WLF_CREATED_ON | Created On | ||||
| creationtime | WLF_CREATED_AT | Created At | ||||
| lastchangedate | WLF_CHANGED_ON | Last Changed On | ||||
| frtcostallocdoccurrency | WLF_FCADOC_WAERL | Document Currency | ||||
| exchangerate | WLF_UKURS_CURR_NO_CNEXT | Exchange Rate | ||||
| exchangeratetype | KURST | Exch. Rate Type | ||||
| exchangerateisfixed | WKUFIX | Exch.Rate Fixed | ||||
| exchangeratedate | VDM_V_EXCHANGE_RATE_DATE | Exchange Rate Date | ||||
| frtcostallocdoctotgrossamount | BRTWR_LF | Gross Amount | ||||
| frtcostallocdoctotalnetamount | NETWR_LF | Net Amount | ||||
| frtcostallocdocisreversed | WLF_FCADOC_FKSTO | Document is Reversed | ||||
| rvsdfrtcostallocdoc | LFAKS | Reversed Document | ||||
| frtcostallocdocactivityreason | WLF_WFGRU_HEADER | Header Document Creation Activity Reason | ||||
| paymentreference | FARP_KIDNO | Payment Reference | ||||
| settlmtclassificationcat | WSETTLE_CATEGORY | Classification Cat. | ||||
| fiscalperiod | FINS_FISCALPERIOD | Fiscal Period | ||||
| frtcostallocdocincmpltnsrsn | WLF_INCOMPLETENESS_REASON | Incomplete Rsn | ||||
| incotermsversion | INCOV | Inco. Version | ||||
| incotermsclassification | INCO1 | Incoterms | ||||
| incotermstransferlocation | INCO2 | Incoterms 2 | ||||
| incotermslocation1 | INCO2_L | Inco. Location1 | ||||
| incotermslocation2 | INCO3_L | Inco. Location2 | ||||
| frtcostallocbusproccat | WLF_USE_CASE_TYPE | Use Case Type | ||||
| applelmntbehaviorgrp | WLF_APP_VIS_GRP | Element Behavior Group | ||||
| journalentrycreationdate | WLF_JOURNAL_ENTRY_CRTN_DTE_UTC | Journal Entry Creation Date | ||||
| journalentrycreationtime | WLF_JOURNAL_ENTRY_CRTN_TME_UTC | Journal Entry Creation Time | ||||
| frtcostallocadjmtcat | WLF_SETTLMT_MGMT_ADJMT_CAT | Adjustment Category | ||||
| frtcostallocdocchangestate | WLF_CHANGE_STATE | Change State | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Draft - Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Field Changes | ||||
| dummy_wbrk_incl_eew_ps | WBRK_INCL_EEW | Dummy |
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_FRTCOSTALLOCDOCTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WLF_D_FCADOC_D (
MANDT, -- Client [MANDT]
FREIGHTCOSTALLOCATIONDOCUMENT, -- Freight Cost Allocation Document [WLF_FCADOC_WBELN]
DRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
SETTLMTDOCTYPE, -- Settlement Document Type [WLF_SETTLMT_DOC_TYPE]
SETTLMTDOCCAT, -- Settlement Document Category [WLF_SETTLMT_DOC_CAT]
SETTLMTPROCESSTYPE, -- Settlement Process Type [WLF_SETTLMT_PROCESS_TYPE]
SETTLMTPROCESSCAT, -- Settlement Process Category [WLF_SETTLMT_PROCESS_CAT]
LOGISTICSDATAENTRYCAT, -- Entry Category [WRTYP]
SETTLMTCAT, -- Settl. Category [NAFKT]
POSTINGDATE, -- Posting Date [WFDAT]
FRTCOSTALLOCACCTGTRANSFSTS, -- Posting Status [WFBSK]
DOCUMENTDATE, -- Document Date [WLF_DOCUMENT_DATE]
DOCUMENTREFERENCEID, -- Reference [XBLNR1]
ASSIGNMENTREFERENCE, -- Assignment [DZUONR]
SETTLMTAPPLSTS, -- Appl. Status [WSTATE]
SETTLMTAPPLSTSGRP, -- Status Group [WSTATG]
PRICINGPROCEDURE, -- Pricing Procedure [WLF_KALSM]
PRICINGDOCUMENT, -- Document Condition [WLF_KNUMV]
COMPANYCODE, -- Company Code [FIS_BUKRS]
PURCHASINGORGANIZATION, -- Purchasing Org. [EKORG]
PURCHASINGGROUP, -- Purch. Group [EKGRP]
SALESORGANIZATION, -- Sales Org. [VKORG]
DISTRIBUTIONCHANNEL, -- Distr. Channel [VTWEG]
DIVISION, -- Division [SPART]
SALESOFFICE, -- Sales Office [VKBUR]
SALESGROUP, -- Sales Group [VKGRP]
CREATEDBYUSER, -- Created By [WLF_CREATED_BY]
CREATIONDATE, -- Created On [WLF_CREATED_ON]
CREATIONTIME, -- Created At [WLF_CREATED_AT]
LASTCHANGEDATE, -- Last Changed On [WLF_CHANGED_ON]
FRTCOSTALLOCDOCCURRENCY, -- Document Currency [WLF_FCADOC_WAERL]
EXCHANGERATE, -- Exchange Rate [WLF_UKURS_CURR_NO_CNEXT]
EXCHANGERATETYPE, -- Exch. Rate Type [KURST]
EXCHANGERATEISFIXED, -- Exch.Rate Fixed [WKUFIX]
EXCHANGERATEDATE, -- Exchange Rate Date [VDM_V_EXCHANGE_RATE_DATE]
FRTCOSTALLOCDOCTOTGROSSAMOUNT, -- Gross Amount [BRTWR_LF]
FRTCOSTALLOCDOCTOTALNETAMOUNT, -- Net Amount [NETWR_LF]
FRTCOSTALLOCDOCISREVERSED, -- Document is Reversed [WLF_FCADOC_FKSTO]
RVSDFRTCOSTALLOCDOC, -- Reversed Document [LFAKS]
FRTCOSTALLOCDOCACTIVITYREASON, -- Header Document Creation Activity Reason [WLF_WFGRU_HEADER]
PAYMENTREFERENCE, -- Payment Reference [FARP_KIDNO]
SETTLMTCLASSIFICATIONCAT, -- Classification Cat. [WSETTLE_CATEGORY]
FISCALPERIOD, -- Fiscal Period [FINS_FISCALPERIOD]
FRTCOSTALLOCDOCINCMPLTNSRSN, -- Incomplete Rsn [WLF_INCOMPLETENESS_REASON]
INCOTERMSVERSION, -- Inco. Version [INCOV]
INCOTERMSCLASSIFICATION, -- Incoterms [INCO1]
INCOTERMSTRANSFERLOCATION, -- Incoterms 2 [INCO2]
INCOTERMSLOCATION1, -- Inco. Location1 [INCO2_L]
INCOTERMSLOCATION2, -- Inco. Location2 [INCO3_L]
FRTCOSTALLOCBUSPROCCAT, -- Use Case Type [WLF_USE_CASE_TYPE]
APPLELMNTBEHAVIORGRP, -- Element Behavior Group [WLF_APP_VIS_GRP]
JOURNALENTRYCREATIONDATE, -- Journal Entry Creation Date [WLF_JOURNAL_ENTRY_CRTN_DTE_UTC]
JOURNALENTRYCREATIONTIME, -- Journal Entry Creation Time [WLF_JOURNAL_ENTRY_CRTN_TME_UTC]
FRTCOSTALLOCADJMTCAT, -- Adjustment Category [WLF_SETTLMT_MGMT_ADJMT_CAT]
FRTCOSTALLOCDOCCHANGESTATE, -- Change State [WLF_CHANGE_STATE]
DRAFTENTITYCREATIONDATETIME, -- Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
DUMMY_WBRK_INCL_EEW_PS, -- Dummy [WBRK_INCL_EEW]
PRIMARY KEY (MANDT, FREIGHTCOSTALLOCATIONDOCUMENT, DRAFTUUID)
);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