TWPFI
POS outbound profile
TWPFI is an SAP database table in S/4HANA. POS outbound profile. It contains 37 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PointOfSaleOutboundProfile | view | from | BASIC | Point of Sale Outbound Profile |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | kopro | poskopro | POS Outbnd Prf. | |||
| potyp | possystyp | POS category | ||||
| umtyp | posumstyp | Conv. cat. | ||||
| vzeit | posvzeit | Lead time | ||||
| kurst | kurst | Exch. Rate Type | ||||
| akfin | posaktfind | Promo deter. | ||||
| ermod | poserrmod | Error mode | ||||
| posdex | posdex | EDI | ||||
| sallmg | sallmg | SalesAllMGallwd | ||||
| ekoar | posekoar | Cond. type grp | ||||
| meper | meper | Pers. reduction | ||||
| recdt | recdt | Rec. determin. | ||||
| oksta | oksta | Status comm. OK | ||||
| npmat | npmat | Exclude mat. | ||||
| npfoa | npfoa | No fllw-on itms | ||||
| npset | npset | Exclude sets | ||||
| npmec | npmec | No MG data | ||||
| npcur | npcur | No exchnge rate | ||||
| nptax | nptax | No taxes | ||||
| npcus | npcus | No custmr data | ||||
| ean_art | ean_art | Ref. mat./EAN | ||||
| ean_del | ean_del | Add. del. EAN | ||||
| foa_art | foa_art | FollOn item/Mat | ||||
| mcat_art | mcat_art | Material gp mat | ||||
| no_fabkl | no_fabkl | No fac calendar | ||||
| mestype_plu | mestype_plu | Reduc. material | ||||
| no_bontext | no_bontext | No POS texts | ||||
| promo_rebate | pos_promo_rebate | Promo.Discount | ||||
| prices_siteindep | pos_prices_site_indep | Pr. StoreIndep. | ||||
| pricing_direct | pos_pricing_direct | DirectPr.Upload | ||||
| pricing_direct_mult_access | pos_pricing_direct_mult_access | DirectPr.Upl.MS | ||||
| prices_in_a071 | pos_prices_in_a071 | Prices in A071 | ||||
| no_warnings | pos_no_warnings | Warning-> Notes | ||||
| taxes_copy | pos_taxes_copy | Copy Tax Code | ||||
| no_trigger | no_trigger | No Trigger | ||||
| not_check_sales_per | not_check_sales_per | Deact.Sls.Prd.Chk |
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.
-- POS outbound profile
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWPFI (
MANDT, -- Client [mandt]
KOPRO, -- POS Outbnd Prf. [poskopro]
POTYP, -- POS category [possystyp]
UMTYP, -- Conv. cat. [posumstyp]
VZEIT, -- Lead time [posvzeit]
KURST, -- Exch. Rate Type [kurst]
AKFIN, -- Promo deter. [posaktfind]
ERMOD, -- Error mode [poserrmod]
POSDEX, -- EDI [posdex]
SALLMG, -- SalesAllMGallwd [sallmg]
EKOAR, -- Cond. type grp [posekoar]
MEPER, -- Pers. reduction [meper]
RECDT, -- Rec. determin. [recdt]
OKSTA, -- Status comm. OK [oksta]
NPMAT, -- Exclude mat. [npmat]
NPFOA, -- No fllw-on itms [npfoa]
NPSET, -- Exclude sets [npset]
NPMEC, -- No MG data [npmec]
NPCUR, -- No exchnge rate [npcur]
NPTAX, -- No taxes [nptax]
NPCUS, -- No custmr data [npcus]
EAN_ART, -- Ref. mat./EAN [ean_art]
EAN_DEL, -- Add. del. EAN [ean_del]
FOA_ART, -- FollOn item/Mat [foa_art]
MCAT_ART, -- Material gp mat [mcat_art]
NO_FABKL, -- No fac calendar [no_fabkl]
MESTYPE_PLU, -- Reduc. material [mestype_plu]
NO_BONTEXT, -- No POS texts [no_bontext]
PROMO_REBATE, -- Promo.Discount [pos_promo_rebate]
PRICES_SITEINDEP, -- Pr. StoreIndep. [pos_prices_site_indep]
PRICING_DIRECT, -- DirectPr.Upload [pos_pricing_direct]
PRICING_DIRECT_MULT_ACCESS, -- DirectPr.Upl.MS [pos_pricing_direct_mult_access]
PRICES_IN_A071, -- Prices in A071 [pos_prices_in_a071]
NO_WARNINGS, -- Warning-> Notes [pos_no_warnings]
TAXES_COPY, -- Copy Tax Code [pos_taxes_copy]
NO_TRIGGER, -- No Trigger [no_trigger]
NOT_CHECK_SALES_PER, -- Deact.Sls.Prd.Chk [not_check_sales_per]
PRIMARY KEY (MANDT, KOPRO)
);
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