DFKKOP_D

Transparent Table Application Table
160 Fields 1 CDS Views

Draft table for entity R_CADocumentBPItemTP

DFKKOP_D is an SAP database table in S/4HANA. Draft table for entity R_CADocumentBPItemTP. It contains 160 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CADocumentBPItemDraft view_entity from BASIC Document Business Partner Item - Draft

Fields (160)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cadocumentnumber opbel_kk Document Number
KEY carepetitionitemnumber opupw_kk Repetition Item
KEY cabpitemnumber opupk_kk Item
KEY casubitemnumber opupz_kk Subitem
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
creationdate cpudt_op_kk Created On
creationtime cputm_op_kk Created On
lastchangedate aedat Changed On
lastchangetime aetim_kk Time
companycode bukrs Company Code
businessarea gsber Business Area
businessplace bupla Business place
segment segmt_kk Segment
profitcenter prctr Profit Center
division spart_kk Division
personnelnumber pernr_d Personnel No.
partnercompany rassc Trading Partner
businesspartner gpart_kk Bus. Partner
cacontract vtref_kk Contract
caprovidercontractitemnumber vtpos_kk Contract Item
caadditionalcontract vtre2_kk Addl. Reference
contractaccount vkont_kk Contract Acct
casubapplication subap_kk Subapplication
altvcontractacctforcollvbills abwvk_kk Coll. Bill Acct
careconciliationaccount hkont_kk G/L Account
caapplicationarea applk_kk ApplicationArea
camaintransaction hvorg_kk Main Trans.
casubtransaction tvorg_kk Subtransaction
caaccountdeterminationcode kofiz_kk Acct Determ. ID
cadoubtfulorvalueadjmtcode infoz_kk Doubtful item
caaccountassignmentcategory kontt_kk Acct Assgt Cat.
caaccountassignment kontl_kk Acct assignment
cadocumenttype blart_kk Document Type
caisdownpaymentrequest xanza_kk Down Payment
caitemisonlyforsettlement verkz_kk Only Clearing
castatisticalitemcode stakz_kk Statistical key
cabpitemtext optxt_kk Text
canumberofrepetitionitems whang_kk No. repetitions
carepetitiongroup whgrp_kk Repetition grp
castartdateofbillingperiod abrzu_kk Billing Period
caenddateofbillingperiod abrzo_kk Bill Period
cagroupingcodeforbpitems grkey_kk Grouping key
caperiodcode persl_kk Period Key
cachangeisforbidden xaesp_kk Change lock
cainterestcode ikey_kk Interest key
caroundingitemcode rndps_kk Rndg item
careceivingcountry landl_kk Destination C/R
cainternalpostingreasoncode intbu_kk Posting Reason
caworkflowcheckreason c4eye_kk Check Reason
caworkflowcheckprocess c4eyp_kk Process
canegativepostingcontrolcode negbu_kk Negative Pstng
capartnersettlementstatus ptitm_kk Revenue Sharing
caispartofjointliability palix_kk Collab. Liability
cadocumentorigincode herkf_kk Document Origin
cagroupingkeydocumentitems psgrp_kk Item Grouping
casubstitutedocumentnumber abwbl_kk Sub. Doc.
casubstitutedocumentcategory abwtp_kk Doc.Cat.
castatisticalcodeoforiginitem astkz_kk Trig. Stat. Key
cadocumentnumberoforiginitem asblg_kk Trig. Document
careferencedocument xblnr_kk Reference
caclassificationkey opord_kk Classif. Key
documentdate bldat Document Date
capostingdate budat Posting Date
canetduedate faedn_kk Net Due Date
cadeferraldate studt_kk Deferral To
transactioncurrency blwae_kk Currency
companycodecurrency waers Currency
additionalcurrency1 waers Currency
additionalcurrency2 waers Currency
caexchangerate fis_absolute_exchangerate Absolute Exchange Rate
exchrateisindirectquotation fis_indirect_quotation Exchange Rate Is Indirect Quotation
caamountinlocalcurrency betrh_kk Local Crcy Amt
caamountintransactioncurrency betrw_kk Amount
caamountinsecondcurrency betr2_kk Amount in LC 2
caamountinthirdcurrency betr3_kk Amount in LC3
cadocbpitemtotalamountintc oriop_kk Total Amount
cadocbpitemoriglopenamountintc augia_kk Amount
caclearingdeductionamountintc augda_kk
cacashdiscountduedate faeds_kk Disct Due Date
cacashdiscountrate sktpz_kk Discount rate
caeligibleamountforcshdiscount skfbt_kk Disc. base
taxcode mwskz Tax Code
casupplementarytaxcode mwszkz_kk Supplem. Tax
cataxamountinlocalcurrency sbeth_kk LC Tax
cataxamountintranscurrency sbetw_kk Tax Amount
cataxamountinsecondcurrency sbet2_kk LC 2 Tax
cataxamountinthirdcurrency sbet3_kk LC 3 tax
cadownpaymenttaxaccount mwsko_kk Tax Account
cadownpaymentoffsettaxaccount mwvko_kk Offset tax acct
taxjurisdiction txjcd Tax Jur.
cataxdate txdat_kk Tax Date
withholdingtaxcode qsskz WTax Code
cawithholdingtaxsupplement qssew_kk WT supplmt
cawithholdingtaxcategory qsptp_kk W/Htx item cat.
cabaseamountforwithholdingtax qsshb_kk Tax base amount
cawithholdingtaxamount qbshb_kk Withholding tax
cawithholdingtaxpercentage qsprz_kk Withholding Tax Pct
withholdingtaxcertificate qsznr Exemption No.
caothertaxcode strkz_kk TxCde:Oth.Taxes
cagroupingcodefortaxitems txgrp_kk Tax Group
cataxportioninlocalcurrency sctax_kk FI-CA Tax Portion
cataxportionintranscurrency sttax_kk Tax Portion
cataxiscalculatedexternally xustpd_kk Tax by Document
cataxamountissetfromexternal inttx_kk TX Characteris.
taxcountry fot_tax_country Tax Ctry/Reg.
transtotaxcntrycrcycnvrsnfctr taxc_factor_kk Tax Factor C/R
capaymentmethod pymet_kk Payment Method
capaymentcompanycode pybuk_kk Paying Co. Code
cagroupingforpayment pygrp_kk Pymt Grouping
capaymentspecificationcategory pdtyp_kk Category
caclearingstatus augst_kk Clearing Status
caclearingdate augdt_kk Clearing
caclearingdocumentnumber augbl_kk Clearing Doc.
capostingdateofclearingdoc augbd_kk Clrg Post. Date
caclearingreason augrd_kk Clearing Reason
caclearingcurrency augwa_kk Clearing Curr.
caclearingamountinclearingcrcy augbt_kk Clearing Amount
cataxamountinclearingcrcy augbs_kk Cl.Crcy Tax Amt
cacashdiscamountinclearingcrcy augsk_kk Discnt/Surchrge
cavaluedateforclearing augvd_kk Clear.Val.Date
caclearingrestrictioncode augrs_kk Restriction
caclearingpostingisreset xragl_kk Reverse clrg
caitemiswithdrawn augob_kk Canceled
caitemisexcludedfromdunning xmanl_kk Cannot Be Dunn.
cadunningprocedure mahnv_kk Dunning Proc.
cagrpgcodefortransftocollagcy inkps_kk Collection item
caisincludedincollectioncase xcolc_kk Collection Case
cashplanninggroup fdgrp_kk Planning group
planninglevel fdlev_kk Planning level
caadditionaldaysforcashmgmt fdztg_kk CM Extra Days
plannedamtintransactioncrcy fis_fdwbt Plnd Amt Trans. Crcy
caaltvbpforpayment emgpa_kk Partner
cabankofaltvbpforpayment embvt_kk Bank Details
caaddressofaltvbpforpayment ad_addrnum Address Number
cacardofaltvbpforpayment emcrd_kk Card ID
sepamandatecainternalid emmnd_kk Mandate Ref.
caglpostingcurrency pswsl_kk G/L Currency
caglpostingamount pswbt_kk G/L Amount
caglpostingtaxamount pswtx_kk G/L Tax Amount
caisseparatelineitemingl xeiph_kk Line item
caiscashflowitem xcsha_kk Cash Flow
cacashflowaccount reacc_kk Cash Flow Acct
cacashflowcompanycode rebuk_kk Cash Flow CoCd
capaymentprenotificationcode xpyor_kk Payment Order
casepaprenotificationnumber pnnum_kk Pre-Notif.
casepaprenotiforigincode pnhkf_kk Mandate Origin
casepaprenotifexecutiondate pnexd_kk Exec.Date
casepaprenotificationrqmtcode pnctr_kk Requirement
carevenuedistrfinalrecipient finre_kk Final Recipient
carevenuedistrcurrentstatus rdsta_kk Current Status
carevenuedistrlaststatus rdstb_kk Last Status
cacurrentfactoringstatusofrbl fasta_kk Receivable Status
cafactoringcheckstsforclrginfo pasta_kk Check Status
cafactoringitem opupf_kk Subitem
controllingarea kokrs CO Area
chartofaccounts ktopl Chart of Accts
country land1 Country/Reg.
taxcalculationprocedure kalsm_d Procedure

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_CADocumentBPItemTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOP_D (
    MANDT,                           -- Client [mandt]
    CADOCUMENTNUMBER,                -- Document Number [opbel_kk]
    CAREPETITIONITEMNUMBER,          -- Repetition Item [opupw_kk]
    CABPITEMNUMBER,                  -- Item [opupk_kk]
    CASUBITEMNUMBER,                 -- Subitem [opupz_kk]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    CREATIONDATE,                    -- Created On [cpudt_op_kk]
    CREATIONTIME,                    -- Created On [cputm_op_kk]
    LASTCHANGEDATE,                  -- Changed On [aedat]
    LASTCHANGETIME,                  -- Time [aetim_kk]
    COMPANYCODE,                     -- Company Code [bukrs]
    BUSINESSAREA,                    -- Business Area [gsber]
    BUSINESSPLACE,                   -- Business place [bupla]
    SEGMENT,                         -- Segment [segmt_kk]
    PROFITCENTER,                    -- Profit Center [prctr]
    DIVISION,                        -- Division [spart_kk]
    PERSONNELNUMBER,                 -- Personnel No. [pernr_d]
    PARTNERCOMPANY,                  -- Trading Partner [rassc]
    BUSINESSPARTNER,                 -- Bus. Partner [gpart_kk]
    CACONTRACT,                      -- Contract [vtref_kk]
    CAPROVIDERCONTRACTITEMNUMBER,    -- Contract Item [vtpos_kk]
    CAADDITIONALCONTRACT,            -- Addl. Reference [vtre2_kk]
    CONTRACTACCOUNT,                 -- Contract Acct [vkont_kk]
    CASUBAPPLICATION,                -- Subapplication [subap_kk]
    ALTVCONTRACTACCTFORCOLLVBILLS,   -- Coll. Bill Acct [abwvk_kk]
    CARECONCILIATIONACCOUNT,         -- G/L Account [hkont_kk]
    CAAPPLICATIONAREA,               -- ApplicationArea [applk_kk]
    CAMAINTRANSACTION,               -- Main Trans. [hvorg_kk]
    CASUBTRANSACTION,                -- Subtransaction [tvorg_kk]
    CAACCOUNTDETERMINATIONCODE,      -- Acct Determ. ID [kofiz_kk]
    CADOUBTFULORVALUEADJMTCODE,      -- Doubtful item [infoz_kk]
    CAACCOUNTASSIGNMENTCATEGORY,     -- Acct Assgt Cat. [kontt_kk]
    CAACCOUNTASSIGNMENT,             -- Acct assignment [kontl_kk]
    CADOCUMENTTYPE,                  -- Document Type [blart_kk]
    CAISDOWNPAYMENTREQUEST,          -- Down Payment [xanza_kk]
    CAITEMISONLYFORSETTLEMENT,       -- Only Clearing [verkz_kk]
    CASTATISTICALITEMCODE,           -- Statistical key [stakz_kk]
    CABPITEMTEXT,                    -- Text [optxt_kk]
    CANUMBEROFREPETITIONITEMS,       -- No. repetitions [whang_kk]
    CAREPETITIONGROUP,               -- Repetition grp [whgrp_kk]
    CASTARTDATEOFBILLINGPERIOD,      -- Billing Period [abrzu_kk]
    CAENDDATEOFBILLINGPERIOD,        -- Bill Period [abrzo_kk]
    CAGROUPINGCODEFORBPITEMS,        -- Grouping key [grkey_kk]
    CAPERIODCODE,                    -- Period Key [persl_kk]
    CACHANGEISFORBIDDEN,             -- Change lock [xaesp_kk]
    CAINTERESTCODE,                  -- Interest key [ikey_kk]
    CAROUNDINGITEMCODE,              -- Rndg item [rndps_kk]
    CARECEIVINGCOUNTRY,              -- Destination C/R [landl_kk]
    CAINTERNALPOSTINGREASONCODE,     -- Posting Reason [intbu_kk]
    CAWORKFLOWCHECKREASON,           -- Check Reason [c4eye_kk]
    CAWORKFLOWCHECKPROCESS,          -- Process [c4eyp_kk]
    CANEGATIVEPOSTINGCONTROLCODE,    -- Negative Pstng [negbu_kk]
    CAPARTNERSETTLEMENTSTATUS,       -- Revenue Sharing [ptitm_kk]
    CAISPARTOFJOINTLIABILITY,        -- Collab. Liability [palix_kk]
    CADOCUMENTORIGINCODE,            -- Document Origin [herkf_kk]
    CAGROUPINGKEYDOCUMENTITEMS,      -- Item Grouping [psgrp_kk]
    CASUBSTITUTEDOCUMENTNUMBER,      -- Sub. Doc. [abwbl_kk]
    CASUBSTITUTEDOCUMENTCATEGORY,    -- Doc.Cat. [abwtp_kk]
    CASTATISTICALCODEOFORIGINITEM,   -- Trig. Stat. Key [astkz_kk]
    CADOCUMENTNUMBEROFORIGINITEM,    -- Trig. Document [asblg_kk]
    CAREFERENCEDOCUMENT,             -- Reference [xblnr_kk]
    CACLASSIFICATIONKEY,             -- Classif. Key [opord_kk]
    DOCUMENTDATE,                    -- Document Date [bldat]
    CAPOSTINGDATE,                   -- Posting Date [budat]
    CANETDUEDATE,                    -- Net Due Date [faedn_kk]
    CADEFERRALDATE,                  -- Deferral To [studt_kk]
    TRANSACTIONCURRENCY,             -- Currency [blwae_kk]
    COMPANYCODECURRENCY,             -- Currency [waers]
    ADDITIONALCURRENCY1,             -- Currency [waers]
    ADDITIONALCURRENCY2,             -- Currency [waers]
    CAEXCHANGERATE,                  -- Absolute Exchange Rate [fis_absolute_exchangerate]
    EXCHRATEISINDIRECTQUOTATION,     -- Exchange Rate Is Indirect Quotation [fis_indirect_quotation]
    CAAMOUNTINLOCALCURRENCY,         -- Local Crcy Amt [betrh_kk]
    CAAMOUNTINTRANSACTIONCURRENCY,   -- Amount [betrw_kk]
    CAAMOUNTINSECONDCURRENCY,        -- Amount in LC 2 [betr2_kk]
    CAAMOUNTINTHIRDCURRENCY,         -- Amount in LC3 [betr3_kk]
    CADOCBPITEMTOTALAMOUNTINTC,      -- Total Amount [oriop_kk]
    CADOCBPITEMORIGLOPENAMOUNTINTC,  -- Amount [augia_kk]
    CACLEARINGDEDUCTIONAMOUNTINTC,   -- augda_kk
    CACASHDISCOUNTDUEDATE,           -- Disct Due Date [faeds_kk]
    CACASHDISCOUNTRATE,              -- Discount rate [sktpz_kk]
    CAELIGIBLEAMOUNTFORCSHDISCOUNT,  -- Disc. base [skfbt_kk]
    TAXCODE,                         -- Tax Code [mwskz]
    CASUPPLEMENTARYTAXCODE,          -- Supplem. Tax [mwszkz_kk]
    CATAXAMOUNTINLOCALCURRENCY,      -- LC Tax [sbeth_kk]
    CATAXAMOUNTINTRANSCURRENCY,      -- Tax Amount [sbetw_kk]
    CATAXAMOUNTINSECONDCURRENCY,     -- LC 2 Tax [sbet2_kk]
    CATAXAMOUNTINTHIRDCURRENCY,      -- LC 3 tax [sbet3_kk]
    CADOWNPAYMENTTAXACCOUNT,         -- Tax Account [mwsko_kk]
    CADOWNPAYMENTOFFSETTAXACCOUNT,   -- Offset tax acct [mwvko_kk]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    CATAXDATE,                       -- Tax Date [txdat_kk]
    WITHHOLDINGTAXCODE,              -- WTax Code [qsskz]
    CAWITHHOLDINGTAXSUPPLEMENT,      -- WT supplmt [qssew_kk]
    CAWITHHOLDINGTAXCATEGORY,        -- W/Htx item cat. [qsptp_kk]
    CABASEAMOUNTFORWITHHOLDINGTAX,   -- Tax base amount [qsshb_kk]
    CAWITHHOLDINGTAXAMOUNT,          -- Withholding tax [qbshb_kk]
    CAWITHHOLDINGTAXPERCENTAGE,      -- Withholding Tax Pct [qsprz_kk]
    WITHHOLDINGTAXCERTIFICATE,       -- Exemption No. [qsznr]
    CAOTHERTAXCODE,                  -- TxCde:Oth.Taxes [strkz_kk]
    CAGROUPINGCODEFORTAXITEMS,       -- Tax Group [txgrp_kk]
    CATAXPORTIONINLOCALCURRENCY,     -- FI-CA Tax Portion [sctax_kk]
    CATAXPORTIONINTRANSCURRENCY,     -- Tax Portion [sttax_kk]
    CATAXISCALCULATEDEXTERNALLY,     -- Tax by Document [xustpd_kk]
    CATAXAMOUNTISSETFROMEXTERNAL,    -- TX Characteris. [inttx_kk]
    TAXCOUNTRY,                      -- Tax Ctry/Reg. [fot_tax_country]
    TRANSTOTAXCNTRYCRCYCNVRSNFCTR,   -- Tax Factor C/R [taxc_factor_kk]
    CAPAYMENTMETHOD,                 -- Payment Method [pymet_kk]
    CAPAYMENTCOMPANYCODE,            -- Paying Co. Code [pybuk_kk]
    CAGROUPINGFORPAYMENT,            -- Pymt Grouping [pygrp_kk]
    CAPAYMENTSPECIFICATIONCATEGORY,  -- Category [pdtyp_kk]
    CACLEARINGSTATUS,                -- Clearing Status [augst_kk]
    CACLEARINGDATE,                  -- Clearing [augdt_kk]
    CACLEARINGDOCUMENTNUMBER,        -- Clearing Doc. [augbl_kk]
    CAPOSTINGDATEOFCLEARINGDOC,      -- Clrg Post. Date [augbd_kk]
    CACLEARINGREASON,                -- Clearing Reason [augrd_kk]
    CACLEARINGCURRENCY,              -- Clearing Curr. [augwa_kk]
    CACLEARINGAMOUNTINCLEARINGCRCY,  -- Clearing Amount [augbt_kk]
    CATAXAMOUNTINCLEARINGCRCY,       -- Cl.Crcy Tax Amt [augbs_kk]
    CACASHDISCAMOUNTINCLEARINGCRCY,  -- Discnt/Surchrge [augsk_kk]
    CAVALUEDATEFORCLEARING,          -- Clear.Val.Date [augvd_kk]
    CACLEARINGRESTRICTIONCODE,       -- Restriction [augrs_kk]
    CACLEARINGPOSTINGISRESET,        -- Reverse clrg [xragl_kk]
    CAITEMISWITHDRAWN,               -- Canceled [augob_kk]
    CAITEMISEXCLUDEDFROMDUNNING,     -- Cannot Be Dunn. [xmanl_kk]
    CADUNNINGPROCEDURE,              -- Dunning Proc. [mahnv_kk]
    CAGRPGCODEFORTRANSFTOCOLLAGCY,   -- Collection item [inkps_kk]
    CAISINCLUDEDINCOLLECTIONCASE,    -- Collection Case [xcolc_kk]
    CASHPLANNINGGROUP,               -- Planning group [fdgrp_kk]
    PLANNINGLEVEL,                   -- Planning level [fdlev_kk]
    CAADDITIONALDAYSFORCASHMGMT,     -- CM Extra Days [fdztg_kk]
    PLANNEDAMTINTRANSACTIONCRCY,     -- Plnd Amt Trans. Crcy [fis_fdwbt]
    CAALTVBPFORPAYMENT,              -- Partner [emgpa_kk]
    CABANKOFALTVBPFORPAYMENT,        -- Bank Details [embvt_kk]
    CAADDRESSOFALTVBPFORPAYMENT,     -- Address Number [ad_addrnum]
    CACARDOFALTVBPFORPAYMENT,        -- Card ID [emcrd_kk]
    SEPAMANDATECAINTERNALID,         -- Mandate Ref. [emmnd_kk]
    CAGLPOSTINGCURRENCY,             -- G/L Currency [pswsl_kk]
    CAGLPOSTINGAMOUNT,               -- G/L Amount [pswbt_kk]
    CAGLPOSTINGTAXAMOUNT,            -- G/L Tax Amount [pswtx_kk]
    CAISSEPARATELINEITEMINGL,        -- Line item [xeiph_kk]
    CAISCASHFLOWITEM,                -- Cash Flow [xcsha_kk]
    CACASHFLOWACCOUNT,               -- Cash Flow Acct [reacc_kk]
    CACASHFLOWCOMPANYCODE,           -- Cash Flow CoCd [rebuk_kk]
    CAPAYMENTPRENOTIFICATIONCODE,    -- Payment Order [xpyor_kk]
    CASEPAPRENOTIFICATIONNUMBER,     -- Pre-Notif. [pnnum_kk]
    CASEPAPRENOTIFORIGINCODE,        -- Mandate Origin [pnhkf_kk]
    CASEPAPRENOTIFEXECUTIONDATE,     -- Exec.Date [pnexd_kk]
    CASEPAPRENOTIFICATIONRQMTCODE,   -- Requirement [pnctr_kk]
    CAREVENUEDISTRFINALRECIPIENT,    -- Final Recipient [finre_kk]
    CAREVENUEDISTRCURRENTSTATUS,     -- Current Status [rdsta_kk]
    CAREVENUEDISTRLASTSTATUS,        -- Last Status [rdstb_kk]
    CACURRENTFACTORINGSTATUSOFRBL,   -- Receivable Status [fasta_kk]
    CAFACTORINGCHECKSTSFORCLRGINFO,  -- Check Status [pasta_kk]
    CAFACTORINGITEM,                 -- Subitem [opupf_kk]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    CHARTOFACCOUNTS,                 -- Chart of Accts [ktopl]
    COUNTRY,                         -- Country/Reg. [land1]
    TAXCALCULATIONPROCEDURE,         -- Procedure [kalsm_d]
    PRIMARY KEY (MANDT, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CABPITEMNUMBER, CASUBITEMNUMBER, DRAFTUUID)
);

Learn More