_OPERATIONALACCTGDOCITEM

167 Fields

_OPERATIONALACCTGDOCITEM is an SAP database table in S/4HANA. It contains 167 fields.

Fields (167)

KeyField CDS FieldsUsed in Views
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY InvoiceItemReference InvoiceItemReference 2
_CreditControlAreaCurrency _CreditControlAreaCurrency 1
_GoodsMovementEntryUnit _GoodsMovementEntryUnit 1
_PartnerBusinessArea _PartnerBusinessArea 1
_PartnerCompany _PartnerCompany 1
_PaymentCurrency _PaymentCurrency 1
_Product _Product 1
_PurchasingDocumentPriceUnit _PurchasingDocumentPriceUnit 1
_SupplyingCountry _SupplyingCountry 1
_TaxType _TaxType 1
AccountAssignmentNumber AccountAssignmentNumber 1
AccountingDocument ClearedInvoiceNumber,clearingInvoice 2
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentItemRef AccountingDocumentItemRef 1
AccountingDocumentItemType AccountingDocumentItemType 1
AccountingDocumentType AccountingDocumentType 3
AccountsReceivableIsPledged AccountsReceivableIsPledged 1
AcctsReceivablePledgingCode AcctsReceivablePledgingCode 1
AdditionalCurrency1 AdditionalCurrency1 2
AdditionalCurrency2 AdditionalCurrency2 2
AddressAndBankIsSetManually AddressAndBankIsSetManually 2
AlternativePayeePayer AlternativePayeePayer 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
AssetContract AssetContract 1
AssignmentReference AssignmentReference 3
BaseUnit BaseUnit,BaseUnitofMeasure 2
BillingDocument BillingDocument 3
BillOfExchangeUsage BillOfExchangeUsage 3
BillOfExchangeUsageDocument BillOfExchangeUsageDocument 1
BPBankAccountInternalID BPBankAccountInternalID 1
BranchAccount BranchAccount 1
BranchCode BranchCode 1
BusinessArea BusinessArea 1
BusinessPlace BusinessPlace 6
CashDiscount1DueDate CashDiscount1DueDate 1
CashDiscount2DueDate CashDiscount2DueDate 1
CashFlowType CashFlowType 1
ClearingAccountingDocument ClearingAccountingDocument 3
ClearingCreationDate ClearingCreationDate 2
ClearingDate ClearingDate 3
ClearingDocFiscalYear ClearingDocFiscalYear 1
ClearingIsReversed ClearingIsReversed 1
ClearingJournalEntry clearingJounralEntry,ClearingJournalEntry 5
CommitmentItem CommitmentItem 2
CommitmentItemShortID CommitmentItemShortID 1
CompanyCodeCurrencyDetnMethod CompanyCodeCurrencyDetnMethod 1
ControllingArea ControllingArea 2
CorporateGroupAccount CorporateGroupAccount 2
CostCenter CostCenter 2
CostElement CostElement 2
CostObject CostObject 1
CreditControlArea CreditControlArea 1
CreditControlAreaCurrency CreditControlAreaCurrency 1
Customer Customer 5
CustomerIsInExecution CustomerIsInExecution 1
DataExchangeInstruction1 DataExchangeInstruction1 1
DataExchangeInstruction2 DataExchangeInstruction2 1
DataExchangeInstruction3 DataExchangeInstruction3 1
DataExchangeInstruction4 DataExchangeInstruction4 1
DebitCreditCode DebitCreditCode 3
DelivOfGoodsDestCountry DelivOfGoodsDestCountry 2
DelivOfGoodsOriginCountry DelivOfGoodsOriginCountry 1
DocumentDate DocumentDate 5
DocumentItemText DocumentItemText 5
DueCalculationBaseDate DueCalculationBaseDate 1
DunningArea DunningArea 1
DunningBlockingReason DunningBlockingReason 2
DunningKey DunningKey 1
DunningLevel DunningLevel 2
FinancialAccountType FinancialAccountType 4
FiscalPeriod FiscalPeriod 1
FiscalYear ClearedInvoiceYear 1
FixedCashDiscount FixedCashDiscount 1
FollowOnDocumentType FollowOnDocumentType 1
GLAccount GLAccount 3
GoodsMovementEntryUnit GoodsMovementEntryUnit 1
HasPaymentOrder HasPaymentOrder 2
HouseBank HouseBank 1
IN_GSTPartner IN_GSTPartner 1
IN_GSTPlaceOfSupply IN_GSTPlaceOfSupply 1
IN_HSNOrSACCode IN_HSNOrSACCode 1
InvoiceList InvoiceList 1
InvoiceReference InvoiceReference 3
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
IsAutomaticallyCreated IsAutomaticallyCreated 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
IsCompletelyDelivered IsCompletelyDelivered 1
IsEUTriangularDeal IsEUTriangularDeal 1
IsNegativePosting IsNegativePosting 2
IsNotCashDiscountLiable IsNotCashDiscountLiable 1
IsSalesRelated IsSalesRelated 2
IsUsedInPaymentTransaction IsUsedInPaymentTransaction 2
LastDunningDate LastDunningDate 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
MasterFixedAsset MasterFixedAsset 1
Material Material,MaterialNumber 2
MaterialPriceUnitQty MaterialPriceUnitQty 1
NonDcblTaxAbsltAmtInCoCodeCrcy NonDcblTaxAbsltAmtInCoCodeCrcy 1
NonDcblTaxAbsltAmtInTransCrcy NonDcblTaxAbsltAmtInTransCrcy 1
OperationalGLAccount OperationalGLAccount 2
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
OrderInternalBillOfOperations OrderInternalBillOfOperations 1
OriginalReferenceDocument OriginalReferenceDocument 1
PartnerBusinessArea PartnerBusinessArea 1
PartnerCompany PartnerCompany 1
PaymentBlockingReason PaymentBlockingReason 2
PaymentCardItem PaymentCardItem 1
PaymentCardPaymentSettlement PaymentCardPaymentSettlement 1
PaymentCurrency PaymentCurrency 1
PaymentDifferenceReason PaymentDifferenceReason 2
PaymentMethod PaymentMethod 5
PaymentMethodSupplement PaymentMethodSupplement 2
PaymentRefByPaytSrvcProvider PaymentRefByPaytSrvcProvider 1
PaymentReference PaymentReference 1
PaymentServiceProvider PaymentServiceProvider 1
PaymentTerms PaymentTerms 1
PaytSlipWthRefReference PaytSlipWthRefReference 1
PaytSlipWthRefSubscriber PaytSlipWthRefSubscriber 1
PlanningLevel PlanningLevel 1
Plant Plant 1
PostingDate PostingDate 1
PostingKey PostingKey 4
Product Product 1
ProfitCenter ProfitCenter 2
ProfitLossAccountType ProfitLossAccountType 1
PurchasingDocument PurchaseOrder,PurchasingDocument 2
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingDocumentPriceUnit PurchasingDocumentPriceUnit 1
Quantity Quantity,Totalquantity 2
RealEstateObject RealEstateObject 1
RecrrgSuplrInvcIsSrvcInvoice RecrrgSuplrInvcIsSrvcInvoice 1
Reference1IDByBusinessPartner Reference1IDByBusinessPartner 5
Reference2IDByBusinessPartner Reference2IDByBusinessPartner 4
Reference3IDByBusinessPartner Reference3IDByBusinessPartner 4
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem 1
Region Region 1
REInternalFinNumber REInternalFinNumber 1
ScheduleLine ScheduleLine 1
SEPAMandate SEPAMandate 1
SpecialGLAccountAssignment SpecialGLAccountAssignment 1
SpecialGLCode SpecialGLCode 6
SpecialGLTransactionType SpecialGLTransactionType 2
StateCentralBankPaymentReason StateCentralBankPaymentReason 1
Supplier Supplier 4
SupplyingCountry SupplyingCountry 2
TaxAbsltAmtInAddlCurrency1 TaxAmountInAdditionalCurrency1 1
TaxAbsltAmtInAddlCurrency2 TaxAmountInAdditionalCurrency2 1
TaxCode TaxCode 2
TaxCompanyCode TaxCompanyCode 1
TaxCountry TaxCountry 1
TaxDeterminationDate TaxDeterminationDate 1
TaxDistributionCode1 TaxDistributionCode1 1
TaxDistributionCode2 TaxDistributionCode2 1
TaxDistributionCode3 TaxDistributionCode3 1
TaxJurisdiction TaxJurisdiction 2
TaxSection TaxSection 1
TaxType TaxType 2
TransactionCurrency Currency,TransactionCurrency 3
TreasuryContractType TreasuryContractType 1
ValueDate ValueDate 1
VATRegistration VATRegistration 2
WBSElementInternalID WBSElementInternalID 1
WithholdingTaxAmount WithholdingTaxAmount 1
WithholdingTaxBaseAmount WithholdingTaxBaseAmount 1
WithholdingTaxCertificate WithholdingTaxCertificate 1
WithholdingTaxCode WithholdingTaxCode 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _OPERATIONALACCTGDOCITEM (
    ACCOUNTINGDOCUMENTITEM,
    INVOICEITEMREFERENCE,
    _CREDITCONTROLAREACURRENCY,
    _GOODSMOVEMENTENTRYUNIT,
    _PARTNERBUSINESSAREA,
    _PARTNERCOMPANY,
    _PAYMENTCURRENCY,
    _PRODUCT,
    _PURCHASINGDOCUMENTPRICEUNIT,
    _SUPPLYINGCOUNTRY,
    _TAXTYPE,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEMREF,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTSRECEIVABLEISPLEDGED,
    ACCTSRECEIVABLEPLEDGINGCODE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ADDRESSANDBANKISSETMANUALLY,
    ALTERNATIVEPAYEEPAYER,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCONTRACT,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BILLINGDOCUMENT,
    BILLOFEXCHANGEUSAGE,
    BILLOFEXCHANGEUSAGEDOCUMENT,
    BPBANKACCOUNTINTERNALID,
    BRANCHACCOUNT,
    BRANCHCODE,
    BUSINESSAREA,
    BUSINESSPLACE,
    CASHDISCOUNT1DUEDATE,
    CASHDISCOUNT2DUEDATE,
    CASHFLOWTYPE,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGCREATIONDATE,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGISREVERSED,
    CLEARINGJOURNALENTRY,
    COMMITMENTITEM,
    COMMITMENTITEMSHORTID,
    COMPANYCODECURRENCYDETNMETHOD,
    CONTROLLINGAREA,
    CORPORATEGROUPACCOUNT,
    COSTCENTER,
    COSTELEMENT,
    COSTOBJECT,
    CREDITCONTROLAREA,
    CREDITCONTROLAREACURRENCY,
    CUSTOMER,
    CUSTOMERISINEXECUTION,
    DATAEXCHANGEINSTRUCTION1,
    DATAEXCHANGEINSTRUCTION2,
    DATAEXCHANGEINSTRUCTION3,
    DATAEXCHANGEINSTRUCTION4,
    DEBITCREDITCODE,
    DELIVOFGOODSDESTCOUNTRY,
    DELIVOFGOODSORIGINCOUNTRY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DUECALCULATIONBASEDATE,
    DUNNINGAREA,
    DUNNINGBLOCKINGREASON,
    DUNNINGKEY,
    DUNNINGLEVEL,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDCASHDISCOUNT,
    FOLLOWONDOCUMENTTYPE,
    GLACCOUNT,
    GOODSMOVEMENTENTRYUNIT,
    HASPAYMENTORDER,
    HOUSEBANK,
    IN_GSTPARTNER,
    IN_GSTPLACEOFSUPPLY,
    IN_HSNORSACCODE,
    INVOICELIST,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISAUTOMATICALLYCREATED,
    ISBALANCESHEETACCOUNT,
    ISCOMPLETELYDELIVERED,
    ISEUTRIANGULARDEAL,
    ISNEGATIVEPOSTING,
    ISNOTCASHDISCOUNTLIABLE,
    ISSALESRELATED,
    ISUSEDINPAYMENTTRANSACTION,
    LASTDUNNINGDATE,
    LINEITEMDISPLAYISENABLED,
    MASTERFIXEDASSET,
    MATERIAL,
    MATERIALPRICEUNITQTY,
    NONDCBLTAXABSLTAMTINCOCODECRCY,
    NONDCBLTAXABSLTAMTINTRANSCRCY,
    OPERATIONALGLACCOUNT,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALBILLOFOPERATIONS,
    ORIGINALREFERENCEDOCUMENT,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PAYMENTBLOCKINGREASON,
    PAYMENTCARDITEM,
    PAYMENTCARDPAYMENTSETTLEMENT,
    PAYMENTCURRENCY,
    PAYMENTDIFFERENCEREASON,
    PAYMENTMETHOD,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREFBYPAYTSRVCPROVIDER,
    PAYMENTREFERENCE,
    PAYMENTSERVICEPROVIDER,
    PAYMENTTERMS,
    PAYTSLIPWTHREFREFERENCE,
    PAYTSLIPWTHREFSUBSCRIBER,
    PLANNINGLEVEL,
    PLANT,
    POSTINGDATE,
    POSTINGKEY,
    PRODUCT,
    PROFITCENTER,
    PROFITLOSSACCOUNTTYPE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTPRICEUNIT,
    QUANTITY,
    REALESTATEOBJECT,
    RECRRGSUPLRINVCISSRVCINVOICE,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCE2IDBYBUSINESSPARTNER,
    REFERENCE3IDBYBUSINESSPARTNER,
    REFERENCEDOCUMENTLOGICALSYSTEM,
    REGION,
    REINTERNALFINNUMBER,
    SCHEDULELINE,
    SEPAMANDATE,
    SPECIALGLACCOUNTASSIGNMENT,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    STATECENTRALBANKPAYMENTREASON,
    SUPPLIER,
    SUPPLYINGCOUNTRY,
    TAXABSLTAMTINADDLCURRENCY1,
    TAXABSLTAMTINADDLCURRENCY2,
    TAXCODE,
    TAXCOMPANYCODE,
    TAXCOUNTRY,
    TAXDETERMINATIONDATE,
    TAXDISTRIBUTIONCODE1,
    TAXDISTRIBUTIONCODE2,
    TAXDISTRIBUTIONCODE3,
    TAXJURISDICTION,
    TAXSECTION,
    TAXTYPE,
    TRANSACTIONCURRENCY,
    TREASURYCONTRACTTYPE,
    VALUEDATE,
    VATREGISTRATION,
    WBSELEMENTINTERNALID,
    WITHHOLDINGTAXAMOUNT,
    WITHHOLDINGTAXBASEAMOUNT,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENTITEM, INVOICEITEMREFERENCE)
);

Learn More