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 55 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 (55)
| 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 |
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]
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